Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

K. Brian Kelley - Databases, Infrastructure, and Security

IT Security, MySQL, Perl, SQL Server, and Windows technologies.

MSSQLTips.com: How to Audit SysAdmin Logins

One of the first things I tried to do when logon triggers came out with Service Pack 2 of SQL Server 2005 was audit for members of the sysadmin fixed server role logging on to the server. Here's a simple means to build a logon trigger to do just that: 

MSSQLTips.com: SysAdmin Login Auditing

 

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.