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
1 = Success
2 = Failure
3 = All
