--results for C2 Audit using sp_ScriptAnyTrace
--declare variables for parameterizing the command 
declare @traceidout       int           
declare @options          int           
declare @path             nvarchar(256) 
declare @maxfilesize      bigint        
declare @maxRolloverFiles int           
declare @stoptime         datetime      
declare @on               bit           
                                        
set @on = 1 --for scripting purposes, I think its better Always setting a script to start the trace after creation.
set @maxfilesize = 200 --size in MB 
set @maxRolloverFiles = 0  --number of files; ie if 5 files, start rewriting on rollover 
set @stoptime = NULL  -- null if never ends, else a specific date 
set @options = 2
set @path  = '\\?\C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\audittrace20100322111518'  -- the trace adds ".trc" to the pathname, so avoiad "name.trc.trc" by removing it for scripting 

  --create the trace 
--create the trace 
exec sp_trace_create 
    @traceid           = @traceidout output, 
    @options           = @options, 
    @tracefile         = @path, 
    @maxfilesize       = @maxfilesize, 
    @stoptime          = @stoptime, 
    @filecount         = @maxRolloverFiles 

  --for the Event Every SQL statement completed, capture columns of accessible data  
  exec sp_trace_setevent @traceidout,14,1,@on --Audit Login,TextData
  exec sp_trace_setevent @traceidout,14,2,@on --Audit Login,BinaryData
  exec sp_trace_setevent @traceidout,14,3,@on --Audit Login,DatabaseID
  exec sp_trace_setevent @traceidout,14,6,@on --Audit Login,NTUserName
  exec sp_trace_setevent @traceidout,14,7,@on --Audit Login,NTDomainName
  exec sp_trace_setevent @traceidout,14,8,@on --Audit Login,HostName
  exec sp_trace_setevent @traceidout,14,51,@on --Audit Login,EventSequence
  exec sp_trace_setevent @traceidout,14,57,@on --Audit Login,Type
  exec sp_trace_setevent @traceidout,14,60,@on --Audit Login,IsSystem
  exec sp_trace_setevent @traceidout,14,64,@on --Audit Login,SessionLoginName
  exec sp_trace_setevent @traceidout,14,66,@on --Audit Login,GroupID
  exec sp_trace_setevent @traceidout,14,23,@on --Audit Login,Success
  exec sp_trace_setevent @traceidout,14,25,@on --Audit Login,IntegerData
  exec sp_trace_setevent @traceidout,14,26,@on --Audit Login,ServerName
  exec sp_trace_setevent @traceidout,14,35,@on --Audit Login,DatabaseName
  exec sp_trace_setevent @traceidout,14,41,@on --Audit Login,LoginSid
  exec sp_trace_setevent @traceidout,14,49,@on --Audit Login,RequestID
  exec sp_trace_setevent @traceidout,14,9,@on --Audit Login,ClientProcessID
  exec sp_trace_setevent @traceidout,14,10,@on --Audit Login,ApplicationName
  exec sp_trace_setevent @traceidout,14,11,@on --Audit Login,LoginName
  exec sp_trace_setevent @traceidout,14,12,@on --Audit Login,SPID
  exec sp_trace_setevent @traceidout,14,14,@on --Audit Login,StartTime
  exec sp_trace_setevent @traceidout,14,21,@on --Audit Login,EventSubClass
  exec sp_trace_setevent @traceidout,15,3,@on --Audit Logout,DatabaseID
  exec sp_trace_setevent @traceidout,15,6,@on --Audit Logout,NTUserName
  exec sp_trace_setevent @traceidout,15,7,@on --Audit Logout,NTDomainName
  exec sp_trace_setevent @traceidout,15,8,@on --Audit Logout,HostName
  exec sp_trace_setevent @traceidout,15,9,@on --Audit Logout,ClientProcessID
  exec sp_trace_setevent @traceidout,15,10,@on --Audit Logout,ApplicationName
  exec sp_trace_setevent @traceidout,15,66,@on --Audit Logout,GroupID
  exec sp_trace_setevent @traceidout,15,41,@on --Audit Logout,LoginSid
  exec sp_trace_setevent @traceidout,15,49,@on --Audit Logout,RequestID
  exec sp_trace_setevent @traceidout,15,51,@on --Audit Logout,EventSequence
  exec sp_trace_setevent @traceidout,15,57,@on --Audit Logout,Type
  exec sp_trace_setevent @traceidout,15,60,@on --Audit Logout,IsSystem
  exec sp_trace_setevent @traceidout,15,64,@on --Audit Logout,SessionLoginName
  exec sp_trace_setevent @traceidout,15,17,@on --Audit Logout,Writes
  exec sp_trace_setevent @traceidout,15,18,@on --Audit Logout,CPU
  exec sp_trace_setevent @traceidout,15,21,@on --Audit Logout,EventSubClass
  exec sp_trace_setevent @traceidout,15,23,@on --Audit Logout,Success
  exec sp_trace_setevent @traceidout,15,26,@on --Audit Logout,ServerName
  exec sp_trace_setevent @traceidout,15,35,@on --Audit Logout,DatabaseName
  exec sp_trace_setevent @traceidout,15,11,@on --Audit Logout,LoginName
  exec sp_trace_setevent @traceidout,15,12,@on --Audit Logout,SPID
  exec sp_trace_setevent @traceidout,15,13,@on --Audit Logout,Duration
  exec sp_trace_setevent @traceidout,15,14,@on --Audit Logout,StartTime
  exec sp_trace_setevent @traceidout,15,15,@on --Audit Logout,EndTime
  exec sp_trace_setevent @traceidout,15,16,@on --Audit Logout,Reads
  exec sp_trace_setevent @traceidout,18,6,@on --Audit Server Starts And Stops,NTUserName
  exec sp_trace_setevent @traceidout,18,7,@on --Audit Server Starts And Stops,NTDomainName
  exec sp_trace_setevent @traceidout,18,8,@on --Audit Server Starts And Stops,HostName
  exec sp_trace_setevent @traceidout,18,9,@on --Audit Server Starts And Stops,ClientProcessID
  exec sp_trace_setevent @traceidout,18,10,@on --Audit Server Starts And Stops,ApplicationName
  exec sp_trace_setevent @traceidout,18,11,@on --Audit Server Starts And Stops,LoginName
  exec sp_trace_setevent @traceidout,18,49,@on --Audit Server Starts And Stops,RequestID
  exec sp_trace_setevent @traceidout,18,51,@on --Audit Server Starts And Stops,EventSequence
  exec sp_trace_setevent @traceidout,18,60,@on --Audit Server Starts And Stops,IsSystem
  exec sp_trace_setevent @traceidout,18,64,@on --Audit Server Starts And Stops,SessionLoginName
  exec sp_trace_setevent @traceidout,18,12,@on --Audit Server Starts And Stops,SPID
  exec sp_trace_setevent @traceidout,18,14,@on --Audit Server Starts And Stops,StartTime
  exec sp_trace_setevent @traceidout,18,21,@on --Audit Server Starts And Stops,EventSubClass
  exec sp_trace_setevent @traceidout,18,23,@on --Audit Server Starts And Stops,Success
  exec sp_trace_setevent @traceidout,18,26,@on --Audit Server Starts And Stops,ServerName
  exec sp_trace_setevent @traceidout,18,41,@on --Audit Server Starts And Stops,LoginSid
  exec sp_trace_setevent @traceidout,20,1,@on --Audit Login Failed,TextData
  exec sp_trace_setevent @traceidout,20,3,@on --Audit Login Failed,DatabaseID
  exec sp_trace_setevent @traceidout,20,6,@on --Audit Login Failed,NTUserName
  exec sp_trace_setevent @traceidout,20,7,@on --Audit Login Failed,NTDomainName
  exec sp_trace_setevent @traceidout,20,8,@on --Audit Login Failed,HostName
  exec sp_trace_setevent @traceidout,20,9,@on --Audit Login Failed,ClientProcessID
  exec sp_trace_setevent @traceidout,20,57,@on --Audit Login Failed,Type
  exec sp_trace_setevent @traceidout,20,60,@on --Audit Login Failed,IsSystem
  exec sp_trace_setevent @traceidout,20,64,@on --Audit Login Failed,SessionLoginName
  exec sp_trace_setevent @traceidout,20,26,@on --Audit Login Failed,ServerName
  exec sp_trace_setevent @traceidout,20,30,@on --Audit Login Failed,State
  exec sp_trace_setevent @traceidout,20,31,@on --Audit Login Failed,Error
  exec sp_trace_setevent @traceidout,20,35,@on --Audit Login Failed,DatabaseName
  exec sp_trace_setevent @traceidout,20,49,@on --Audit Login Failed,RequestID
  exec sp_trace_setevent @traceidout,20,51,@on --Audit Login Failed,EventSequence
  exec sp_trace_setevent @traceidout,20,10,@on --Audit Login Failed,ApplicationName
  exec sp_trace_setevent @traceidout,20,11,@on --Audit Login Failed,LoginName
  exec sp_trace_setevent @traceidout,20,12,@on --Audit Login Failed,SPID
  exec sp_trace_setevent @traceidout,20,14,@on --Audit Login Failed,StartTime
  exec sp_trace_setevent @traceidout,20,21,@on --Audit Login Failed,EventSubClass
  exec sp_trace_setevent @traceidout,20,23,@on --Audit Login Failed,Success
  exec sp_trace_setevent @traceidout,102,1,@on --Audit Database Scope GDR Event,TextData
  exec sp_trace_setevent @traceidout,102,3,@on --Audit Database Scope GDR Event,DatabaseID
  exec sp_trace_setevent @traceidout,102,4,@on --Audit Database Scope GDR Event,TransactionID
  exec sp_trace_setevent @traceidout,102,5,@on --Audit Database Scope GDR Event,LineNumber
  exec sp_trace_setevent @traceidout,102,6,@on --Audit Database Scope GDR Event,NTUserName
  exec sp_trace_setevent @traceidout,102,7,@on --Audit Database Scope GDR Event,NTDomainName
  exec sp_trace_setevent @traceidout,102,64,@on --Audit Database Scope GDR Event,SessionLoginName
  exec sp_trace_setevent @traceidout,102,42,@on --Audit Database Scope GDR Event,TargetLoginName
  exec sp_trace_setevent @traceidout,102,43,@on --Audit Database Scope GDR Event,TargetLoginSid
  exec sp_trace_setevent @traceidout,102,49,@on --Audit Database Scope GDR Event,RequestID
  exec sp_trace_setevent @traceidout,102,50,@on --Audit Database Scope GDR Event,XactSequence
  exec sp_trace_setevent @traceidout,102,51,@on --Audit Database Scope GDR Event,EventSequence
  exec sp_trace_setevent @traceidout,102,60,@on --Audit Database Scope GDR Event,IsSystem
  exec sp_trace_setevent @traceidout,102,34,@on --Audit Database Scope GDR Event,ObjectName
  exec sp_trace_setevent @traceidout,102,35,@on --Audit Database Scope GDR Event,DatabaseName
  exec sp_trace_setevent @traceidout,102,37,@on --Audit Database Scope GDR Event,OwnerName
  exec sp_trace_setevent @traceidout,102,39,@on --Audit Database Scope GDR Event,TargetUserName
  exec sp_trace_setevent @traceidout,102,40,@on --Audit Database Scope GDR Event,DBUserName
  exec sp_trace_setevent @traceidout,102,41,@on --Audit Database Scope GDR Event,LoginSid
  exec sp_trace_setevent @traceidout,102,19,@on --Audit Database Scope GDR Event,Permissions
  exec sp_trace_setevent @traceidout,102,21,@on --Audit Database Scope GDR Event,EventSubClass
  exec sp_trace_setevent @traceidout,102,23,@on --Audit Database Scope GDR Event,Success
  exec sp_trace_setevent @traceidout,102,26,@on --Audit Database Scope GDR Event,ServerName
  exec sp_trace_setevent @traceidout,102,28,@on --Audit Database Scope GDR Event,ObjectType
  exec sp_trace_setevent @traceidout,102,29,@on --Audit Database Scope GDR Event,NestLevel
  exec sp_trace_setevent @traceidout,102,8,@on --Audit Database Scope GDR Event,HostName
  exec sp_trace_setevent @traceidout,102,9,@on --Audit Database Scope GDR Event,ClientProcessID
  exec sp_trace_setevent @traceidout,102,10,@on --Audit Database Scope GDR Event,ApplicationName
  exec sp_trace_setevent @traceidout,102,11,@on --Audit Database Scope GDR Event,LoginName
  exec sp_trace_setevent @traceidout,102,12,@on --Audit Database Scope GDR Event,SPID
  exec sp_trace_setevent @traceidout,102,14,@on --Audit Database Scope GDR Event,StartTime
  exec sp_trace_setevent @traceidout,103,1,@on --Audit Schema Object GDR Event,TextData
  exec sp_trace_setevent @traceidout,103,3,@on --Audit Schema Object GDR Event,DatabaseID
  exec sp_trace_setevent @traceidout,103,4,@on --Audit Schema Object GDR Event,TransactionID
  exec sp_trace_setevent @traceidout,103,5,@on --Audit Schema Object GDR Event,LineNumber
  exec sp_trace_setevent @traceidout,103,6,@on --Audit Schema Object GDR Event,NTUserName
  exec sp_trace_setevent @traceidout,103,7,@on --Audit Schema Object GDR Event,NTDomainName
  exec sp_trace_setevent @traceidout,103,59,@on --Audit Schema Object GDR Event,ParentName
  exec sp_trace_setevent @traceidout,103,60,@on --Audit Schema Object GDR Event,IsSystem
  exec sp_trace_setevent @traceidout,103,64,@on --Audit Schema Object GDR Event,SessionLoginName
  exec sp_trace_setevent @traceidout,103,42,@on --Audit Schema Object GDR Event,TargetLoginName
  exec sp_trace_setevent @traceidout,103,43,@on --Audit Schema Object GDR Event,TargetLoginSid
  exec sp_trace_setevent @traceidout,103,44,@on --Audit Schema Object GDR Event,ColumnPermissions
  exec sp_trace_setevent @traceidout,103,49,@on --Audit Schema Object GDR Event,RequestID
  exec sp_trace_setevent @traceidout,103,50,@on --Audit Schema Object GDR Event,XactSequence
  exec sp_trace_setevent @traceidout,103,51,@on --Audit Schema Object GDR Event,EventSequence
  exec sp_trace_setevent @traceidout,103,34,@on --Audit Schema Object GDR Event,ObjectName
  exec sp_trace_setevent @traceidout,103,35,@on --Audit Schema Object GDR Event,DatabaseName
  exec sp_trace_setevent @traceidout,103,37,@on --Audit Schema Object GDR Event,OwnerName
  exec sp_trace_setevent @traceidout,103,39,@on --Audit Schema Object GDR Event,TargetUserName
  exec sp_trace_setevent @traceidout,103,40,@on --Audit Schema Object GDR Event,DBUserName
  exec sp_trace_setevent @traceidout,103,41,@on --Audit Schema Object GDR Event,LoginSid
  exec sp_trace_setevent @traceidout,103,19,@on --Audit Schema Object GDR Event,Permissions
  exec sp_trace_setevent @traceidout,103,21,@on --Audit Schema Object GDR Event,EventSubClass
  exec sp_trace_setevent @traceidout,103,23,@on --Audit Schema Object GDR Event,Success
  exec sp_trace_setevent @traceidout,103,26,@on --Audit Schema Object GDR Event,ServerName
  exec sp_trace_setevent @traceidout,103,28,@on --Audit Schema Object GDR Event,ObjectType
  exec sp_trace_setevent @traceidout,103,29,@on --Audit Schema Object GDR Event,NestLevel
  exec sp_trace_setevent @traceidout,103,8,@on --Audit Schema Object GDR Event,HostName
  exec sp_trace_setevent @traceidout,103,9,@on --Audit Schema Object GDR Event,ClientProcessID
  exec sp_trace_setevent @traceidout,103,10,@on --Audit Schema Object GDR Event,ApplicationName
  exec sp_trace_setevent @traceidout,103,11,@on --Audit Schema Object GDR Event,LoginName
  exec sp_trace_setevent @traceidout,103,12,@on --Audit Schema Object GDR Event,SPID
  exec sp_trace_setevent @traceidout,103,14,@on --Audit Schema Object GDR Event,StartTime
  exec sp_trace_setevent @traceidout,104,3,@on --Audit Addlogin Event,DatabaseID
  exec sp_trace_setevent @traceidout,104,4,@on --Audit Addlogin Event,TransactionID
  exec sp_trace_setevent @traceidout,104,5,@on --Audit Addlogin Event,LineNumber
  exec sp_trace_setevent @traceidout,104,6,@on --Audit Addlogin Event,NTUserName
  exec sp_trace_setevent @traceidout,104,7,@on --Audit Addlogin Event,NTDomainName
  exec sp_trace_setevent @traceidout,104,8,@on --Audit Addlogin Event,HostName
  exec sp_trace_setevent @traceidout,104,64,@on --Audit Addlogin Event,SessionLoginName
  exec sp_trace_setevent @traceidout,104,42,@on --Audit Addlogin Event,TargetLoginName
  exec sp_trace_setevent @traceidout,104,43,@on --Audit Addlogin Event,TargetLoginSid
  exec sp_trace_setevent @traceidout,104,49,@on --Audit Addlogin Event,RequestID
  exec sp_trace_setevent @traceidout,104,50,@on --Audit Addlogin Event,XactSequence
  exec sp_trace_setevent @traceidout,104,51,@on --Audit Addlogin Event,EventSequence
  exec sp_trace_setevent @traceidout,104,60,@on --Audit Addlogin Event,IsSystem
  exec sp_trace_setevent @traceidout,104,23,@on --Audit Addlogin Event,Success
  exec sp_trace_setevent @traceidout,104,26,@on --Audit Addlogin Event,ServerName
  exec sp_trace_setevent @traceidout,104,28,@on --Audit Addlogin Event,ObjectType
  exec sp_trace_setevent @traceidout,104,35,@on --Audit Addlogin Event,DatabaseName
  exec sp_trace_setevent @traceidout,104,40,@on --Audit Addlogin Event,DBUserName
  exec sp_trace_setevent @traceidout,104,41,@on --Audit Addlogin Event,LoginSid
  exec sp_trace_setevent @traceidout,104,9,@on --Audit Addlogin Event,ClientProcessID
  exec sp_trace_setevent @traceidout,104,10,@on --Audit Addlogin Event,ApplicationName
  exec sp_trace_setevent @traceidout,104,11,@on --Audit Addlogin Event,LoginName
  exec sp_trace_setevent @traceidout,104,12,@on --Audit Addlogin Event,SPID
  exec sp_trace_setevent @traceidout,104,14,@on --Audit Addlogin Event,StartTime
  exec sp_trace_setevent @traceidout,104,21,@on --Audit Addlogin Event,EventSubClass
  exec sp_trace_setevent @traceidout,105,3,@on --Audit Login GDR Event,DatabaseID
  exec sp_trace_setevent @traceidout,105,4,@on --Audit Login GDR Event,TransactionID
  exec sp_trace_setevent @traceidout,105,6,@on --Audit Login GDR Event,NTUserName
  exec sp_trace_setevent @traceidout,105,7,@on --Audit Login GDR Event,NTDomainName
  exec sp_trace_setevent @traceidout,105,8,@on --Audit Login GDR Event,HostName
  exec sp_trace_setevent @traceidout,105,9,@on --Audit Login GDR Event,ClientProcessID
  exec sp_trace_setevent @traceidout,105,43,@on --Audit Login GDR Event,TargetLoginSid
  exec sp_trace_setevent @traceidout,105,49,@on --Audit Login GDR Event,RequestID
  exec sp_trace_setevent @traceidout,105,50,@on --Audit Login GDR Event,XactSequence
  exec sp_trace_setevent @traceidout,105,51,@on --Audit Login GDR Event,EventSequence
  exec sp_trace_setevent @traceidout,105,60,@on --Audit Login GDR Event,IsSystem
  exec sp_trace_setevent @traceidout,105,64,@on --Audit Login GDR Event,SessionLoginName
  exec sp_trace_setevent @traceidout,105,26,@on --Audit Login GDR Event,ServerName
  exec sp_trace_setevent @traceidout,105,28,@on --Audit Login GDR Event,ObjectType
  exec sp_trace_setevent @traceidout,105,35,@on --Audit Login GDR Event,DatabaseName
  exec sp_trace_setevent @traceidout,105,40,@on --Audit Login GDR Event,DBUserName
  exec sp_trace_setevent @traceidout,105,41,@on --Audit Login GDR Event,LoginSid
  exec sp_trace_setevent @traceidout,105,42,@on --Audit Login GDR Event,TargetLoginName
  exec sp_trace_setevent @traceidout,105,10,@on --Audit Login GDR Event,ApplicationName
  exec sp_trace_setevent @traceidout,105,11,@on --Audit Login GDR Event,LoginName
  exec sp_trace_setevent @traceidout,105,12,@on --Audit Login GDR Event,SPID
  exec sp_trace_setevent @traceidout,105,14,@on --Audit Login GDR Event,StartTime
  exec sp_trace_setevent @traceidout,105,21,@on --Audit Login GDR Event,EventSubClass
  exec sp_trace_setevent @traceidout,105,23,@on --Audit Login GDR Event,Success
  exec sp_trace_setevent @traceidout,106,1,@on --Audit Login Change Property Event,TextData
  exec sp_trace_setevent @traceidout,106,3,@on --Audit Login Change Property Event,DatabaseID
  exec sp_trace_setevent @traceidout,106,4,@on --Audit Login Change Property Event,TransactionID
  exec sp_trace_setevent @traceidout,106,5,@on --Audit Login Change Property Event,LineNumber
  exec sp_trace_setevent @traceidout,106,6,@on --Audit Login Change Property Event,NTUserName
  exec sp_trace_setevent @traceidout,106,7,@on --Audit Login Change Property Event,NTDomainName
  exec sp_trace_setevent @traceidout,106,49,@on --Audit Login Change Property Event,RequestID
  exec sp_trace_setevent @traceidout,106,50,@on --Audit Login Change Property Event,XactSequence
  exec sp_trace_setevent @traceidout,106,51,@on --Audit Login Change Property Event,EventSequence
  exec sp_trace_setevent @traceidout,106,60,@on --Audit Login Change Property Event,IsSystem
  exec sp_trace_setevent @traceidout,106,64,@on --Audit Login Change Property Event,SessionLoginName
  exec sp_trace_setevent @traceidout,106,35,@on --Audit Login Change Property Event,DatabaseName
  exec sp_trace_setevent @traceidout,106,37,@on --Audit Login Change Property Event,OwnerName
  exec sp_trace_setevent @traceidout,106,40,@on --Audit Login Change Property Event,DBUserName
  exec sp_trace_setevent @traceidout,106,41,@on --Audit Login Change Property Event,LoginSid
  exec sp_trace_setevent @traceidout,106,42,@on --Audit Login Change Property Event,TargetLoginName
  exec sp_trace_setevent @traceidout,106,43,@on --Audit Login Change Property Event,TargetLoginSid
  exec sp_trace_setevent @traceidout,106,21,@on --Audit Login Change Property Event,EventSubClass
  exec sp_trace_setevent @traceidout,106,23,@on --Audit Login Change Property Event,Success
  exec sp_trace_setevent @traceidout,106,26,@on --Audit Login Change Property Event,ServerName
  exec sp_trace_setevent @traceidout,106,28,@on --Audit Login Change Property Event,ObjectType
  exec sp_trace_setevent @traceidout,106,29,@on --Audit Login Change Property Event,NestLevel
  exec sp_trace_setevent @traceidout,106,34,@on --Audit Login Change Property Event,ObjectName
  exec sp_trace_setevent @traceidout,106,8,@on --Audit Login Change Property Event,HostName
  exec sp_trace_setevent @traceidout,106,9,@on --Audit Login Change Property Event,ClientProcessID
  exec sp_trace_setevent @traceidout,106,10,@on --Audit Login Change Property Event,ApplicationName
  exec sp_trace_setevent @traceidout,106,11,@on --Audit Login Change Property Event,LoginName
  exec sp_trace_setevent @traceidout,106,12,@on --Audit Login Change Property Event,SPID
  exec sp_trace_setevent @traceidout,106,14,@on --Audit Login Change Property Event,StartTime
  exec sp_trace_setevent @traceidout,107,1,@on --Audit Login Change Password Event,TextData
  exec sp_trace_setevent @traceidout,107,3,@on --Audit Login Change Password Event,DatabaseID
  exec sp_trace_setevent @traceidout,107,4,@on --Audit Login Change Password Event,TransactionID
  exec sp_trace_setevent @traceidout,107,6,@on --Audit Login Change Password Event,NTUserName
  exec sp_trace_setevent @traceidout,107,7,@on --Audit Login Change Password Event,NTDomainName
  exec sp_trace_setevent @traceidout,107,8,@on --Audit Login Change Password Event,HostName
  exec sp_trace_setevent @traceidout,107,50,@on --Audit Login Change Password Event,XactSequence
  exec sp_trace_setevent @traceidout,107,51,@on --Audit Login Change Password Event,EventSequence
  exec sp_trace_setevent @traceidout,107,60,@on --Audit Login Change Password Event,IsSystem
  exec sp_trace_setevent @traceidout,107,64,@on --Audit Login Change Password Event,SessionLoginName
  exec sp_trace_setevent @traceidout,107,37,@on --Audit Login Change Password Event,OwnerName
  exec sp_trace_setevent @traceidout,107,40,@on --Audit Login Change Password Event,DBUserName
  exec sp_trace_setevent @traceidout,107,41,@on --Audit Login Change Password Event,LoginSid
  exec sp_trace_setevent @traceidout,107,42,@on --Audit Login Change Password Event,TargetLoginName
  exec sp_trace_setevent @traceidout,107,43,@on --Audit Login Change Password Event,TargetLoginSid
  exec sp_trace_setevent @traceidout,107,49,@on --Audit Login Change Password Event,RequestID
  exec sp_trace_setevent @traceidout,107,23,@on --Audit Login Change Password Event,Success
  exec sp_trace_setevent @traceidout,107,26,@on --Audit Login Change Password Event,ServerName
  exec sp_trace_setevent @traceidout,107,28,@on --Audit Login Change Password Event,ObjectType
  exec sp_trace_setevent @traceidout,107,29,@on --Audit Login Change Password Event,NestLevel
  exec sp_trace_setevent @traceidout,107,34,@on --Audit Login Change Password Event,ObjectName
  exec sp_trace_setevent @traceidout,107,35,@on --Audit Login Change Password Event,DatabaseName
  exec sp_trace_setevent @traceidout,107,9,@on --Audit Login Change Password Event,ClientProcessID
  exec sp_trace_setevent @traceidout,107,10,@on --Audit Login Change Password Event,ApplicationName
  exec sp_trace_setevent @traceidout,107,11,@on --Audit Login Change Password Event,LoginName
  exec sp_trace_setevent @traceidout,107,12,@on --Audit Login Change Password Event,SPID
  exec sp_trace_setevent @traceidout,107,14,@on --Audit Login Change Password Event,StartTime
  exec sp_trace_setevent @traceidout,107,21,@on --Audit Login Change Password Event,EventSubClass
  exec sp_trace_setevent @traceidout,108,1,@on --Audit Add Login to Server Role Event,TextData
  exec sp_trace_setevent @traceidout,108,3,@on --Audit Add Login to Server Role Event,DatabaseID
  exec sp_trace_setevent @traceidout,108,4,@on --Audit Add Login to Server Role Event,TransactionID
  exec sp_trace_setevent @traceidout,108,6,@on --Audit Add Login to Server Role Event,NTUserName
  exec sp_trace_setevent @traceidout,108,7,@on --Audit Add Login to Server Role Event,NTDomainName
  exec sp_trace_setevent @traceidout,108,8,@on --Audit Add Login to Server Role Event,HostName
  exec sp_trace_setevent @traceidout,108,49,@on --Audit Add Login to Server Role Event,RequestID
  exec sp_trace_setevent @traceidout,108,50,@on --Audit Add Login to Server Role Event,XactSequence
  exec sp_trace_setevent @traceidout,108,51,@on --Audit Add Login to Server Role Event,EventSequence
  exec sp_trace_setevent @traceidout,108,60,@on --Audit Add Login to Server Role Event,IsSystem
  exec sp_trace_setevent @traceidout,108,64,@on --Audit Add Login to Server Role Event,SessionLoginName
  exec sp_trace_setevent @traceidout,108,37,@on --Audit Add Login to Server Role Event,OwnerName
  exec sp_trace_setevent @traceidout,108,38,@on --Audit Add Login to Server Role Event,RoleName
  exec sp_trace_setevent @traceidout,108,40,@on --Audit Add Login to Server Role Event,DBUserName
  exec sp_trace_setevent @traceidout,108,41,@on --Audit Add Login to Server Role Event,LoginSid
  exec sp_trace_setevent @traceidout,108,42,@on --Audit Add Login to Server Role Event,TargetLoginName
  exec sp_trace_setevent @traceidout,108,43,@on --Audit Add Login to Server Role Event,TargetLoginSid
  exec sp_trace_setevent @traceidout,108,23,@on --Audit Add Login to Server Role Event,Success
  exec sp_trace_setevent @traceidout,108,26,@on --Audit Add Login to Server Role Event,ServerName
  exec sp_trace_setevent @traceidout,108,28,@on --Audit Add Login to Server Role Event,ObjectType
  exec sp_trace_setevent @traceidout,108,29,@on --Audit Add Login to Server Role Event,NestLevel
  exec sp_trace_setevent @traceidout,108,34,@on --Audit Add Login to Server Role Event,ObjectName
  exec sp_trace_setevent @traceidout,108,35,@on --Audit Add Login to Server Role Event,DatabaseName
  exec sp_trace_setevent @traceidout,108,9,@on --Audit Add Login to Server Role Event,ClientProcessID
  exec sp_trace_setevent @traceidout,108,10,@on --Audit Add Login to Server Role Event,ApplicationName
  exec sp_trace_setevent @traceidout,108,11,@on --Audit Add Login to Server Role Event,LoginName
  exec sp_trace_setevent @traceidout,108,12,@on --Audit Add Login to Server Role Event,SPID
  exec sp_trace_setevent @traceidout,108,14,@on --Audit Add Login to Server Role Event,StartTime
  exec sp_trace_setevent @traceidout,108,21,@on --Audit Add Login to Server Role Event,EventSubClass
  exec sp_trace_setevent @traceidout,109,3,@on --Audit Add DB User Event,DatabaseID
  exec sp_trace_setevent @traceidout,109,4,@on --Audit Add DB User Event,TransactionID
  exec sp_trace_setevent @traceidout,109,6,@on --Audit Add DB User Event,NTUserName
  exec sp_trace_setevent @traceidout,109,7,@on --Audit Add DB User Event,NTDomainName
  exec sp_trace_setevent @traceidout,109,8,@on --Audit Add DB User Event,HostName
  exec sp_trace_setevent @traceidout,109,9,@on --Audit Add DB User Event,ClientProcessID
  exec sp_trace_setevent @traceidout,109,49,@on --Audit Add DB User Event,RequestID
  exec sp_trace_setevent @traceidout,109,50,@on --Audit Add DB User Event,XactSequence
  exec sp_trace_setevent @traceidout,109,51,@on --Audit Add DB User Event,EventSequence
  exec sp_trace_setevent @traceidout,109,60,@on --Audit Add DB User Event,IsSystem
  exec sp_trace_setevent @traceidout,109,64,@on --Audit Add DB User Event,SessionLoginName
  exec sp_trace_setevent @traceidout,109,39,@on --Audit Add DB User Event,TargetUserName
  exec sp_trace_setevent @traceidout,109,40,@on --Audit Add DB User Event,DBUserName
  exec sp_trace_setevent @traceidout,109,41,@on --Audit Add DB User Event,LoginSid
  exec sp_trace_setevent @traceidout,109,42,@on --Audit Add DB User Event,TargetLoginName
  exec sp_trace_setevent @traceidout,109,43,@on --Audit Add DB User Event,TargetLoginSid
  exec sp_trace_setevent @traceidout,109,44,@on --Audit Add DB User Event,ColumnPermissions
  exec sp_trace_setevent @traceidout,109,26,@on --Audit Add DB User Event,ServerName
  exec sp_trace_setevent @traceidout,109,28,@on --Audit Add DB User Event,ObjectType
  exec sp_trace_setevent @traceidout,109,29,@on --Audit Add DB User Event,NestLevel
  exec sp_trace_setevent @traceidout,109,35,@on --Audit Add DB User Event,DatabaseName
  exec sp_trace_setevent @traceidout,109,37,@on --Audit Add DB User Event,OwnerName
  exec sp_trace_setevent @traceidout,109,38,@on --Audit Add DB User Event,RoleName
  exec sp_trace_setevent @traceidout,109,10,@on --Audit Add DB User Event,ApplicationName
  exec sp_trace_setevent @traceidout,109,11,@on --Audit Add DB User Event,LoginName
  exec sp_trace_setevent @traceidout,109,12,@on --Audit Add DB User Event,SPID
  exec sp_trace_setevent @traceidout,109,14,@on --Audit Add DB User Event,StartTime
  exec sp_trace_setevent @traceidout,109,21,@on --Audit Add DB User Event,EventSubClass
  exec sp_trace_setevent @traceidout,109,23,@on --Audit Add DB User Event,Success
  exec sp_trace_setevent @traceidout,110,1,@on --Audit Add Member to DB Role Event,TextData
  exec sp_trace_setevent @traceidout,110,3,@on --Audit Add Member to DB Role Event,DatabaseID
  exec sp_trace_setevent @traceidout,110,4,@on --Audit Add Member to DB Role Event,TransactionID
  exec sp_trace_setevent @traceidout,110,6,@on --Audit Add Member to DB Role Event,NTUserName
  exec sp_trace_setevent @traceidout,110,7,@on --Audit Add Member to DB Role Event,NTDomainName
  exec sp_trace_setevent @traceidout,110,8,@on --Audit Add Member to DB Role Event,HostName
  exec sp_trace_setevent @traceidout,110,43,@on --Audit Add Member to DB Role Event,TargetLoginSid
  exec sp_trace_setevent @traceidout,110,49,@on --Audit Add Member to DB Role Event,RequestID
  exec sp_trace_setevent @traceidout,110,50,@on --Audit Add Member to DB Role Event,XactSequence
  exec sp_trace_setevent @traceidout,110,51,@on --Audit Add Member to DB Role Event,EventSequence
  exec sp_trace_setevent @traceidout,110,60,@on --Audit Add Member to DB Role Event,IsSystem
  exec sp_trace_setevent @traceidout,110,64,@on --Audit Add Member to DB Role Event,SessionLoginName
  exec sp_trace_setevent @traceidout,110,37,@on --Audit Add Member to DB Role Event,OwnerName
  exec sp_trace_setevent @traceidout,110,38,@on --Audit Add Member to DB Role Event,RoleName
  exec sp_trace_setevent @traceidout,110,39,@on --Audit Add Member to DB Role Event,TargetUserName
  exec sp_trace_setevent @traceidout,110,40,@on --Audit Add Member to DB Role Event,DBUserName
  exec sp_trace_setevent @traceidout,110,41,@on --Audit Add Member to DB Role Event,LoginSid
  exec sp_trace_setevent @traceidout,110,42,@on --Audit Add Member to DB Role Event,TargetLoginName
  exec sp_trace_setevent @traceidout,110,23,@on --Audit Add Member to DB Role Event,Success
  exec sp_trace_setevent @traceidout,110,26,@on --Audit Add Member to DB Role Event,ServerName
  exec sp_trace_setevent @traceidout,110,28,@on --Audit Add Member to DB Role Event,ObjectType
  exec sp_trace_setevent @traceidout,110,29,@on --Audit Add Member to DB Role Event,NestLevel
  exec sp_trace_setevent @traceidout,110,34,@on --Audit Add Member to DB Role Event,ObjectName
  exec sp_trace_setevent @traceidout,110,35,@on --Audit Add Member to DB Role Event,DatabaseName
  exec sp_trace_setevent @traceidout,110,9,@on --Audit Add Member to DB Role Event,ClientProcessID
  exec sp_trace_setevent @traceidout,110,10,@on --Audit Add Member to DB Role Event,ApplicationName
  exec sp_trace_setevent @traceidout,110,11,@on --Audit Add Member to DB Role Event,LoginName
  exec sp_trace_setevent @traceidout,110,12,@on --Audit Add Member to DB Role Event,SPID
  exec sp_trace_setevent @traceidout,110,14,@on --Audit Add Member to DB Role Event,StartTime
  exec sp_trace_setevent @traceidout,110,21,@on --Audit Add Member to DB Role Event,EventSubClass
  exec sp_trace_setevent @traceidout,111,3,@on --Audit Add Role Event,DatabaseID
  exec sp_trace_setevent @traceidout,111,4,@on --Audit Add Role Event,TransactionID
  exec sp_trace_setevent @traceidout,111,6,@on --Audit Add Role Event,NTUserName
  exec sp_trace_setevent @traceidout,111,7,@on --Audit Add Role Event,NTDomainName
  exec sp_trace_setevent @traceidout,111,8,@on --Audit Add Role Event,HostName
  exec sp_trace_setevent @traceidout,111,9,@on --Audit Add Role Event,ClientProcessID
  exec sp_trace_setevent @traceidout,111,41,@on --Audit Add Role Event,LoginSid
  exec sp_trace_setevent @traceidout,111,49,@on --Audit Add Role Event,RequestID
  exec sp_trace_setevent @traceidout,111,50,@on --Audit Add Role Event,XactSequence
  exec sp_trace_setevent @traceidout,111,51,@on --Audit Add Role Event,EventSequence
  exec sp_trace_setevent @traceidout,111,60,@on --Audit Add Role Event,IsSystem
  exec sp_trace_setevent @traceidout,111,64,@on --Audit Add Role Event,SessionLoginName
  exec sp_trace_setevent @traceidout,111,26,@on --Audit Add Role Event,ServerName
  exec sp_trace_setevent @traceidout,111,28,@on --Audit Add Role Event,ObjectType
  exec sp_trace_setevent @traceidout,111,29,@on --Audit Add Role Event,NestLevel
  exec sp_trace_setevent @traceidout,111,35,@on --Audit Add Role Event,DatabaseName
  exec sp_trace_setevent @traceidout,111,38,@on --Audit Add Role Event,RoleName
  exec sp_trace_setevent @traceidout,111,40,@on --Audit Add Role Event,DBUserName
  exec sp_trace_setevent @traceidout,111,10,@on --Audit Add Role Event,ApplicationName
  exec sp_trace_setevent @traceidout,111,11,@on --Audit Add Role Event,LoginName
  exec sp_trace_setevent @traceidout,111,12,@on --Audit Add Role Event,SPID
  exec sp_trace_setevent @traceidout,111,14,@on --Audit Add Role Event,StartTime
  exec sp_trace_setevent @traceidout,111,21,@on --Audit Add Role Event,EventSubClass
  exec sp_trace_setevent @traceidout,111,23,@on --Audit Add Role Event,Success
  exec sp_trace_setevent @traceidout,112,1,@on --Audit App Role Change Password Event,TextData
  exec sp_trace_setevent @traceidout,112,3,@on --Audit App Role Change Password Event,DatabaseID
  exec sp_trace_setevent @traceidout,112,4,@on --Audit App Role Change Password Event,TransactionID
  exec sp_trace_setevent @traceidout,112,6,@on --Audit App Role Change Password Event,NTUserName
  exec sp_trace_setevent @traceidout,112,7,@on --Audit App Role Change Password Event,NTDomainName
  exec sp_trace_setevent @traceidout,112,8,@on --Audit App Role Change Password Event,HostName
  exec sp_trace_setevent @traceidout,112,60,@on --Audit App Role Change Password Event,IsSystem
  exec sp_trace_setevent @traceidout,112,64,@on --Audit App Role Change Password Event,SessionLoginName
  exec sp_trace_setevent @traceidout,112,38,@on --Audit App Role Change Password Event,RoleName
  exec sp_trace_setevent @traceidout,112,40,@on --Audit App Role Change Password Event,DBUserName
  exec sp_trace_setevent @traceidout,112,41,@on --Audit App Role Change Password Event,LoginSid
  exec sp_trace_setevent @traceidout,112,49,@on --Audit App Role Change Password Event,RequestID
  exec sp_trace_setevent @traceidout,112,50,@on --Audit App Role Change Password Event,XactSequence
  exec sp_trace_setevent @traceidout,112,51,@on --Audit App Role Change Password Event,EventSequence
  exec sp_trace_setevent @traceidout,112,26,@on --Audit App Role Change Password Event,ServerName
  exec sp_trace_setevent @traceidout,112,28,@on --Audit App Role Change Password Event,ObjectType
  exec sp_trace_setevent @traceidout,112,29,@on --Audit App Role Change Password Event,NestLevel
  exec sp_trace_setevent @traceidout,112,34,@on --Audit App Role Change Password Event,ObjectName
  exec sp_trace_setevent @traceidout,112,35,@on --Audit App Role Change Password Event,DatabaseName
  exec sp_trace_setevent @traceidout,112,37,@on --Audit App Role Change Password Event,OwnerName
  exec sp_trace_setevent @traceidout,112,9,@on --Audit App Role Change Password Event,ClientProcessID
  exec sp_trace_setevent @traceidout,112,10,@on --Audit App Role Change Password Event,ApplicationName
  exec sp_trace_setevent @traceidout,112,11,@on --Audit App Role Change Password Event,LoginName
  exec sp_trace_setevent @traceidout,112,12,@on --Audit App Role Change Password Event,SPID
  exec sp_trace_setevent @traceidout,112,14,@on --Audit App Role Change Password Event,StartTime
  exec sp_trace_setevent @traceidout,112,23,@on --Audit App Role Change Password Event,Success
  exec sp_trace_setevent @traceidout,113,1,@on --Audit Statement Permission Event,TextData
  exec sp_trace_setevent @traceidout,113,3,@on --Audit Statement Permission Event,DatabaseID
  exec sp_trace_setevent @traceidout,113,4,@on --Audit Statement Permission Event,TransactionID
  exec sp_trace_setevent @traceidout,113,5,@on --Audit Statement Permission Event,LineNumber
  exec sp_trace_setevent @traceidout,113,6,@on --Audit Statement Permission Event,NTUserName
  exec sp_trace_setevent @traceidout,113,7,@on --Audit Statement Permission Event,NTDomainName
  exec sp_trace_setevent @traceidout,113,60,@on --Audit Statement Permission Event,IsSystem
  exec sp_trace_setevent @traceidout,113,64,@on --Audit Statement Permission Event,SessionLoginName
  exec sp_trace_setevent @traceidout,113,35,@on --Audit Statement Permission Event,DatabaseName
  exec sp_trace_setevent @traceidout,113,40,@on --Audit Statement Permission Event,DBUserName
  exec sp_trace_setevent @traceidout,113,41,@on --Audit Statement Permission Event,LoginSid
  exec sp_trace_setevent @traceidout,113,49,@on --Audit Statement Permission Event,RequestID
  exec sp_trace_setevent @traceidout,113,50,@on --Audit Statement Permission Event,XactSequence
  exec sp_trace_setevent @traceidout,113,51,@on --Audit Statement Permission Event,EventSequence
  exec sp_trace_setevent @traceidout,113,19,@on --Audit Statement Permission Event,Permissions
  exec sp_trace_setevent @traceidout,113,21,@on --Audit Statement Permission Event,EventSubClass
  exec sp_trace_setevent @traceidout,113,23,@on --Audit Statement Permission Event,Success
  exec sp_trace_setevent @traceidout,113,26,@on --Audit Statement Permission Event,ServerName
  exec sp_trace_setevent @traceidout,113,28,@on --Audit Statement Permission Event,ObjectType
  exec sp_trace_setevent @traceidout,113,29,@on --Audit Statement Permission Event,NestLevel
  exec sp_trace_setevent @traceidout,113,8,@on --Audit Statement Permission Event,HostName
  exec sp_trace_setevent @traceidout,113,9,@on --Audit Statement Permission Event,ClientProcessID
  exec sp_trace_setevent @traceidout,113,10,@on --Audit Statement Permission Event,ApplicationName
  exec sp_trace_setevent @traceidout,113,11,@on --Audit Statement Permission Event,LoginName
  exec sp_trace_setevent @traceidout,113,12,@on --Audit Statement Permission Event,SPID
  exec sp_trace_setevent @traceidout,113,14,@on --Audit Statement Permission Event,StartTime
  exec sp_trace_setevent @traceidout,114,1,@on --Audit Schema Object Access Event,TextData
  exec sp_trace_setevent @traceidout,114,2,@on --Audit Schema Object Access Event,BinaryData
  exec sp_trace_setevent @traceidout,114,3,@on --Audit Schema Object Access Event,DatabaseID
  exec sp_trace_setevent @traceidout,114,4,@on --Audit Schema Object Access Event,TransactionID
  exec sp_trace_setevent @traceidout,114,5,@on --Audit Schema Object Access Event,LineNumber
  exec sp_trace_setevent @traceidout,114,6,@on --Audit Schema Object Access Event,NTUserName
  exec sp_trace_setevent @traceidout,114,64,@on --Audit Schema Object Access Event,SessionLoginName
  exec sp_trace_setevent @traceidout,114,44,@on --Audit Schema Object Access Event,ColumnPermissions
  exec sp_trace_setevent @traceidout,114,49,@on --Audit Schema Object Access Event,RequestID
  exec sp_trace_setevent @traceidout,114,50,@on --Audit Schema Object Access Event,XactSequence
  exec sp_trace_setevent @traceidout,114,51,@on --Audit Schema Object Access Event,EventSequence
  exec sp_trace_setevent @traceidout,114,59,@on --Audit Schema Object Access Event,ParentName
  exec sp_trace_setevent @traceidout,114,60,@on --Audit Schema Object Access Event,IsSystem
  exec sp_trace_setevent @traceidout,114,29,@on --Audit Schema Object Access Event,NestLevel
  exec sp_trace_setevent @traceidout,114,34,@on --Audit Schema Object Access Event,ObjectName
  exec sp_trace_setevent @traceidout,114,35,@on --Audit Schema Object Access Event,DatabaseName
  exec sp_trace_setevent @traceidout,114,37,@on --Audit Schema Object Access Event,OwnerName
  exec sp_trace_setevent @traceidout,114,40,@on --Audit Schema Object Access Event,DBUserName
  exec sp_trace_setevent @traceidout,114,41,@on --Audit Schema Object Access Event,LoginSid
  exec sp_trace_setevent @traceidout,114,14,@on --Audit Schema Object Access Event,StartTime
  exec sp_trace_setevent @traceidout,114,19,@on --Audit Schema Object Access Event,Permissions
  exec sp_trace_setevent @traceidout,114,21,@on --Audit Schema Object Access Event,EventSubClass
  exec sp_trace_setevent @traceidout,114,23,@on --Audit Schema Object Access Event,Success
  exec sp_trace_setevent @traceidout,114,26,@on --Audit Schema Object Access Event,ServerName
  exec sp_trace_setevent @traceidout,114,28,@on --Audit Schema Object Access Event,ObjectType
  exec sp_trace_setevent @traceidout,114,7,@on --Audit Schema Object Access Event,NTDomainName
  exec sp_trace_setevent @traceidout,114,8,@on --Audit Schema Object Access Event,HostName
  exec sp_trace_setevent @traceidout,114,9,@on --Audit Schema Object Access Event,ClientProcessID
  exec sp_trace_setevent @traceidout,114,10,@on --Audit Schema Object Access Event,ApplicationName
  exec sp_trace_setevent @traceidout,114,11,@on --Audit Schema Object Access Event,LoginName
  exec sp_trace_setevent @traceidout,114,12,@on --Audit Schema Object Access Event,SPID
  exec sp_trace_setevent @traceidout,115,1,@on --Audit Backup/Restore Event,TextData
  exec sp_trace_setevent @traceidout,115,3,@on --Audit Backup/Restore Event,DatabaseID
  exec sp_trace_setevent @traceidout,115,4,@on --Audit Backup/Restore Event,TransactionID
  exec sp_trace_setevent @traceidout,115,5,@on --Audit Backup/Restore Event,LineNumber
  exec sp_trace_setevent @traceidout,115,6,@on --Audit Backup/Restore Event,NTUserName
  exec sp_trace_setevent @traceidout,115,7,@on --Audit Backup/Restore Event,NTDomainName
  exec sp_trace_setevent @traceidout,115,51,@on --Audit Backup/Restore Event,EventSequence
  exec sp_trace_setevent @traceidout,115,60,@on --Audit Backup/Restore Event,IsSystem
  exec sp_trace_setevent @traceidout,115,64,@on --Audit Backup/Restore Event,SessionLoginName
  exec sp_trace_setevent @traceidout,115,35,@on --Audit Backup/Restore Event,DatabaseName
  exec sp_trace_setevent @traceidout,115,37,@on --Audit Backup/Restore Event,OwnerName
  exec sp_trace_setevent @traceidout,115,40,@on --Audit Backup/Restore Event,DBUserName
  exec sp_trace_setevent @traceidout,115,41,@on --Audit Backup/Restore Event,LoginSid
  exec sp_trace_setevent @traceidout,115,49,@on --Audit Backup/Restore Event,RequestID
  exec sp_trace_setevent @traceidout,115,50,@on --Audit Backup/Restore Event,XactSequence
  exec sp_trace_setevent @traceidout,115,21,@on --Audit Backup/Restore Event,EventSubClass
  exec sp_trace_setevent @traceidout,115,23,@on --Audit Backup/Restore Event,Success
  exec sp_trace_setevent @traceidout,115,26,@on --Audit Backup/Restore Event,ServerName
  exec sp_trace_setevent @traceidout,115,28,@on --Audit Backup/Restore Event,ObjectType
  exec sp_trace_setevent @traceidout,115,29,@on --Audit Backup/Restore Event,NestLevel
  exec sp_trace_setevent @traceidout,115,34,@on --Audit Backup/Restore Event,ObjectName
  exec sp_trace_setevent @traceidout,115,8,@on --Audit Backup/Restore Event,HostName
  exec sp_trace_setevent @traceidout,115,9,@on --Audit Backup/Restore Event,ClientProcessID
  exec sp_trace_setevent @traceidout,115,10,@on --Audit Backup/Restore Event,ApplicationName
  exec sp_trace_setevent @traceidout,115,11,@on --Audit Backup/Restore Event,LoginName
  exec sp_trace_setevent @traceidout,115,12,@on --Audit Backup/Restore Event,SPID
  exec sp_trace_setevent @traceidout,115,14,@on --Audit Backup/Restore Event,StartTime
  exec sp_trace_setevent @traceidout,116,1,@on --Audit DBCC Event,TextData
  exec sp_trace_setevent @traceidout,116,3,@on --Audit DBCC Event,DatabaseID
  exec sp_trace_setevent @traceidout,116,4,@on --Audit DBCC Event,TransactionID
  exec sp_trace_setevent @traceidout,116,5,@on --Audit DBCC Event,LineNumber
  exec sp_trace_setevent @traceidout,116,6,@on --Audit DBCC Event,NTUserName
  exec sp_trace_setevent @traceidout,116,7,@on --Audit DBCC Event,NTDomainName
  exec sp_trace_setevent @traceidout,116,64,@on --Audit DBCC Event,SessionLoginName
  exec sp_trace_setevent @traceidout,116,41,@on --Audit DBCC Event,LoginSid
  exec sp_trace_setevent @traceidout,116,44,@on --Audit DBCC Event,ColumnPermissions
  exec sp_trace_setevent @traceidout,116,49,@on --Audit DBCC Event,RequestID
  exec sp_trace_setevent @traceidout,116,50,@on --Audit DBCC Event,XactSequence
  exec sp_trace_setevent @traceidout,116,51,@on --Audit DBCC Event,EventSequence
  exec sp_trace_setevent @traceidout,116,60,@on --Audit DBCC Event,IsSystem
  exec sp_trace_setevent @traceidout,116,23,@on --Audit DBCC Event,Success
  exec sp_trace_setevent @traceidout,116,26,@on --Audit DBCC Event,ServerName
  exec sp_trace_setevent @traceidout,116,29,@on --Audit DBCC Event,NestLevel
  exec sp_trace_setevent @traceidout,116,35,@on --Audit DBCC Event,DatabaseName
  exec sp_trace_setevent @traceidout,116,37,@on --Audit DBCC Event,OwnerName
  exec sp_trace_setevent @traceidout,116,40,@on --Audit DBCC Event,DBUserName
  exec sp_trace_setevent @traceidout,116,8,@on --Audit DBCC Event,HostName
  exec sp_trace_setevent @traceidout,116,9,@on --Audit DBCC Event,ClientProcessID
  exec sp_trace_setevent @traceidout,116,10,@on --Audit DBCC Event,ApplicationName
  exec sp_trace_setevent @traceidout,116,11,@on --Audit DBCC Event,LoginName
  exec sp_trace_setevent @traceidout,116,12,@on --Audit DBCC Event,SPID
  exec sp_trace_setevent @traceidout,116,14,@on --Audit DBCC Event,StartTime
  exec sp_trace_setevent @traceidout,117,1,@on --Audit Change Audit Event,TextData
  exec sp_trace_setevent @traceidout,117,3,@on --Audit Change Audit Event,DatabaseID
  exec sp_trace_setevent @traceidout,117,5,@on --Audit Change Audit Event,LineNumber
  exec sp_trace_setevent @traceidout,117,6,@on --Audit Change Audit Event,NTUserName
  exec sp_trace_setevent @traceidout,117,7,@on --Audit Change Audit Event,NTDomainName
  exec sp_trace_setevent @traceidout,117,8,@on --Audit Change Audit Event,HostName
  exec sp_trace_setevent @traceidout,117,64,@on --Audit Change Audit Event,SessionLoginName
  exec sp_trace_setevent @traceidout,117,41,@on --Audit Change Audit Event,LoginSid
  exec sp_trace_setevent @traceidout,117,44,@on --Audit Change Audit Event,ColumnPermissions
  exec sp_trace_setevent @traceidout,117,49,@on --Audit Change Audit Event,RequestID
  exec sp_trace_setevent @traceidout,117,50,@on --Audit Change Audit Event,XactSequence
  exec sp_trace_setevent @traceidout,117,51,@on --Audit Change Audit Event,EventSequence
  exec sp_trace_setevent @traceidout,117,60,@on --Audit Change Audit Event,IsSystem
  exec sp_trace_setevent @traceidout,117,23,@on --Audit Change Audit Event,Success
  exec sp_trace_setevent @traceidout,117,26,@on --Audit Change Audit Event,ServerName
  exec sp_trace_setevent @traceidout,117,29,@on --Audit Change Audit Event,NestLevel
  exec sp_trace_setevent @traceidout,117,35,@on --Audit Change Audit Event,DatabaseName
  exec sp_trace_setevent @traceidout,117,37,@on --Audit Change Audit Event,OwnerName
  exec sp_trace_setevent @traceidout,117,40,@on --Audit Change Audit Event,DBUserName
  exec sp_trace_setevent @traceidout,117,9,@on --Audit Change Audit Event,ClientProcessID
  exec sp_trace_setevent @traceidout,117,10,@on --Audit Change Audit Event,ApplicationName
  exec sp_trace_setevent @traceidout,117,11,@on --Audit Change Audit Event,LoginName
  exec sp_trace_setevent @traceidout,117,12,@on --Audit Change Audit Event,SPID
  exec sp_trace_setevent @traceidout,117,14,@on --Audit Change Audit Event,StartTime
  exec sp_trace_setevent @traceidout,117,21,@on --Audit Change Audit Event,EventSubClass
  exec sp_trace_setevent @traceidout,118,1,@on --Audit Object Derived Permission Event,TextData
  exec sp_trace_setevent @traceidout,118,3,@on --Audit Object Derived Permission Event,DatabaseID
  exec sp_trace_setevent @traceidout,118,4,@on --Audit Object Derived Permission Event,TransactionID
  exec sp_trace_setevent @traceidout,118,5,@on --Audit Object Derived Permission Event,LineNumber
  exec sp_trace_setevent @traceidout,118,6,@on --Audit Object Derived Permission Event,NTUserName
  exec sp_trace_setevent @traceidout,118,7,@on --Audit Object Derived Permission Event,NTDomainName
  exec sp_trace_setevent @traceidout,118,51,@on --Audit Object Derived Permission Event,EventSequence
  exec sp_trace_setevent @traceidout,118,60,@on --Audit Object Derived Permission Event,IsSystem
  exec sp_trace_setevent @traceidout,118,64,@on --Audit Object Derived Permission Event,SessionLoginName
  exec sp_trace_setevent @traceidout,118,35,@on --Audit Object Derived Permission Event,DatabaseName
  exec sp_trace_setevent @traceidout,118,37,@on --Audit Object Derived Permission Event,OwnerName
  exec sp_trace_setevent @traceidout,118,40,@on --Audit Object Derived Permission Event,DBUserName
  exec sp_trace_setevent @traceidout,118,41,@on --Audit Object Derived Permission Event,LoginSid
  exec sp_trace_setevent @traceidout,118,49,@on --Audit Object Derived Permission Event,RequestID
  exec sp_trace_setevent @traceidout,118,50,@on --Audit Object Derived Permission Event,XactSequence
  exec sp_trace_setevent @traceidout,118,21,@on --Audit Object Derived Permission Event,EventSubClass
  exec sp_trace_setevent @traceidout,118,23,@on --Audit Object Derived Permission Event,Success
  exec sp_trace_setevent @traceidout,118,26,@on --Audit Object Derived Permission Event,ServerName
  exec sp_trace_setevent @traceidout,118,28,@on --Audit Object Derived Permission Event,ObjectType
  exec sp_trace_setevent @traceidout,118,29,@on --Audit Object Derived Permission Event,NestLevel
  exec sp_trace_setevent @traceidout,118,34,@on --Audit Object Derived Permission Event,ObjectName
  exec sp_trace_setevent @traceidout,118,8,@on --Audit Object Derived Permission Event,HostName
  exec sp_trace_setevent @traceidout,118,9,@on --Audit Object Derived Permission Event,ClientProcessID
  exec sp_trace_setevent @traceidout,118,10,@on --Audit Object Derived Permission Event,ApplicationName
  exec sp_trace_setevent @traceidout,118,11,@on --Audit Object Derived Permission Event,LoginName
  exec sp_trace_setevent @traceidout,118,12,@on --Audit Object Derived Permission Event,SPID
  exec sp_trace_setevent @traceidout,118,14,@on --Audit Object Derived Permission Event,StartTime
  exec sp_trace_setevent @traceidout,128,1,@on --Audit Database Management Event,TextData
  exec sp_trace_setevent @traceidout,128,3,@on --Audit Database Management Event,DatabaseID
  exec sp_trace_setevent @traceidout,128,4,@on --Audit Database Management Event,TransactionID
  exec sp_trace_setevent @traceidout,128,6,@on --Audit Database Management Event,NTUserName
  exec sp_trace_setevent @traceidout,128,7,@on --Audit Database Management Event,NTDomainName
  exec sp_trace_setevent @traceidout,128,8,@on --Audit Database Management Event,HostName
  exec sp_trace_setevent @traceidout,128,64,@on --Audit Database Management Event,SessionLoginName
  exec sp_trace_setevent @traceidout,128,40,@on --Audit Database Management Event,DBUserName
  exec sp_trace_setevent @traceidout,128,41,@on --Audit Database Management Event,LoginSid
  exec sp_trace_setevent @traceidout,128,49,@on --Audit Database Management Event,RequestID
  exec sp_trace_setevent @traceidout,128,50,@on --Audit Database Management Event,XactSequence
  exec sp_trace_setevent @traceidout,128,51,@on --Audit Database Management Event,EventSequence
  exec sp_trace_setevent @traceidout,128,60,@on --Audit Database Management Event,IsSystem
  exec sp_trace_setevent @traceidout,128,26,@on --Audit Database Management Event,ServerName
  exec sp_trace_setevent @traceidout,128,28,@on --Audit Database Management Event,ObjectType
  exec sp_trace_setevent @traceidout,128,29,@on --Audit Database Management Event,NestLevel
  exec sp_trace_setevent @traceidout,128,34,@on --Audit Database Management Event,ObjectName
  exec sp_trace_setevent @traceidout,128,35,@on --Audit Database Management Event,DatabaseName
  exec sp_trace_setevent @traceidout,128,37,@on --Audit Database Management Event,OwnerName
  exec sp_trace_setevent @traceidout,128,10,@on --Audit Database Management Event,ApplicationName
  exec sp_trace_setevent @traceidout,128,11,@on --Audit Database Management Event,LoginName
  exec sp_trace_setevent @traceidout,128,12,@on --Audit Database Management Event,SPID
  exec sp_trace_setevent @traceidout,128,14,@on --Audit Database Management Event,StartTime
  exec sp_trace_setevent @traceidout,128,21,@on --Audit Database Management Event,EventSubClass
  exec sp_trace_setevent @traceidout,128,23,@on --Audit Database Management Event,Success
  exec sp_trace_setevent @traceidout,129,1,@on --Audit Database Object Management Event,TextData
  exec sp_trace_setevent @traceidout,129,3,@on --Audit Database Object Management Event,DatabaseID
  exec sp_trace_setevent @traceidout,129,4,@on --Audit Database Object Management Event,TransactionID
  exec sp_trace_setevent @traceidout,129,5,@on --Audit Database Object Management Event,LineNumber
  exec sp_trace_setevent @traceidout,129,6,@on --Audit Database Object Management Event,NTUserName
  exec sp_trace_setevent @traceidout,129,7,@on --Audit Database Object Management Event,NTDomainName
  exec sp_trace_setevent @traceidout,129,60,@on --Audit Database Object Management Event,IsSystem
  exec sp_trace_setevent @traceidout,129,64,@on --Audit Database Object Management Event,SessionLoginName
  exec sp_trace_setevent @traceidout,129,37,@on --Audit Database Object Management Event,OwnerName
  exec sp_trace_setevent @traceidout,129,40,@on --Audit Database Object Management Event,DBUserName
  exec sp_trace_setevent @traceidout,129,41,@on --Audit Database Object Management Event,LoginSid
  exec sp_trace_setevent @traceidout,129,49,@on --Audit Database Object Management Event,RequestID
  exec sp_trace_setevent @traceidout,129,50,@on --Audit Database Object Management Event,XactSequence
  exec sp_trace_setevent @traceidout,129,51,@on --Audit Database Object Management Event,EventSequence
  exec sp_trace_setevent @traceidout,129,23,@on --Audit Database Object Management Event,Success
  exec sp_trace_setevent @traceidout,129,26,@on --Audit Database Object Management Event,ServerName
  exec sp_trace_setevent @traceidout,129,28,@on --Audit Database Object Management Event,ObjectType
  exec sp_trace_setevent @traceidout,129,29,@on --Audit Database Object Management Event,NestLevel
  exec sp_trace_setevent @traceidout,129,34,@on --Audit Database Object Management Event,ObjectName
  exec sp_trace_setevent @traceidout,129,35,@on --Audit Database Object Management Event,DatabaseName
  exec sp_trace_setevent @traceidout,129,8,@on --Audit Database Object Management Event,HostName
  exec sp_trace_setevent @traceidout,129,10,@on --Audit Database Object Management Event,ApplicationName
  exec sp_trace_setevent @traceidout,129,11,@on --Audit Database Object Management Event,LoginName
  exec sp_trace_setevent @traceidout,129,12,@on --Audit Database Object Management Event,SPID
  exec sp_trace_setevent @traceidout,129,14,@on --Audit Database Object Management Event,StartTime
  exec sp_trace_setevent @traceidout,129,21,@on --Audit Database Object Management Event,EventSubClass
  exec sp_trace_setevent @traceidout,130,1,@on --Audit Database Principal Management Event,TextData
  exec sp_trace_setevent @traceidout,130,3,@on --Audit Database Principal Management Event,DatabaseID
  exec sp_trace_setevent @traceidout,130,4,@on --Audit Database Principal Management Event,TransactionID
  exec sp_trace_setevent @traceidout,130,6,@on --Audit Database Principal Management Event,NTUserName
  exec sp_trace_setevent @traceidout,130,7,@on --Audit Database Principal Management Event,NTDomainName
  exec sp_trace_setevent @traceidout,130,8,@on --Audit Database Principal Management Event,HostName
  exec sp_trace_setevent @traceidout,130,50,@on --Audit Database Principal Management Event,XactSequence
  exec sp_trace_setevent @traceidout,130,51,@on --Audit Database Principal Management Event,EventSequence
  exec sp_trace_setevent @traceidout,130,60,@on --Audit Database Principal Management Event,IsSystem
  exec sp_trace_setevent @traceidout,130,64,@on --Audit Database Principal Management Event,SessionLoginName
  exec sp_trace_setevent @traceidout,130,39,@on --Audit Database Principal Management Event,TargetUserName
  exec sp_trace_setevent @traceidout,130,40,@on --Audit Database Principal Management Event,DBUserName
  exec sp_trace_setevent @traceidout,130,41,@on --Audit Database Principal Management Event,LoginSid
  exec sp_trace_setevent @traceidout,130,42,@on --Audit Database Principal Management Event,TargetLoginName
  exec sp_trace_setevent @traceidout,130,43,@on --Audit Database Principal Management Event,TargetLoginSid
  exec sp_trace_setevent @traceidout,130,49,@on --Audit Database Principal Management Event,RequestID
  exec sp_trace_setevent @traceidout,130,26,@on --Audit Database Principal Management Event,ServerName
  exec sp_trace_setevent @traceidout,130,28,@on --Audit Database Principal Management Event,ObjectType
  exec sp_trace_setevent @traceidout,130,29,@on --Audit Database Principal Management Event,NestLevel
  exec sp_trace_setevent @traceidout,130,34,@on --Audit Database Principal Management Event,ObjectName
  exec sp_trace_setevent @traceidout,130,35,@on --Audit Database Principal Management Event,DatabaseName
  exec sp_trace_setevent @traceidout,130,37,@on --Audit Database Principal Management Event,OwnerName
  exec sp_trace_setevent @traceidout,130,10,@on --Audit Database Principal Management Event,ApplicationName
  exec sp_trace_setevent @traceidout,130,11,@on --Audit Database Principal Management Event,LoginName
  exec sp_trace_setevent @traceidout,130,12,@on --Audit Database Principal Management Event,SPID
  exec sp_trace_setevent @traceidout,130,14,@on --Audit Database Principal Management Event,StartTime
  exec sp_trace_setevent @traceidout,130,21,@on --Audit Database Principal Management Event,EventSubClass
  exec sp_trace_setevent @traceidout,130,23,@on --Audit Database Principal Management Event,Success
  exec sp_trace_setevent @traceidout,131,1,@on --Audit Schema Object Management Event,TextData
  exec sp_trace_setevent @traceidout,131,3,@on --Audit Schema Object Management Event,DatabaseID
  exec sp_trace_setevent @traceidout,131,4,@on --Audit Schema Object Management Event,TransactionID
  exec sp_trace_setevent @traceidout,131,6,@on --Audit Schema Object Management Event,NTUserName
  exec sp_trace_setevent @traceidout,131,7,@on --Audit Schema Object Management Event,NTDomainName
  exec sp_trace_setevent @traceidout,131,8,@on --Audit Schema Object Management Event,HostName
  exec sp_trace_setevent @traceidout,131,60,@on --Audit Schema Object Management Event,IsSystem
  exec sp_trace_setevent @traceidout,131,64,@on --Audit Schema Object Management Event,SessionLoginName
  exec sp_trace_setevent @traceidout,131,40,@on --Audit Schema Object Management Event,DBUserName
  exec sp_trace_setevent @traceidout,131,41,@on --Audit Schema Object Management Event,LoginSid
  exec sp_trace_setevent @traceidout,131,49,@on --Audit Schema Object Management Event,RequestID
  exec sp_trace_setevent @traceidout,131,50,@on --Audit Schema Object Management Event,XactSequence
  exec sp_trace_setevent @traceidout,131,51,@on --Audit Schema Object Management Event,EventSequence
  exec sp_trace_setevent @traceidout,131,59,@on --Audit Schema Object Management Event,ParentName
  exec sp_trace_setevent @traceidout,131,26,@on --Audit Schema Object Management Event,ServerName
  exec sp_trace_setevent @traceidout,131,28,@on --Audit Schema Object Management Event,ObjectType
  exec sp_trace_setevent @traceidout,131,29,@on --Audit Schema Object Management Event,NestLevel
  exec sp_trace_setevent @traceidout,131,34,@on --Audit Schema Object Management Event,ObjectName
  exec sp_trace_setevent @traceidout,131,35,@on --Audit Schema Object Management Event,DatabaseName
  exec sp_trace_setevent @traceidout,131,37,@on --Audit Schema Object Management Event,OwnerName
  exec sp_trace_setevent @traceidout,131,10,@on --Audit Schema Object Management Event,ApplicationName
  exec sp_trace_setevent @traceidout,131,11,@on --Audit Schema Object Management Event,LoginName
  exec sp_trace_setevent @traceidout,131,12,@on --Audit Schema Object Management Event,SPID
  exec sp_trace_setevent @traceidout,131,14,@on --Audit Schema Object Management Event,StartTime
  exec sp_trace_setevent @traceidout,131,21,@on --Audit Schema Object Management Event,EventSubClass
  exec sp_trace_setevent @traceidout,131,23,@on --Audit Schema Object Management Event,Success
  exec sp_trace_setevent @traceidout,132,1,@on --Audit Server Principal Impersonation Event,TextData
  exec sp_trace_setevent @traceidout,132,3,@on --Audit Server Principal Impersonation Event,DatabaseID
  exec sp_trace_setevent @traceidout,132,4,@on --Audit Server Principal Impersonation Event,TransactionID
  exec sp_trace_setevent @traceidout,132,6,@on --Audit Server Principal Impersonation Event,NTUserName
  exec sp_trace_setevent @traceidout,132,7,@on --Audit Server Principal Impersonation Event,NTDomainName
  exec sp_trace_setevent @traceidout,132,8,@on --Audit Server Principal Impersonation Event,HostName
  exec sp_trace_setevent @traceidout,132,60,@on --Audit Server Principal Impersonation Event,IsSystem
  exec sp_trace_setevent @traceidout,132,64,@on --Audit Server Principal Impersonation Event,SessionLoginName
  exec sp_trace_setevent @traceidout,132,37,@on --Audit Server Principal Impersonation Event,OwnerName
  exec sp_trace_setevent @traceidout,132,40,@on --Audit Server Principal Impersonation Event,DBUserName
  exec sp_trace_setevent @traceidout,132,41,@on --Audit Server Principal Impersonation Event,LoginSid
  exec sp_trace_setevent @traceidout,132,49,@on --Audit Server Principal Impersonation Event,RequestID
  exec sp_trace_setevent @traceidout,132,50,@on --Audit Server Principal Impersonation Event,XactSequence
  exec sp_trace_setevent @traceidout,132,51,@on --Audit Server Principal Impersonation Event,EventSequence
  exec sp_trace_setevent @traceidout,132,23,@on --Audit Server Principal Impersonation Event,Success
  exec sp_trace_setevent @traceidout,132,26,@on --Audit Server Principal Impersonation Event,ServerName
  exec sp_trace_setevent @traceidout,132,28,@on --Audit Server Principal Impersonation Event,ObjectType
  exec sp_trace_setevent @traceidout,132,29,@on --Audit Server Principal Impersonation Event,NestLevel
  exec sp_trace_setevent @traceidout,132,34,@on --Audit Server Principal Impersonation Event,ObjectName
  exec sp_trace_setevent @traceidout,132,35,@on --Audit Server Principal Impersonation Event,DatabaseName
  exec sp_trace_setevent @traceidout,132,10,@on --Audit Server Principal Impersonation Event,ApplicationName
  exec sp_trace_setevent @traceidout,132,11,@on --Audit Server Principal Impersonation Event,LoginName
  exec sp_trace_setevent @traceidout,132,12,@on --Audit Server Principal Impersonation Event,SPID
  exec sp_trace_setevent @traceidout,132,14,@on --Audit Server Principal Impersonation Event,StartTime
  exec sp_trace_setevent @traceidout,132,19,@on --Audit Server Principal Impersonation Event,Permissions
  exec sp_trace_setevent @traceidout,132,21,@on --Audit Server Principal Impersonation Event,EventSubClass
  exec sp_trace_setevent @traceidout,133,1,@on --Audit Database Principal Impersonation Event,TextData
  exec sp_trace_setevent @traceidout,133,3,@on --Audit Database Principal Impersonation Event,DatabaseID
  exec sp_trace_setevent @traceidout,133,4,@on --Audit Database Principal Impersonation Event,TransactionID
  exec sp_trace_setevent @traceidout,133,6,@on --Audit Database Principal Impersonation Event,NTUserName
  exec sp_trace_setevent @traceidout,133,7,@on --Audit Database Principal Impersonation Event,NTDomainName
  exec sp_trace_setevent @traceidout,133,8,@on --Audit Database Principal Impersonation Event,HostName
  exec sp_trace_setevent @traceidout,133,51,@on --Audit Database Principal Impersonation Event,EventSequence
  exec sp_trace_setevent @traceidout,133,60,@on --Audit Database Principal Impersonation Event,IsSystem
  exec sp_trace_setevent @traceidout,133,64,@on --Audit Database Principal Impersonation Event,SessionLoginName
  exec sp_trace_setevent @traceidout,133,37,@on --Audit Database Principal Impersonation Event,OwnerName
  exec sp_trace_setevent @traceidout,133,38,@on --Audit Database Principal Impersonation Event,RoleName
  exec sp_trace_setevent @traceidout,133,40,@on --Audit Database Principal Impersonation Event,DBUserName
  exec sp_trace_setevent @traceidout,133,41,@on --Audit Database Principal Impersonation Event,LoginSid
  exec sp_trace_setevent @traceidout,133,49,@on --Audit Database Principal Impersonation Event,RequestID
  exec sp_trace_setevent @traceidout,133,50,@on --Audit Database Principal Impersonation Event,XactSequence
  exec sp_trace_setevent @traceidout,133,23,@on --Audit Database Principal Impersonation Event,Success
  exec sp_trace_setevent @traceidout,133,26,@on --Audit Database Principal Impersonation Event,ServerName
  exec sp_trace_setevent @traceidout,133,28,@on --Audit Database Principal Impersonation Event,ObjectType
  exec sp_trace_setevent @traceidout,133,29,@on --Audit Database Principal Impersonation Event,NestLevel
  exec sp_trace_setevent @traceidout,133,34,@on --Audit Database Principal Impersonation Event,ObjectName
  exec sp_trace_setevent @traceidout,133,35,@on --Audit Database Principal Impersonation Event,DatabaseName
  exec sp_trace_setevent @traceidout,133,10,@on --Audit Database Principal Impersonation Event,ApplicationName
  exec sp_trace_setevent @traceidout,133,11,@on --Audit Database Principal Impersonation Event,LoginName
  exec sp_trace_setevent @traceidout,133,12,@on --Audit Database Principal Impersonation Event,SPID
  exec sp_trace_setevent @traceidout,133,14,@on --Audit Database Principal Impersonation Event,StartTime
  exec sp_trace_setevent @traceidout,133,19,@on --Audit Database Principal Impersonation Event,Permissions
  exec sp_trace_setevent @traceidout,133,21,@on --Audit Database Principal Impersonation Event,EventSubClass
  exec sp_trace_setevent @traceidout,134,1,@on --Audit Server Object Take Ownership Event,TextData
  exec sp_trace_setevent @traceidout,134,3,@on --Audit Server Object Take Ownership Event,DatabaseID
  exec sp_trace_setevent @traceidout,134,4,@on --Audit Server Object Take Ownership Event,TransactionID
  exec sp_trace_setevent @traceidout,134,6,@on --Audit Server Object Take Ownership Event,NTUserName
  exec sp_trace_setevent @traceidout,134,7,@on --Audit Server Object Take Ownership Event,NTDomainName
  exec sp_trace_setevent @traceidout,134,8,@on --Audit Server Object Take Ownership Event,HostName
  exec sp_trace_setevent @traceidout,134,51,@on --Audit Server Object Take Ownership Event,EventSequence
  exec sp_trace_setevent @traceidout,134,60,@on --Audit Server Object Take Ownership Event,IsSystem
  exec sp_trace_setevent @traceidout,134,64,@on --Audit Server Object Take Ownership Event,SessionLoginName
  exec sp_trace_setevent @traceidout,134,40,@on --Audit Server Object Take Ownership Event,DBUserName
  exec sp_trace_setevent @traceidout,134,41,@on --Audit Server Object Take Ownership Event,LoginSid
  exec sp_trace_setevent @traceidout,134,42,@on --Audit Server Object Take Ownership Event,TargetLoginName
  exec sp_trace_setevent @traceidout,134,43,@on --Audit Server Object Take Ownership Event,TargetLoginSid
  exec sp_trace_setevent @traceidout,134,49,@on --Audit Server Object Take Ownership Event,RequestID
  exec sp_trace_setevent @traceidout,134,50,@on --Audit Server Object Take Ownership Event,XactSequence
  exec sp_trace_setevent @traceidout,134,28,@on --Audit Server Object Take Ownership Event,ObjectType
  exec sp_trace_setevent @traceidout,134,29,@on --Audit Server Object Take Ownership Event,NestLevel
  exec sp_trace_setevent @traceidout,134,34,@on --Audit Server Object Take Ownership Event,ObjectName
  exec sp_trace_setevent @traceidout,134,35,@on --Audit Server Object Take Ownership Event,DatabaseName
  exec sp_trace_setevent @traceidout,134,37,@on --Audit Server Object Take Ownership Event,OwnerName
  exec sp_trace_setevent @traceidout,134,39,@on --Audit Server Object Take Ownership Event,TargetUserName
  exec sp_trace_setevent @traceidout,134,10,@on --Audit Server Object Take Ownership Event,ApplicationName
  exec sp_trace_setevent @traceidout,134,11,@on --Audit Server Object Take Ownership Event,LoginName
  exec sp_trace_setevent @traceidout,134,12,@on --Audit Server Object Take Ownership Event,SPID
  exec sp_trace_setevent @traceidout,134,14,@on --Audit Server Object Take Ownership Event,StartTime
  exec sp_trace_setevent @traceidout,134,23,@on --Audit Server Object Take Ownership Event,Success
  exec sp_trace_setevent @traceidout,134,26,@on --Audit Server Object Take Ownership Event,ServerName
  exec sp_trace_setevent @traceidout,135,1,@on --Audit Database Object Take Ownership Event,TextData
  exec sp_trace_setevent @traceidout,135,3,@on --Audit Database Object Take Ownership Event,DatabaseID
  exec sp_trace_setevent @traceidout,135,4,@on --Audit Database Object Take Ownership Event,TransactionID
  exec sp_trace_setevent @traceidout,135,6,@on --Audit Database Object Take Ownership Event,NTUserName
  exec sp_trace_setevent @traceidout,135,7,@on --Audit Database Object Take Ownership Event,NTDomainName
  exec sp_trace_setevent @traceidout,135,8,@on --Audit Database Object Take Ownership Event,HostName
  exec sp_trace_setevent @traceidout,135,64,@on --Audit Database Object Take Ownership Event,SessionLoginName
  exec sp_trace_setevent @traceidout,135,40,@on --Audit Database Object Take Ownership Event,DBUserName
  exec sp_trace_setevent @traceidout,135,41,@on --Audit Database Object Take Ownership Event,LoginSid
  exec sp_trace_setevent @traceidout,135,49,@on --Audit Database Object Take Ownership Event,RequestID
  exec sp_trace_setevent @traceidout,135,50,@on --Audit Database Object Take Ownership Event,XactSequence
  exec sp_trace_setevent @traceidout,135,51,@on --Audit Database Object Take Ownership Event,EventSequence
  exec sp_trace_setevent @traceidout,135,60,@on --Audit Database Object Take Ownership Event,IsSystem
  exec sp_trace_setevent @traceidout,135,28,@on --Audit Database Object Take Ownership Event,ObjectType
  exec sp_trace_setevent @traceidout,135,29,@on --Audit Database Object Take Ownership Event,NestLevel
  exec sp_trace_setevent @traceidout,135,34,@on --Audit Database Object Take Ownership Event,ObjectName
  exec sp_trace_setevent @traceidout,135,35,@on --Audit Database Object Take Ownership Event,DatabaseName
  exec sp_trace_setevent @traceidout,135,37,@on --Audit Database Object Take Ownership Event,OwnerName
  exec sp_trace_setevent @traceidout,135,39,@on --Audit Database Object Take Ownership Event,TargetUserName
  exec sp_trace_setevent @traceidout,135,10,@on --Audit Database Object Take Ownership Event,ApplicationName
  exec sp_trace_setevent @traceidout,135,11,@on --Audit Database Object Take Ownership Event,LoginName
  exec sp_trace_setevent @traceidout,135,12,@on --Audit Database Object Take Ownership Event,SPID
  exec sp_trace_setevent @traceidout,135,14,@on --Audit Database Object Take Ownership Event,StartTime
  exec sp_trace_setevent @traceidout,135,23,@on --Audit Database Object Take Ownership Event,Success
  exec sp_trace_setevent @traceidout,135,26,@on --Audit Database Object Take Ownership Event,ServerName
  exec sp_trace_setevent @traceidout,152,1,@on --Audit Change Database Owner,TextData
  exec sp_trace_setevent @traceidout,152,3,@on --Audit Change Database Owner,DatabaseID
  exec sp_trace_setevent @traceidout,152,4,@on --Audit Change Database Owner,TransactionID
  exec sp_trace_setevent @traceidout,152,6,@on --Audit Change Database Owner,NTUserName
  exec sp_trace_setevent @traceidout,152,7,@on --Audit Change Database Owner,NTDomainName
  exec sp_trace_setevent @traceidout,152,8,@on --Audit Change Database Owner,HostName
  exec sp_trace_setevent @traceidout,152,50,@on --Audit Change Database Owner,XactSequence
  exec sp_trace_setevent @traceidout,152,51,@on --Audit Change Database Owner,EventSequence
  exec sp_trace_setevent @traceidout,152,60,@on --Audit Change Database Owner,IsSystem
  exec sp_trace_setevent @traceidout,152,64,@on --Audit Change Database Owner,SessionLoginName
  exec sp_trace_setevent @traceidout,152,39,@on --Audit Change Database Owner,TargetUserName
  exec sp_trace_setevent @traceidout,152,40,@on --Audit Change Database Owner,DBUserName
  exec sp_trace_setevent @traceidout,152,41,@on --Audit Change Database Owner,LoginSid
  exec sp_trace_setevent @traceidout,152,42,@on --Audit Change Database Owner,TargetLoginName
  exec sp_trace_setevent @traceidout,152,43,@on --Audit Change Database Owner,TargetLoginSid
  exec sp_trace_setevent @traceidout,152,49,@on --Audit Change Database Owner,RequestID
  exec sp_trace_setevent @traceidout,152,26,@on --Audit Change Database Owner,ServerName
  exec sp_trace_setevent @traceidout,152,28,@on --Audit Change Database Owner,ObjectType
  exec sp_trace_setevent @traceidout,152,29,@on --Audit Change Database Owner,NestLevel
  exec sp_trace_setevent @traceidout,152,34,@on --Audit Change Database Owner,ObjectName
  exec sp_trace_setevent @traceidout,152,35,@on --Audit Change Database Owner,DatabaseName
  exec sp_trace_setevent @traceidout,152,37,@on --Audit Change Database Owner,OwnerName
  exec sp_trace_setevent @traceidout,152,9,@on --Audit Change Database Owner,ClientProcessID
  exec sp_trace_setevent @traceidout,152,10,@on --Audit Change Database Owner,ApplicationName
  exec sp_trace_setevent @traceidout,152,11,@on --Audit Change Database Owner,LoginName
  exec sp_trace_setevent @traceidout,152,12,@on --Audit Change Database Owner,SPID
  exec sp_trace_setevent @traceidout,152,14,@on --Audit Change Database Owner,StartTime
  exec sp_trace_setevent @traceidout,152,23,@on --Audit Change Database Owner,Success
  exec sp_trace_setevent @traceidout,153,1,@on --Audit Schema Object Take Ownership Event,TextData
  exec sp_trace_setevent @traceidout,153,3,@on --Audit Schema Object Take Ownership Event,DatabaseID
  exec sp_trace_setevent @traceidout,153,4,@on --Audit Schema Object Take Ownership Event,TransactionID
  exec sp_trace_setevent @traceidout,153,6,@on --Audit Schema Object Take Ownership Event,NTUserName
  exec sp_trace_setevent @traceidout,153,7,@on --Audit Schema Object Take Ownership Event,NTDomainName
  exec sp_trace_setevent @traceidout,153,8,@on --Audit Schema Object Take Ownership Event,HostName
  exec sp_trace_setevent @traceidout,153,51,@on --Audit Schema Object Take Ownership Event,EventSequence
  exec sp_trace_setevent @traceidout,153,59,@on --Audit Schema Object Take Ownership Event,ParentName
  exec sp_trace_setevent @traceidout,153,60,@on --Audit Schema Object Take Ownership Event,IsSystem
  exec sp_trace_setevent @traceidout,153,64,@on --Audit Schema Object Take Ownership Event,SessionLoginName
  exec sp_trace_setevent @traceidout,153,40,@on --Audit Schema Object Take Ownership Event,DBUserName
  exec sp_trace_setevent @traceidout,153,41,@on --Audit Schema Object Take Ownership Event,LoginSid
  exec sp_trace_setevent @traceidout,153,42,@on --Audit Schema Object Take Ownership Event,TargetLoginName
  exec sp_trace_setevent @traceidout,153,43,@on --Audit Schema Object Take Ownership Event,TargetLoginSid
  exec sp_trace_setevent @traceidout,153,49,@on --Audit Schema Object Take Ownership Event,RequestID
  exec sp_trace_setevent @traceidout,153,50,@on --Audit Schema Object Take Ownership Event,XactSequence
  exec sp_trace_setevent @traceidout,153,28,@on --Audit Schema Object Take Ownership Event,ObjectType
  exec sp_trace_setevent @traceidout,153,29,@on --Audit Schema Object Take Ownership Event,NestLevel
  exec sp_trace_setevent @traceidout,153,34,@on --Audit Schema Object Take Ownership Event,ObjectName
  exec sp_trace_setevent @traceidout,153,35,@on --Audit Schema Object Take Ownership Event,DatabaseName
  exec sp_trace_setevent @traceidout,153,37,@on --Audit Schema Object Take Ownership Event,OwnerName
  exec sp_trace_setevent @traceidout,153,39,@on --Audit Schema Object Take Ownership Event,TargetUserName
  exec sp_trace_setevent @traceidout,153,10,@on --Audit Schema Object Take Ownership Event,ApplicationName
  exec sp_trace_setevent @traceidout,153,11,@on --Audit Schema Object Take Ownership Event,LoginName
  exec sp_trace_setevent @traceidout,153,12,@on --Audit Schema Object Take Ownership Event,SPID
  exec sp_trace_setevent @traceidout,153,14,@on --Audit Schema Object Take Ownership Event,StartTime
  exec sp_trace_setevent @traceidout,153,23,@on --Audit Schema Object Take Ownership Event,Success
  exec sp_trace_setevent @traceidout,153,26,@on --Audit Schema Object Take Ownership Event,ServerName
  exec sp_trace_setevent @traceidout,170,1,@on --Audit Server Scope GDR Event,TextData
  exec sp_trace_setevent @traceidout,170,3,@on --Audit Server Scope GDR Event,DatabaseID
  exec sp_trace_setevent @traceidout,170,4,@on --Audit Server Scope GDR Event,TransactionID
  exec sp_trace_setevent @traceidout,170,6,@on --Audit Server Scope GDR Event,NTUserName
  exec sp_trace_setevent @traceidout,170,7,@on --Audit Server Scope GDR Event,NTDomainName
  exec sp_trace_setevent @traceidout,170,8,@on --Audit Server Scope GDR Event,HostName
  exec sp_trace_setevent @traceidout,170,49,@on --Audit Server Scope GDR Event,RequestID
  exec sp_trace_setevent @traceidout,170,50,@on --Audit Server Scope GDR Event,XactSequence
  exec sp_trace_setevent @traceidout,170,51,@on --Audit Server Scope GDR Event,EventSequence
  exec sp_trace_setevent @traceidout,170,60,@on --Audit Server Scope GDR Event,IsSystem
  exec sp_trace_setevent @traceidout,170,64,@on --Audit Server Scope GDR Event,SessionLoginName
  exec sp_trace_setevent @traceidout,170,35,@on --Audit Server Scope GDR Event,DatabaseName
  exec sp_trace_setevent @traceidout,170,37,@on --Audit Server Scope GDR Event,OwnerName
  exec sp_trace_setevent @traceidout,170,40,@on --Audit Server Scope GDR Event,DBUserName
  exec sp_trace_setevent @traceidout,170,41,@on --Audit Server Scope GDR Event,LoginSid
  exec sp_trace_setevent @traceidout,170,42,@on --Audit Server Scope GDR Event,TargetLoginName
  exec sp_trace_setevent @traceidout,170,43,@on --Audit Server Scope GDR Event,TargetLoginSid
  exec sp_trace_setevent @traceidout,170,21,@on --Audit Server Scope GDR Event,EventSubClass
  exec sp_trace_setevent @traceidout,170,23,@on --Audit Server Scope GDR Event,Success
  exec sp_trace_setevent @traceidout,170,26,@on --Audit Server Scope GDR Event,ServerName
  exec sp_trace_setevent @traceidout,170,28,@on --Audit Server Scope GDR Event,ObjectType
  exec sp_trace_setevent @traceidout,170,29,@on --Audit Server Scope GDR Event,NestLevel
  exec sp_trace_setevent @traceidout,170,34,@on --Audit Server Scope GDR Event,ObjectName
  exec sp_trace_setevent @traceidout,170,9,@on --Audit Server Scope GDR Event,ClientProcessID
  exec sp_trace_setevent @traceidout,170,10,@on --Audit Server Scope GDR Event,ApplicationName
  exec sp_trace_setevent @traceidout,170,11,@on --Audit Server Scope GDR Event,LoginName
  exec sp_trace_setevent @traceidout,170,12,@on --Audit Server Scope GDR Event,SPID
  exec sp_trace_setevent @traceidout,170,14,@on --Audit Server Scope GDR Event,StartTime
  exec sp_trace_setevent @traceidout,170,19,@on --Audit Server Scope GDR Event,Permissions
  exec sp_trace_setevent @traceidout,171,1,@on --Audit Server Object GDR Event,TextData
  exec sp_trace_setevent @traceidout,171,3,@on --Audit Server Object GDR Event,DatabaseID
  exec sp_trace_setevent @traceidout,171,4,@on --Audit Server Object GDR Event,TransactionID
  exec sp_trace_setevent @traceidout,171,6,@on --Audit Server Object GDR Event,NTUserName
  exec sp_trace_setevent @traceidout,171,7,@on --Audit Server Object GDR Event,NTDomainName
  exec sp_trace_setevent @traceidout,171,8,@on --Audit Server Object GDR Event,HostName
  exec sp_trace_setevent @traceidout,171,49,@on --Audit Server Object GDR Event,RequestID
  exec sp_trace_setevent @traceidout,171,50,@on --Audit Server Object GDR Event,XactSequence
  exec sp_trace_setevent @traceidout,171,51,@on --Audit Server Object GDR Event,EventSequence
  exec sp_trace_setevent @traceidout,171,60,@on --Audit Server Object GDR Event,IsSystem
  exec sp_trace_setevent @traceidout,171,64,@on --Audit Server Object GDR Event,SessionLoginName
  exec sp_trace_setevent @traceidout,171,35,@on --Audit Server Object GDR Event,DatabaseName
  exec sp_trace_setevent @traceidout,171,37,@on --Audit Server Object GDR Event,OwnerName
  exec sp_trace_setevent @traceidout,171,40,@on --Audit Server Object GDR Event,DBUserName
  exec sp_trace_setevent @traceidout,171,41,@on --Audit Server Object GDR Event,LoginSid
  exec sp_trace_setevent @traceidout,171,42,@on --Audit Server Object GDR Event,TargetLoginName
  exec sp_trace_setevent @traceidout,171,43,@on --Audit Server Object GDR Event,TargetLoginSid
  exec sp_trace_setevent @traceidout,171,21,@on --Audit Server Object GDR Event,EventSubClass
  exec sp_trace_setevent @traceidout,171,23,@on --Audit Server Object GDR Event,Success
  exec sp_trace_setevent @traceidout,171,26,@on --Audit Server Object GDR Event,ServerName
  exec sp_trace_setevent @traceidout,171,28,@on --Audit Server Object GDR Event,ObjectType
  exec sp_trace_setevent @traceidout,171,29,@on --Audit Server Object GDR Event,NestLevel
  exec sp_trace_setevent @traceidout,171,34,@on --Audit Server Object GDR Event,ObjectName
  exec sp_trace_setevent @traceidout,171,9,@on --Audit Server Object GDR Event,ClientProcessID
  exec sp_trace_setevent @traceidout,171,10,@on --Audit Server Object GDR Event,ApplicationName
  exec sp_trace_setevent @traceidout,171,11,@on --Audit Server Object GDR Event,LoginName
  exec sp_trace_setevent @traceidout,171,12,@on --Audit Server Object GDR Event,SPID
  exec sp_trace_setevent @traceidout,171,14,@on --Audit Server Object GDR Event,StartTime
  exec sp_trace_setevent @traceidout,171,19,@on --Audit Server Object GDR Event,Permissions
  exec sp_trace_setevent @traceidout,172,1,@on --Audit Database Object GDR Event,TextData
  exec sp_trace_setevent @traceidout,172,3,@on --Audit Database Object GDR Event,DatabaseID
  exec sp_trace_setevent @traceidout,172,4,@on --Audit Database Object GDR Event,TransactionID
  exec sp_trace_setevent @traceidout,172,6,@on --Audit Database Object GDR Event,NTUserName
  exec sp_trace_setevent @traceidout,172,7,@on --Audit Database Object GDR Event,NTDomainName
  exec sp_trace_setevent @traceidout,172,8,@on --Audit Database Object GDR Event,HostName
  exec sp_trace_setevent @traceidout,172,43,@on --Audit Database Object GDR Event,TargetLoginSid
  exec sp_trace_setevent @traceidout,172,49,@on --Audit Database Object GDR Event,RequestID
  exec sp_trace_setevent @traceidout,172,50,@on --Audit Database Object GDR Event,XactSequence
  exec sp_trace_setevent @traceidout,172,51,@on --Audit Database Object GDR Event,EventSequence
  exec sp_trace_setevent @traceidout,172,60,@on --Audit Database Object GDR Event,IsSystem
  exec sp_trace_setevent @traceidout,172,64,@on --Audit Database Object GDR Event,SessionLoginName
  exec sp_trace_setevent @traceidout,172,35,@on --Audit Database Object GDR Event,DatabaseName
  exec sp_trace_setevent @traceidout,172,37,@on --Audit Database Object GDR Event,OwnerName
  exec sp_trace_setevent @traceidout,172,39,@on --Audit Database Object GDR Event,TargetUserName
  exec sp_trace_setevent @traceidout,172,40,@on --Audit Database Object GDR Event,DBUserName
  exec sp_trace_setevent @traceidout,172,41,@on --Audit Database Object GDR Event,LoginSid
  exec sp_trace_setevent @traceidout,172,42,@on --Audit Database Object GDR Event,TargetLoginName
  exec sp_trace_setevent @traceidout,172,21,@on --Audit Database Object GDR Event,EventSubClass
  exec sp_trace_setevent @traceidout,172,23,@on --Audit Database Object GDR Event,Success
  exec sp_trace_setevent @traceidout,172,26,@on --Audit Database Object GDR Event,ServerName
  exec sp_trace_setevent @traceidout,172,28,@on --Audit Database Object GDR Event,ObjectType
  exec sp_trace_setevent @traceidout,172,29,@on --Audit Database Object GDR Event,NestLevel
  exec sp_trace_setevent @traceidout,172,34,@on --Audit Database Object GDR Event,ObjectName
  exec sp_trace_setevent @traceidout,172,9,@on --Audit Database Object GDR Event,ClientProcessID
  exec sp_trace_setevent @traceidout,172,10,@on --Audit Database Object GDR Event,ApplicationName
  exec sp_trace_setevent @traceidout,172,11,@on --Audit Database Object GDR Event,LoginName
  exec sp_trace_setevent @traceidout,172,12,@on --Audit Database Object GDR Event,SPID
  exec sp_trace_setevent @traceidout,172,14,@on --Audit Database Object GDR Event,StartTime
  exec sp_trace_setevent @traceidout,172,19,@on --Audit Database Object GDR Event,Permissions
  exec sp_trace_setevent @traceidout,173,1,@on --Audit Server Operation Event,TextData
  exec sp_trace_setevent @traceidout,173,3,@on --Audit Server Operation Event,DatabaseID
  exec sp_trace_setevent @traceidout,173,4,@on --Audit Server Operation Event,TransactionID
  exec sp_trace_setevent @traceidout,173,6,@on --Audit Server Operation Event,NTUserName
  exec sp_trace_setevent @traceidout,173,7,@on --Audit Server Operation Event,NTDomainName
  exec sp_trace_setevent @traceidout,173,8,@on --Audit Server Operation Event,HostName
  exec sp_trace_setevent @traceidout,173,64,@on --Audit Server Operation Event,SessionLoginName
  exec sp_trace_setevent @traceidout,173,40,@on --Audit Server Operation Event,DBUserName
  exec sp_trace_setevent @traceidout,173,41,@on --Audit Server Operation Event,LoginSid
  exec sp_trace_setevent @traceidout,173,49,@on --Audit Server Operation Event,RequestID
  exec sp_trace_setevent @traceidout,173,50,@on --Audit Server Operation Event,XactSequence
  exec sp_trace_setevent @traceidout,173,51,@on --Audit Server Operation Event,EventSequence
  exec sp_trace_setevent @traceidout,173,60,@on --Audit Server Operation Event,IsSystem
  exec sp_trace_setevent @traceidout,173,26,@on --Audit Server Operation Event,ServerName
  exec sp_trace_setevent @traceidout,173,28,@on --Audit Server Operation Event,ObjectType
  exec sp_trace_setevent @traceidout,173,29,@on --Audit Server Operation Event,NestLevel
  exec sp_trace_setevent @traceidout,173,34,@on --Audit Server Operation Event,ObjectName
  exec sp_trace_setevent @traceidout,173,35,@on --Audit Server Operation Event,DatabaseName
  exec sp_trace_setevent @traceidout,173,37,@on --Audit Server Operation Event,OwnerName
  exec sp_trace_setevent @traceidout,173,10,@on --Audit Server Operation Event,ApplicationName
  exec sp_trace_setevent @traceidout,173,11,@on --Audit Server Operation Event,LoginName
  exec sp_trace_setevent @traceidout,173,12,@on --Audit Server Operation Event,SPID
  exec sp_trace_setevent @traceidout,173,14,@on --Audit Server Operation Event,StartTime
  exec sp_trace_setevent @traceidout,173,21,@on --Audit Server Operation Event,EventSubClass
  exec sp_trace_setevent @traceidout,173,23,@on --Audit Server Operation Event,Success
  exec sp_trace_setevent @traceidout,175,1,@on --Audit Server Alter Trace Event,TextData
  exec sp_trace_setevent @traceidout,175,3,@on --Audit Server Alter Trace Event,DatabaseID
  exec sp_trace_setevent @traceidout,175,4,@on --Audit Server Alter Trace Event,TransactionID
  exec sp_trace_setevent @traceidout,175,6,@on --Audit Server Alter Trace Event,NTUserName
  exec sp_trace_setevent @traceidout,175,7,@on --Audit Server Alter Trace Event,NTDomainName
  exec sp_trace_setevent @traceidout,175,8,@on --Audit Server Alter Trace Event,HostName
  exec sp_trace_setevent @traceidout,175,41,@on --Audit Server Alter Trace Event,LoginSid
  exec sp_trace_setevent @traceidout,175,49,@on --Audit Server Alter Trace Event,RequestID
  exec sp_trace_setevent @traceidout,175,50,@on --Audit Server Alter Trace Event,XactSequence
  exec sp_trace_setevent @traceidout,175,51,@on --Audit Server Alter Trace Event,EventSequence
  exec sp_trace_setevent @traceidout,175,60,@on --Audit Server Alter Trace Event,IsSystem
  exec sp_trace_setevent @traceidout,175,64,@on --Audit Server Alter Trace Event,SessionLoginName
  exec sp_trace_setevent @traceidout,175,28,@on --Audit Server Alter Trace Event,ObjectType
  exec sp_trace_setevent @traceidout,175,29,@on --Audit Server Alter Trace Event,NestLevel
  exec sp_trace_setevent @traceidout,175,34,@on --Audit Server Alter Trace Event,ObjectName
  exec sp_trace_setevent @traceidout,175,35,@on --Audit Server Alter Trace Event,DatabaseName
  exec sp_trace_setevent @traceidout,175,37,@on --Audit Server Alter Trace Event,OwnerName
  exec sp_trace_setevent @traceidout,175,40,@on --Audit Server Alter Trace Event,DBUserName
  exec sp_trace_setevent @traceidout,175,10,@on --Audit Server Alter Trace Event,ApplicationName
  exec sp_trace_setevent @traceidout,175,11,@on --Audit Server Alter Trace Event,LoginName
  exec sp_trace_setevent @traceidout,175,12,@on --Audit Server Alter Trace Event,SPID
  exec sp_trace_setevent @traceidout,175,14,@on --Audit Server Alter Trace Event,StartTime
  exec sp_trace_setevent @traceidout,175,23,@on --Audit Server Alter Trace Event,Success
  exec sp_trace_setevent @traceidout,175,26,@on --Audit Server Alter Trace Event,ServerName
  exec sp_trace_setevent @traceidout,176,1,@on --Audit Server Object Management Event,TextData
  exec sp_trace_setevent @traceidout,176,3,@on --Audit Server Object Management Event,DatabaseID
  exec sp_trace_setevent @traceidout,176,4,@on --Audit Server Object Management Event,TransactionID
  exec sp_trace_setevent @traceidout,176,6,@on --Audit Server Object Management Event,NTUserName
  exec sp_trace_setevent @traceidout,176,7,@on --Audit Server Object Management Event,NTDomainName
  exec sp_trace_setevent @traceidout,176,8,@on --Audit Server Object Management Event,HostName
  exec sp_trace_setevent @traceidout,176,50,@on --Audit Server Object Management Event,XactSequence
  exec sp_trace_setevent @traceidout,176,51,@on --Audit Server Object Management Event,EventSequence
  exec sp_trace_setevent @traceidout,176,60,@on --Audit Server Object Management Event,IsSystem
  exec sp_trace_setevent @traceidout,176,64,@on --Audit Server Object Management Event,SessionLoginName
  exec sp_trace_setevent @traceidout,176,37,@on --Audit Server Object Management Event,OwnerName
  exec sp_trace_setevent @traceidout,176,40,@on --Audit Server Object Management Event,DBUserName
  exec sp_trace_setevent @traceidout,176,41,@on --Audit Server Object Management Event,LoginSid
  exec sp_trace_setevent @traceidout,176,45,@on --Audit Server Object Management Event,LinkedServerName
  exec sp_trace_setevent @traceidout,176,46,@on --Audit Server Object Management Event,ProviderName
  exec sp_trace_setevent @traceidout,176,49,@on --Audit Server Object Management Event,RequestID
  exec sp_trace_setevent @traceidout,176,23,@on --Audit Server Object Management Event,Success
  exec sp_trace_setevent @traceidout,176,26,@on --Audit Server Object Management Event,ServerName
  exec sp_trace_setevent @traceidout,176,28,@on --Audit Server Object Management Event,ObjectType
  exec sp_trace_setevent @traceidout,176,29,@on --Audit Server Object Management Event,NestLevel
  exec sp_trace_setevent @traceidout,176,34,@on --Audit Server Object Management Event,ObjectName
  exec sp_trace_setevent @traceidout,176,35,@on --Audit Server Object Management Event,DatabaseName
  exec sp_trace_setevent @traceidout,176,9,@on --Audit Server Object Management Event,ClientProcessID
  exec sp_trace_setevent @traceidout,176,10,@on --Audit Server Object Management Event,ApplicationName
  exec sp_trace_setevent @traceidout,176,11,@on --Audit Server Object Management Event,LoginName
  exec sp_trace_setevent @traceidout,176,12,@on --Audit Server Object Management Event,SPID
  exec sp_trace_setevent @traceidout,176,14,@on --Audit Server Object Management Event,StartTime
  exec sp_trace_setevent @traceidout,176,21,@on --Audit Server Object Management Event,EventSubClass
  exec sp_trace_setevent @traceidout,177,1,@on --Audit Server Principal Management Event,TextData
  exec sp_trace_setevent @traceidout,177,3,@on --Audit Server Principal Management Event,DatabaseID
  exec sp_trace_setevent @traceidout,177,4,@on --Audit Server Principal Management Event,TransactionID
  exec sp_trace_setevent @traceidout,177,5,@on --Audit Server Principal Management Event,LineNumber
  exec sp_trace_setevent @traceidout,177,6,@on --Audit Server Principal Management Event,NTUserName
  exec sp_trace_setevent @traceidout,177,7,@on --Audit Server Principal Management Event,NTDomainName
  exec sp_trace_setevent @traceidout,177,64,@on --Audit Server Principal Management Event,SessionLoginName
  exec sp_trace_setevent @traceidout,177,43,@on --Audit Server Principal Management Event,TargetLoginSid
  exec sp_trace_setevent @traceidout,177,45,@on --Audit Server Principal Management Event,LinkedServerName
  exec sp_trace_setevent @traceidout,177,49,@on --Audit Server Principal Management Event,RequestID
  exec sp_trace_setevent @traceidout,177,50,@on --Audit Server Principal Management Event,XactSequence
  exec sp_trace_setevent @traceidout,177,51,@on --Audit Server Principal Management Event,EventSequence
  exec sp_trace_setevent @traceidout,177,60,@on --Audit Server Principal Management Event,IsSystem
  exec sp_trace_setevent @traceidout,177,35,@on --Audit Server Principal Management Event,DatabaseName
  exec sp_trace_setevent @traceidout,177,37,@on --Audit Server Principal Management Event,OwnerName
  exec sp_trace_setevent @traceidout,177,39,@on --Audit Server Principal Management Event,TargetUserName
  exec sp_trace_setevent @traceidout,177,40,@on --Audit Server Principal Management Event,DBUserName
  exec sp_trace_setevent @traceidout,177,41,@on --Audit Server Principal Management Event,LoginSid
  exec sp_trace_setevent @traceidout,177,42,@on --Audit Server Principal Management Event,TargetLoginName
  exec sp_trace_setevent @traceidout,177,21,@on --Audit Server Principal Management Event,EventSubClass
  exec sp_trace_setevent @traceidout,177,23,@on --Audit Server Principal Management Event,Success
  exec sp_trace_setevent @traceidout,177,26,@on --Audit Server Principal Management Event,ServerName
  exec sp_trace_setevent @traceidout,177,28,@on --Audit Server Principal Management Event,ObjectType
  exec sp_trace_setevent @traceidout,177,29,@on --Audit Server Principal Management Event,NestLevel
  exec sp_trace_setevent @traceidout,177,34,@on --Audit Server Principal Management Event,ObjectName
  exec sp_trace_setevent @traceidout,177,8,@on --Audit Server Principal Management Event,HostName
  exec sp_trace_setevent @traceidout,177,9,@on --Audit Server Principal Management Event,ClientProcessID
  exec sp_trace_setevent @traceidout,177,10,@on --Audit Server Principal Management Event,ApplicationName
  exec sp_trace_setevent @traceidout,177,11,@on --Audit Server Principal Management Event,LoginName
  exec sp_trace_setevent @traceidout,177,12,@on --Audit Server Principal Management Event,SPID
  exec sp_trace_setevent @traceidout,177,14,@on --Audit Server Principal Management Event,StartTime
  exec sp_trace_setevent @traceidout,178,1,@on --Audit Database Operation Event,TextData
  exec sp_trace_setevent @traceidout,178,3,@on --Audit Database Operation Event,DatabaseID
  exec sp_trace_setevent @traceidout,178,4,@on --Audit Database Operation Event,TransactionID
  exec sp_trace_setevent @traceidout,178,6,@on --Audit Database Operation Event,NTUserName
  exec sp_trace_setevent @traceidout,178,7,@on --Audit Database Operation Event,NTDomainName
  exec sp_trace_setevent @traceidout,178,8,@on --Audit Database Operation Event,HostName
  exec sp_trace_setevent @traceidout,178,64,@on --Audit Database Operation Event,SessionLoginName
  exec sp_trace_setevent @traceidout,178,40,@on --Audit Database Operation Event,DBUserName
  exec sp_trace_setevent @traceidout,178,41,@on --Audit Database Operation Event,LoginSid
  exec sp_trace_setevent @traceidout,178,49,@on --Audit Database Operation Event,RequestID
  exec sp_trace_setevent @traceidout,178,50,@on --Audit Database Operation Event,XactSequence
  exec sp_trace_setevent @traceidout,178,51,@on --Audit Database Operation Event,EventSequence
  exec sp_trace_setevent @traceidout,178,60,@on --Audit Database Operation Event,IsSystem
  exec sp_trace_setevent @traceidout,178,26,@on --Audit Database Operation Event,ServerName
  exec sp_trace_setevent @traceidout,178,28,@on --Audit Database Operation Event,ObjectType
  exec sp_trace_setevent @traceidout,178,29,@on --Audit Database Operation Event,NestLevel
  exec sp_trace_setevent @traceidout,178,34,@on --Audit Database Operation Event,ObjectName
  exec sp_trace_setevent @traceidout,178,35,@on --Audit Database Operation Event,DatabaseName
  exec sp_trace_setevent @traceidout,178,37,@on --Audit Database Operation Event,OwnerName
  exec sp_trace_setevent @traceidout,178,10,@on --Audit Database Operation Event,ApplicationName
  exec sp_trace_setevent @traceidout,178,11,@on --Audit Database Operation Event,LoginName
  exec sp_trace_setevent @traceidout,178,12,@on --Audit Database Operation Event,SPID
  exec sp_trace_setevent @traceidout,178,14,@on --Audit Database Operation Event,StartTime
  exec sp_trace_setevent @traceidout,178,21,@on --Audit Database Operation Event,EventSubClass
  exec sp_trace_setevent @traceidout,178,23,@on --Audit Database Operation Event,Success
  exec sp_trace_setevent @traceidout,180,1,@on --Audit Database Object Access Event,TextData
  exec sp_trace_setevent @traceidout,180,3,@on --Audit Database Object Access Event,DatabaseID
  exec sp_trace_setevent @traceidout,180,4,@on --Audit Database Object Access Event,TransactionID
  exec sp_trace_setevent @traceidout,180,6,@on --Audit Database Object Access Event,NTUserName
  exec sp_trace_setevent @traceidout,180,7,@on --Audit Database Object Access Event,NTDomainName
  exec sp_trace_setevent @traceidout,180,8,@on --Audit Database Object Access Event,HostName
  exec sp_trace_setevent @traceidout,180,64,@on --Audit Database Object Access Event,SessionLoginName
  exec sp_trace_setevent @traceidout,180,40,@on --Audit Database Object Access Event,DBUserName
  exec sp_trace_setevent @traceidout,180,41,@on --Audit Database Object Access Event,LoginSid
  exec sp_trace_setevent @traceidout,180,49,@on --Audit Database Object Access Event,RequestID
  exec sp_trace_setevent @traceidout,180,50,@on --Audit Database Object Access Event,XactSequence
  exec sp_trace_setevent @traceidout,180,51,@on --Audit Database Object Access Event,EventSequence
  exec sp_trace_setevent @traceidout,180,60,@on --Audit Database Object Access Event,IsSystem
  exec sp_trace_setevent @traceidout,180,26,@on --Audit Database Object Access Event,ServerName
  exec sp_trace_setevent @traceidout,180,28,@on --Audit Database Object Access Event,ObjectType
  exec sp_trace_setevent @traceidout,180,29,@on --Audit Database Object Access Event,NestLevel
  exec sp_trace_setevent @traceidout,180,34,@on --Audit Database Object Access Event,ObjectName
  exec sp_trace_setevent @traceidout,180,35,@on --Audit Database Object Access Event,DatabaseName
  exec sp_trace_setevent @traceidout,180,37,@on --Audit Database Object Access Event,OwnerName
  exec sp_trace_setevent @traceidout,180,10,@on --Audit Database Object Access Event,ApplicationName
  exec sp_trace_setevent @traceidout,180,11,@on --Audit Database Object Access Event,LoginName
  exec sp_trace_setevent @traceidout,180,12,@on --Audit Database Object Access Event,SPID
  exec sp_trace_setevent @traceidout,180,14,@on --Audit Database Object Access Event,StartTime
  exec sp_trace_setevent @traceidout,180,19,@on --Audit Database Object Access Event,Permissions
  exec sp_trace_setevent @traceidout,180,23,@on --Audit Database Object Access Event,Success
--filters

---final step

--turn on the trace 
  exec sp_trace_setstatus @traceidout, 1 ---start trace   
  --exec sp_trace_setstatus TRACEID, 0 ---stop trace, you must know the traceid to stop it   
  --exec sp_trace_setstatus TRACEID, 2 ---close trace you must know the traceid to delete it