DBAs - Do you turn on security auditing?

Configure login security auditing:

• Not on by default
• Configure on the security tab of Server Properties in SQL Server Management Studio
• Enable for Failure
• View using the Windows Event Viewer

Figure: Enable Auditing for SQL Server logins

Note: You can turn on a trace for SQL DDL operations statements.