Triggers

[lash]

Hope someone can help..

I want to respond to the addition of a user to a sql2000 database.

Seemed easy.. just create a trigger on sysusers that responds to INSERTs - but I cant create a trigger on a system table.

Any one have any other ideas.?? - Thanks

 

[tlbroadbent]

Create a job that runs on a schedule (every 30 minutes?) and checks the create date on the sysusers table. If the datetime is within the time interval, send a message or execute a process.

Another possibility is to create a mirror table that lists users. Schedule a job to compare the tables and notify you of changes. The job would add new users to the mirror table after sending notification.

I believe there are 3rd party tools that can track updates to system tables. I don't use any but you may be able to find something using a web search. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.