Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
opowell
Starting Member
12 Posts |
 Posted - 2011-07-15 : 10:47:10
|
| I have a very large enviroment and attempting to see who has been granted sysadmin, as me losing what little hiar I have left. I want to create a alert that will fire when someone is granted the sysadmin priv..Is there a away to create such a SQL ALERT?Knowledge as a very important PropertyIf you give it away you never lose it. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-07-15 : 12:05:13
|
| You could create a DDL trigger and parse the SQL statement.Or you could run this in a job:select name from sys.syslogins where sysadmin = 1 |
 |
|
|
|
|
|
SQL Server Agent to track grant of Sysadmin