MS SQL Admin

Browse by Tags

• DDL Triggers
• FOR LOGON
• Sarbanes-Oxley

• Auditing Logins in SQL Server 2005

  When I teach my SQL administration classes, I'm often ask if SQL Server provides a mechanism to log user logins. Before SQL Server 2005 SP2, this task was possible but not reliable. In SQL Server 2005 this task is easy to implement using DDL triggers... Posted Mar 29 2008, 02:14 AM by Eric Vaillancourt with | with 2 comment(s) Filed under: Security, FOR LOGON, DDL Triggers, Audit, Sarbanes-Oxley