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.. :)
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.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.