Why not just store the last date/time accessed in each counters record. Then, your SP can see if it is a different day, and if so, reset the counter. Or, you could create a scheduled task on your server to run an SP at midnight every day, or whatever.
BOb
>Thanks Bob for your answer!
>
>but I can't figure out how to reset the user-defined counter, I imagine a task that runs everyday (12:00 pm) and reset this counter to 1, I have heard about packages that runs periodically scripts or several task but this packages always export or import data, is it possible that runs directly 'sprocs'?
>
>Regards
>
>Martin Alcaraz
>
malcaraz@rtn.uson.mx