http://www.sqlservercentral.com/blogs/brian_kelley/2008/11/14/mssqltips-com-how-to-audit-sysadmin-logins/

Printed 2014/07/26 07:11AM

MSSQLTips.com: How to Audit SysAdmin Logins

2008/11/14

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

 


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.