Gurus: How to put a trigger on SysUsers?

[JohnDTampaBay]

I need to put a trigger on the SysUsers table to email me when users are added or modified. I found the code I thought I needed:

  sp_configure 'allow updates', 1
  Reconfigure With Override
  GO

That should allow me to apply the trigger, but I still get a "permission denied" error. What gives? What piece am I missing to make this work? Any ideas? --Angel
-----------------------------------
SELECT * FROM users WHERE clue > 0
(0 row(s) affected)

 

[tlbroadbent]

You are not allowed to put triggers on system tables. Those tables can be modified or eliminated in the next version of SQL Server. You can create a table to hold a list of users and then create a procedure to compare the sysusers table to the list and notofy you of any changes.

There are 3rd party audit tools that will track these kind of changes for you. In addition, you can capture SQL events using SQL Trace. 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.