Is there any time based trigger in sql server 2005??

[arsheena.alam]

Hi,

I have a table that stores records of students. Now what I want is that after a particular period of time the account of the student gets disabled automatically. Is there any time based trigger that can be hit automatically if i set the time limit for that. Or can there be any other method for the same.

URGENT HELP NEEDED...

Thanks in advance.. :)

[adam_k]

If you've got the last activity date (or what you want to use as criteria) you can create an update query to disable your users and set a job in SQL Agent to run in set intervals (from every second up to once a month or on set dates) and get the job done.