The following script can be executed to programmatically enable SQL Server Auditing: EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer', N'AuditLevel', REG_DWORD, AuditLevel Where AuditLevel equals 0 = None
Read More...