DBAs - Do you turn on security auditing?
Loading last updated info...
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.