USE [master] GO /****** Object: StoredProcedure [dbo].[sp_AddMyTrace] Script Date: 07/25/2011 10:17:16 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER procedure [dbo].[sp_AddMyLogonTrace] AS BEGIN SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN declare @sql varchar(1000) declare @path nvarchar(256) declare @traceidout int declare @maxfilesize bigint declare @maxRolloverFiles int declare @on bit set @on = 1 set @maxRolloverFiles = 2 set @maxfilesize = 50 --meg --we want the current trace folder --ie c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG SELECT @path = REVERSE(SUBSTRING(REVERSE(path),CHARINDEX('\',REVERSE(path)),256)) FROM sys.traces WHERE is_default = 1 SET @path = @path + N'MyLogonTrace' --system appends .trc automatically for the filename IF EXISTS(SELECT * FROM sys.traces WHERE [path] = @path + '.trc') BEGIN --if it exists, turn it off and try to drop it SELECT @traceidout = id FROM sys.traces WHERE [path] = @path +'.trc' exec sp_trace_setstatus @traceidout, 0 ---stop trace, you must know the traceid to stop it exec sp_trace_setstatus @traceidout, 2 ---close trace you must know the traceid to delete it --the above does not delete the actual trace files... --note the double quotes to allow spaces in file path SET @sql = 'DEL "' + @path + '*.trc"' --other files like sp_DMLTrace.trc,sp_DMLTrace_1.trc,sp_DMLTrace_2.trc may exist as the logs roll over print @sql EXEC master..xp_cmdshell @sql IF EXISTS(select * from sysobjects where xtype='V' and name='sp_LogonTrace') BEGIN SET @sql = 'DROP VIEW sp_LogonTrace ' exec(@sql) END SELECT 'Trace Stopped And Dropped, Files Deleted, View sp_LogonTrace Dropped As Well' END --IF Exists the trace ELSE BEGIN --does not exist, add it! --create the trace exec sp_trace_create @traceidout output, @maxRolloverFiles, @path, @maxfilesize, NULL --for the Event Every SQL statement completed, capture all 64 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,4, @on --Audit Login,TransactionID EXEC sp_trace_setevent @traceidout, 14,5, @on --Audit Login,LineNumber 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,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,13, @on --Audit Login,Duration EXEC sp_trace_setevent @traceidout, 14,14, @on --Audit Login,StartTime EXEC sp_trace_setevent @traceidout, 14,15, @on --Audit Login,EndTime EXEC sp_trace_setevent @traceidout, 14,16, @on --Audit Login,Reads EXEC sp_trace_setevent @traceidout, 14,17, @on --Audit Login,Writes EXEC sp_trace_setevent @traceidout, 14,18, @on --Audit Login,CPU EXEC sp_trace_setevent @traceidout, 14,19, @on --Audit Login,Permissions EXEC sp_trace_setevent @traceidout, 14,20, @on --Audit Login,Severity EXEC sp_trace_setevent @traceidout, 14,21, @on --Audit Login,EventSubClass EXEC sp_trace_setevent @traceidout, 14,22, @on --Audit Login,ObjectID EXEC sp_trace_setevent @traceidout, 14,23, @on --Audit Login,Success EXEC sp_trace_setevent @traceidout, 14,24, @on --Audit Login,IndexID 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,27, @on --Audit Login,EventClass EXEC sp_trace_setevent @traceidout, 14,28, @on --Audit Login,ObjectType EXEC sp_trace_setevent @traceidout, 14,29, @on --Audit Login,NestLevel EXEC sp_trace_setevent @traceidout, 14,30, @on --Audit Login,State EXEC sp_trace_setevent @traceidout, 14,31, @on --Audit Login,Error EXEC sp_trace_setevent @traceidout, 14,32, @on --Audit Login,Mode EXEC sp_trace_setevent @traceidout, 14,33, @on --Audit Login,Handle EXEC sp_trace_setevent @traceidout, 14,34, @on --Audit Login,ObjectName EXEC sp_trace_setevent @traceidout, 14,35, @on --Audit Login,DatabaseName EXEC sp_trace_setevent @traceidout, 14,36, @on --Audit Login,FileName EXEC sp_trace_setevent @traceidout, 14,37, @on --Audit Login,OwnerName EXEC sp_trace_setevent @traceidout, 14,38, @on --Audit Login,RoleName EXEC sp_trace_setevent @traceidout, 14,39, @on --Audit Login,TargetUserName EXEC sp_trace_setevent @traceidout, 14,40, @on --Audit Login,DBUserName EXEC sp_trace_setevent @traceidout, 14,41, @on --Audit Login,LoginSid EXEC sp_trace_setevent @traceidout, 14,42, @on --Audit Login,TargetLoginName EXEC sp_trace_setevent @traceidout, 14,43, @on --Audit Login,TargetLoginSid EXEC sp_trace_setevent @traceidout, 14,44, @on --Audit Login,ColumnPermissions EXEC sp_trace_setevent @traceidout, 14,45, @on --Audit Login,LinkedServerName EXEC sp_trace_setevent @traceidout, 14,46, @on --Audit Login,ProviderName EXEC sp_trace_setevent @traceidout, 14,47, @on --Audit Login,MethodName EXEC sp_trace_setevent @traceidout, 14,48, @on --Audit Login,RowCounts EXEC sp_trace_setevent @traceidout, 14,49, @on --Audit Login,RequestID EXEC sp_trace_setevent @traceidout, 14,50, @on --Audit Login,XactSequence EXEC sp_trace_setevent @traceidout, 14,51, @on --Audit Login,EventSequence EXEC sp_trace_setevent @traceidout, 14,52, @on --Audit Login,BigintData1 EXEC sp_trace_setevent @traceidout, 14,53, @on --Audit Login,BigintData2 EXEC sp_trace_setevent @traceidout, 14,54, @on --Audit Login,GUID EXEC sp_trace_setevent @traceidout, 14,55, @on --Audit Login,IntegerData2 EXEC sp_trace_setevent @traceidout, 14,56, @on --Audit Login,ObjectID2 EXEC sp_trace_setevent @traceidout, 14,57, @on --Audit Login,Type EXEC sp_trace_setevent @traceidout, 14,58, @on --Audit Login,OwnerID EXEC sp_trace_setevent @traceidout, 14,59, @on --Audit Login,ParentName EXEC sp_trace_setevent @traceidout, 14,60, @on --Audit Login,IsSystem EXEC sp_trace_setevent @traceidout, 14,61, @on --Audit Login,Offset EXEC sp_trace_setevent @traceidout, 14,62, @on --Audit Login,SourceDatabaseID EXEC sp_trace_setevent @traceidout, 14,63, @on --Audit Login,SqlHandle EXEC sp_trace_setevent @traceidout, 14,64, @on --Audit Login,SessionLoginName EXEC sp_trace_setevent @traceidout, 15,1, @on --Audit Logout,TextData EXEC sp_trace_setevent @traceidout, 15,2, @on --Audit Logout,BinaryData EXEC sp_trace_setevent @traceidout, 15,3, @on --Audit Logout,DatabaseID EXEC sp_trace_setevent @traceidout, 15,4, @on --Audit Logout,TransactionID EXEC sp_trace_setevent @traceidout, 15,5, @on --Audit Logout,LineNumber 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,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, 15,17, @on --Audit Logout,Writes EXEC sp_trace_setevent @traceidout, 15,18, @on --Audit Logout,CPU EXEC sp_trace_setevent @traceidout, 15,19, @on --Audit Logout,Permissions EXEC sp_trace_setevent @traceidout, 15,20, @on --Audit Logout,Severity EXEC sp_trace_setevent @traceidout, 15,21, @on --Audit Logout,EventSubClass EXEC sp_trace_setevent @traceidout, 15,22, @on --Audit Logout,ObjectID EXEC sp_trace_setevent @traceidout, 15,23, @on --Audit Logout,Success EXEC sp_trace_setevent @traceidout, 15,24, @on --Audit Logout,IndexID EXEC sp_trace_setevent @traceidout, 15,25, @on --Audit Logout,IntegerData EXEC sp_trace_setevent @traceidout, 15,26, @on --Audit Logout,ServerName EXEC sp_trace_setevent @traceidout, 15,27, @on --Audit Logout,EventClass EXEC sp_trace_setevent @traceidout, 15,28, @on --Audit Logout,ObjectType EXEC sp_trace_setevent @traceidout, 15,29, @on --Audit Logout,NestLevel EXEC sp_trace_setevent @traceidout, 15,30, @on --Audit Logout,State EXEC sp_trace_setevent @traceidout, 15,31, @on --Audit Logout,Error EXEC sp_trace_setevent @traceidout, 15,32, @on --Audit Logout,Mode EXEC sp_trace_setevent @traceidout, 15,33, @on --Audit Logout,Handle EXEC sp_trace_setevent @traceidout, 15,34, @on --Audit Logout,ObjectName EXEC sp_trace_setevent @traceidout, 15,35, @on --Audit Logout,DatabaseName EXEC sp_trace_setevent @traceidout, 15,36, @on --Audit Logout,FileName EXEC sp_trace_setevent @traceidout, 15,37, @on --Audit Logout,OwnerName EXEC sp_trace_setevent @traceidout, 15,38, @on --Audit Logout,RoleName EXEC sp_trace_setevent @traceidout, 15,39, @on --Audit Logout,TargetUserName EXEC sp_trace_setevent @traceidout, 15,40, @on --Audit Logout,DBUserName EXEC sp_trace_setevent @traceidout, 15,41, @on --Audit Logout,LoginSid EXEC sp_trace_setevent @traceidout, 15,42, @on --Audit Logout,TargetLoginName EXEC sp_trace_setevent @traceidout, 15,43, @on --Audit Logout,TargetLoginSid EXEC sp_trace_setevent @traceidout, 15,44, @on --Audit Logout,ColumnPermissions EXEC sp_trace_setevent @traceidout, 15,45, @on --Audit Logout,LinkedServerName EXEC sp_trace_setevent @traceidout, 15,46, @on --Audit Logout,ProviderName EXEC sp_trace_setevent @traceidout, 15,47, @on --Audit Logout,MethodName EXEC sp_trace_setevent @traceidout, 15,48, @on --Audit Logout,RowCounts EXEC sp_trace_setevent @traceidout, 15,49, @on --Audit Logout,RequestID EXEC sp_trace_setevent @traceidout, 15,50, @on --Audit Logout,XactSequence EXEC sp_trace_setevent @traceidout, 15,51, @on --Audit Logout,EventSequence EXEC sp_trace_setevent @traceidout, 15,52, @on --Audit Logout,BigintData1 EXEC sp_trace_setevent @traceidout, 15,53, @on --Audit Logout,BigintData2 EXEC sp_trace_setevent @traceidout, 15,54, @on --Audit Logout,GUID EXEC sp_trace_setevent @traceidout, 15,55, @on --Audit Logout,IntegerData2 EXEC sp_trace_setevent @traceidout, 15,56, @on --Audit Logout,ObjectID2 EXEC sp_trace_setevent @traceidout, 15,57, @on --Audit Logout,Type EXEC sp_trace_setevent @traceidout, 15,58, @on --Audit Logout,OwnerID EXEC sp_trace_setevent @traceidout, 15,59, @on --Audit Logout,ParentName EXEC sp_trace_setevent @traceidout, 15,60, @on --Audit Logout,IsSystem EXEC sp_trace_setevent @traceidout, 15,61, @on --Audit Logout,Offset EXEC sp_trace_setevent @traceidout, 15,62, @on --Audit Logout,SourceDatabaseID EXEC sp_trace_setevent @traceidout, 15,63, @on --Audit Logout,SqlHandle EXEC sp_trace_setevent @traceidout, 15,64, @on --Audit Logout,SessionLoginName EXEC sp_trace_setevent @traceidout, 86,1, @on --UserConfigurable:4,TextData EXEC sp_trace_setevent @traceidout, 86,2, @on --UserConfigurable:4,BinaryData EXEC sp_trace_setevent @traceidout, 86,3, @on --UserConfigurable:4,DatabaseID EXEC sp_trace_setevent @traceidout, 86,4, @on --UserConfigurable:4,TransactionID EXEC sp_trace_setevent @traceidout, 86,5, @on --UserConfigurable:4,LineNumber EXEC sp_trace_setevent @traceidout, 86,6, @on --UserConfigurable:4,NTUserName EXEC sp_trace_setevent @traceidout, 86,7, @on --UserConfigurable:4,NTDomainName EXEC sp_trace_setevent @traceidout, 86,8, @on --UserConfigurable:4,HostName EXEC sp_trace_setevent @traceidout, 86,9, @on --UserConfigurable:4,ClientProcessID EXEC sp_trace_setevent @traceidout, 86,10, @on --UserConfigurable:4,ApplicationName EXEC sp_trace_setevent @traceidout, 86,11, @on --UserConfigurable:4,LoginName EXEC sp_trace_setevent @traceidout, 86,12, @on --UserConfigurable:4,SPID EXEC sp_trace_setevent @traceidout, 86,13, @on --UserConfigurable:4,Duration EXEC sp_trace_setevent @traceidout, 86,14, @on --UserConfigurable:4,StartTime EXEC sp_trace_setevent @traceidout, 86,15, @on --UserConfigurable:4,EndTime EXEC sp_trace_setevent @traceidout, 86,16, @on --UserConfigurable:4,Reads EXEC sp_trace_setevent @traceidout, 86,17, @on --UserConfigurable:4,Writes EXEC sp_trace_setevent @traceidout, 86,18, @on --UserConfigurable:4,CPU EXEC sp_trace_setevent @traceidout, 86,19, @on --UserConfigurable:4,Permissions EXEC sp_trace_setevent @traceidout, 86,20, @on --UserConfigurable:4,Severity EXEC sp_trace_setevent @traceidout, 86,21, @on --UserConfigurable:4,EventSubClass EXEC sp_trace_setevent @traceidout, 86,22, @on --UserConfigurable:4,ObjectID EXEC sp_trace_setevent @traceidout, 86,23, @on --UserConfigurable:4,Success EXEC sp_trace_setevent @traceidout, 86,24, @on --UserConfigurable:4,IndexID EXEC sp_trace_setevent @traceidout, 86,25, @on --UserConfigurable:4,IntegerData EXEC sp_trace_setevent @traceidout, 86,26, @on --UserConfigurable:4,ServerName EXEC sp_trace_setevent @traceidout, 86,27, @on --UserConfigurable:4,EventClass EXEC sp_trace_setevent @traceidout, 86,28, @on --UserConfigurable:4,ObjectType EXEC sp_trace_setevent @traceidout, 86,29, @on --UserConfigurable:4,NestLevel EXEC sp_trace_setevent @traceidout, 86,30, @on --UserConfigurable:4,State EXEC sp_trace_setevent @traceidout, 86,31, @on --UserConfigurable:4,Error EXEC sp_trace_setevent @traceidout, 86,32, @on --UserConfigurable:4,Mode EXEC sp_trace_setevent @traceidout, 86,33, @on --UserConfigurable:4,Handle EXEC sp_trace_setevent @traceidout, 86,34, @on --UserConfigurable:4,ObjectName EXEC sp_trace_setevent @traceidout, 86,35, @on --UserConfigurable:4,DatabaseName EXEC sp_trace_setevent @traceidout, 86,36, @on --UserConfigurable:4,FileName EXEC sp_trace_setevent @traceidout, 86,37, @on --UserConfigurable:4,OwnerName EXEC sp_trace_setevent @traceidout, 86,38, @on --UserConfigurable:4,RoleName EXEC sp_trace_setevent @traceidout, 86,39, @on --UserConfigurable:4,TargetUserName EXEC sp_trace_setevent @traceidout, 86,40, @on --UserConfigurable:4,DBUserName EXEC sp_trace_setevent @traceidout, 86,41, @on --UserConfigurable:4,LoginSid EXEC sp_trace_setevent @traceidout, 86,42, @on --UserConfigurable:4,TargetLoginName EXEC sp_trace_setevent @traceidout, 86,43, @on --UserConfigurable:4,TargetLoginSid EXEC sp_trace_setevent @traceidout, 86,44, @on --UserConfigurable:4,ColumnPermissions EXEC sp_trace_setevent @traceidout, 86,45, @on --UserConfigurable:4,LinkedServerName EXEC sp_trace_setevent @traceidout, 86,46, @on --UserConfigurable:4,ProviderName EXEC sp_trace_setevent @traceidout, 86,47, @on --UserConfigurable:4,MethodName EXEC sp_trace_setevent @traceidout, 86,48, @on --UserConfigurable:4,RowCounts EXEC sp_trace_setevent @traceidout, 86,49, @on --UserConfigurable:4,RequestID EXEC sp_trace_setevent @traceidout, 86,50, @on --UserConfigurable:4,XactSequence EXEC sp_trace_setevent @traceidout, 86,51, @on --UserConfigurable:4,EventSequence EXEC sp_trace_setevent @traceidout, 86,52, @on --UserConfigurable:4,BigintData1 EXEC sp_trace_setevent @traceidout, 86,53, @on --UserConfigurable:4,BigintData2 EXEC sp_trace_setevent @traceidout, 86,54, @on --UserConfigurable:4,GUID EXEC sp_trace_setevent @traceidout, 86,55, @on --UserConfigurable:4,IntegerData2 EXEC sp_trace_setevent @traceidout, 86,56, @on --UserConfigurable:4,ObjectID2 EXEC sp_trace_setevent @traceidout, 86,57, @on --UserConfigurable:4,Type EXEC sp_trace_setevent @traceidout, 86,58, @on --UserConfigurable:4,OwnerID EXEC sp_trace_setevent @traceidout, 86,59, @on --UserConfigurable:4,ParentName EXEC sp_trace_setevent @traceidout, 86,60, @on --UserConfigurable:4,IsSystem EXEC sp_trace_setevent @traceidout, 86,61, @on --UserConfigurable:4,Offset EXEC sp_trace_setevent @traceidout, 86,62, @on --UserConfigurable:4,SourceDatabaseID EXEC sp_trace_setevent @traceidout, 86,63, @on --UserConfigurable:4,SqlHandle EXEC sp_trace_setevent @traceidout, 86,64, @on --UserConfigurable:4,SessionLoginName EXEC sp_trace_setevent @traceidout, 103,1, @on --Audit Schema Object GDR Event,TextData EXEC sp_trace_setevent @traceidout, 103,2, @on --Audit Schema Object GDR Event,BinaryData 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,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,13, @on --Audit Schema Object GDR Event,Duration EXEC sp_trace_setevent @traceidout, 103,14, @on --Audit Schema Object GDR Event,StartTime EXEC sp_trace_setevent @traceidout, 103,15, @on --Audit Schema Object GDR Event,EndTime EXEC sp_trace_setevent @traceidout, 103,16, @on --Audit Schema Object GDR Event,Reads EXEC sp_trace_setevent @traceidout, 103,17, @on --Audit Schema Object GDR Event,Writes EXEC sp_trace_setevent @traceidout, 103,18, @on --Audit Schema Object GDR Event,CPU EXEC sp_trace_setevent @traceidout, 103,19, @on --Audit Schema Object GDR Event,Permissions EXEC sp_trace_setevent @traceidout, 103,20, @on --Audit Schema Object GDR Event,Severity EXEC sp_trace_setevent @traceidout, 103,21, @on --Audit Schema Object GDR Event,EventSubClass EXEC sp_trace_setevent @traceidout, 103,22, @on --Audit Schema Object GDR Event,ObjectID EXEC sp_trace_setevent @traceidout, 103,23, @on --Audit Schema Object GDR Event,Success EXEC sp_trace_setevent @traceidout, 103,24, @on --Audit Schema Object GDR Event,IndexID EXEC sp_trace_setevent @traceidout, 103,25, @on --Audit Schema Object GDR Event,IntegerData EXEC sp_trace_setevent @traceidout, 103,26, @on --Audit Schema Object GDR Event,ServerName EXEC sp_trace_setevent @traceidout, 103,27, @on --Audit Schema Object GDR Event,EventClass 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,30, @on --Audit Schema Object GDR Event,State EXEC sp_trace_setevent @traceidout, 103,31, @on --Audit Schema Object GDR Event,Error EXEC sp_trace_setevent @traceidout, 103,32, @on --Audit Schema Object GDR Event,Mode EXEC sp_trace_setevent @traceidout, 103,33, @on --Audit Schema Object GDR Event,Handle 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,36, @on --Audit Schema Object GDR Event,FileName EXEC sp_trace_setevent @traceidout, 103,37, @on --Audit Schema Object GDR Event,OwnerName EXEC sp_trace_setevent @traceidout, 103,38, @on --Audit Schema Object GDR Event,RoleName 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,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,45, @on --Audit Schema Object GDR Event,LinkedServerName EXEC sp_trace_setevent @traceidout, 103,46, @on --Audit Schema Object GDR Event,ProviderName EXEC sp_trace_setevent @traceidout, 103,47, @on --Audit Schema Object GDR Event,MethodName EXEC sp_trace_setevent @traceidout, 103,48, @on --Audit Schema Object GDR Event,RowCounts 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,52, @on --Audit Schema Object GDR Event,BigintData1 EXEC sp_trace_setevent @traceidout, 103,53, @on --Audit Schema Object GDR Event,BigintData2 EXEC sp_trace_setevent @traceidout, 103,54, @on --Audit Schema Object GDR Event,GUID EXEC sp_trace_setevent @traceidout, 103,55, @on --Audit Schema Object GDR Event,IntegerData2 EXEC sp_trace_setevent @traceidout, 103,56, @on --Audit Schema Object GDR Event,ObjectID2 EXEC sp_trace_setevent @traceidout, 103,57, @on --Audit Schema Object GDR Event,Type EXEC sp_trace_setevent @traceidout, 103,58, @on --Audit Schema Object GDR Event,OwnerID 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,61, @on --Audit Schema Object GDR Event,Offset EXEC sp_trace_setevent @traceidout, 103,62, @on --Audit Schema Object GDR Event,SourceDatabaseID EXEC sp_trace_setevent @traceidout, 103,63, @on --Audit Schema Object GDR Event,SqlHandle EXEC sp_trace_setevent @traceidout, 103,64, @on --Audit Schema Object GDR Event,SessionLoginName EXEC sp_trace_setevent @traceidout, 104,1, @on --Audit Addlogin Event,TextData EXEC sp_trace_setevent @traceidout, 104,2, @on --Audit Addlogin Event,BinaryData 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,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,13, @on --Audit Addlogin Event,Duration EXEC sp_trace_setevent @traceidout, 104,14, @on --Audit Addlogin Event,StartTime EXEC sp_trace_setevent @traceidout, 104,15, @on --Audit Addlogin Event,EndTime EXEC sp_trace_setevent @traceidout, 104,16, @on --Audit Addlogin Event,Reads EXEC sp_trace_setevent @traceidout, 104,17, @on --Audit Addlogin Event,Writes EXEC sp_trace_setevent @traceidout, 104,18, @on --Audit Addlogin Event,CPU EXEC sp_trace_setevent @traceidout, 104,19, @on --Audit Addlogin Event,Permissions EXEC sp_trace_setevent @traceidout, 104,20, @on --Audit Addlogin Event,Severity EXEC sp_trace_setevent @traceidout, 104,21, @on --Audit Addlogin Event,EventSubClass EXEC sp_trace_setevent @traceidout, 104,22, @on --Audit Addlogin Event,ObjectID EXEC sp_trace_setevent @traceidout, 104,23, @on --Audit Addlogin Event,Success EXEC sp_trace_setevent @traceidout, 104,24, @on --Audit Addlogin Event,IndexID EXEC sp_trace_setevent @traceidout, 104,25, @on --Audit Addlogin Event,IntegerData EXEC sp_trace_setevent @traceidout, 104,26, @on --Audit Addlogin Event,ServerName EXEC sp_trace_setevent @traceidout, 104,27, @on --Audit Addlogin Event,EventClass EXEC sp_trace_setevent @traceidout, 104,28, @on --Audit Addlogin Event,ObjectType EXEC sp_trace_setevent @traceidout, 104,29, @on --Audit Addlogin Event,NestLevel EXEC sp_trace_setevent @traceidout, 104,30, @on --Audit Addlogin Event,State EXEC sp_trace_setevent @traceidout, 104,31, @on --Audit Addlogin Event,Error EXEC sp_trace_setevent @traceidout, 104,32, @on --Audit Addlogin Event,Mode EXEC sp_trace_setevent @traceidout, 104,33, @on --Audit Addlogin Event,Handle EXEC sp_trace_setevent @traceidout, 104,34, @on --Audit Addlogin Event,ObjectName EXEC sp_trace_setevent @traceidout, 104,35, @on --Audit Addlogin Event,DatabaseName EXEC sp_trace_setevent @traceidout, 104,36, @on --Audit Addlogin Event,FileName EXEC sp_trace_setevent @traceidout, 104,37, @on --Audit Addlogin Event,OwnerName EXEC sp_trace_setevent @traceidout, 104,38, @on --Audit Addlogin Event,RoleName EXEC sp_trace_setevent @traceidout, 104,39, @on --Audit Addlogin Event,TargetUserName 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,42, @on --Audit Addlogin Event,TargetLoginName EXEC sp_trace_setevent @traceidout, 104,43, @on --Audit Addlogin Event,TargetLoginSid EXEC sp_trace_setevent @traceidout, 104,44, @on --Audit Addlogin Event,ColumnPermissions EXEC sp_trace_setevent @traceidout, 104,45, @on --Audit Addlogin Event,LinkedServerName EXEC sp_trace_setevent @traceidout, 104,46, @on --Audit Addlogin Event,ProviderName EXEC sp_trace_setevent @traceidout, 104,47, @on --Audit Addlogin Event,MethodName EXEC sp_trace_setevent @traceidout, 104,48, @on --Audit Addlogin Event,RowCounts 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,52, @on --Audit Addlogin Event,BigintData1 EXEC sp_trace_setevent @traceidout, 104,53, @on --Audit Addlogin Event,BigintData2 EXEC sp_trace_setevent @traceidout, 104,54, @on --Audit Addlogin Event,GUID EXEC sp_trace_setevent @traceidout, 104,55, @on --Audit Addlogin Event,IntegerData2 EXEC sp_trace_setevent @traceidout, 104,56, @on --Audit Addlogin Event,ObjectID2 EXEC sp_trace_setevent @traceidout, 104,57, @on --Audit Addlogin Event,Type EXEC sp_trace_setevent @traceidout, 104,58, @on --Audit Addlogin Event,OwnerID EXEC sp_trace_setevent @traceidout, 104,59, @on --Audit Addlogin Event,ParentName EXEC sp_trace_setevent @traceidout, 104,60, @on --Audit Addlogin Event,IsSystem EXEC sp_trace_setevent @traceidout, 104,61, @on --Audit Addlogin Event,Offset EXEC sp_trace_setevent @traceidout, 104,62, @on --Audit Addlogin Event,SourceDatabaseID EXEC sp_trace_setevent @traceidout, 104,63, @on --Audit Addlogin Event,SqlHandle EXEC sp_trace_setevent @traceidout, 104,64, @on --Audit Addlogin Event,SessionLoginName EXEC sp_trace_setevent @traceidout, 105,1, @on --Audit Login GDR Event,TextData EXEC sp_trace_setevent @traceidout, 105,2, @on --Audit Login GDR Event,BinaryData 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,5, @on --Audit Login GDR Event,LineNumber 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,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,13, @on --Audit Login GDR Event,Duration EXEC sp_trace_setevent @traceidout, 105,14, @on --Audit Login GDR Event,StartTime EXEC sp_trace_setevent @traceidout, 105,15, @on --Audit Login GDR Event,EndTime EXEC sp_trace_setevent @traceidout, 105,16, @on --Audit Login GDR Event,Reads EXEC sp_trace_setevent @traceidout, 105,17, @on --Audit Login GDR Event,Writes EXEC sp_trace_setevent @traceidout, 105,18, @on --Audit Login GDR Event,CPU EXEC sp_trace_setevent @traceidout, 105,19, @on --Audit Login GDR Event,Permissions EXEC sp_trace_setevent @traceidout, 105,20, @on --Audit Login GDR Event,Severity EXEC sp_trace_setevent @traceidout, 105,21, @on --Audit Login GDR Event,EventSubClass EXEC sp_trace_setevent @traceidout, 105,22, @on --Audit Login GDR Event,ObjectID EXEC sp_trace_setevent @traceidout, 105,23, @on --Audit Login GDR Event,Success EXEC sp_trace_setevent @traceidout, 105,24, @on --Audit Login GDR Event,IndexID EXEC sp_trace_setevent @traceidout, 105,25, @on --Audit Login GDR Event,IntegerData EXEC sp_trace_setevent @traceidout, 105,26, @on --Audit Login GDR Event,ServerName EXEC sp_trace_setevent @traceidout, 105,27, @on --Audit Login GDR Event,EventClass EXEC sp_trace_setevent @traceidout, 105,28, @on --Audit Login GDR Event,ObjectType EXEC sp_trace_setevent @traceidout, 105,29, @on --Audit Login GDR Event,NestLevel EXEC sp_trace_setevent @traceidout, 105,30, @on --Audit Login GDR Event,State EXEC sp_trace_setevent @traceidout, 105,31, @on --Audit Login GDR Event,Error EXEC sp_trace_setevent @traceidout, 105,32, @on --Audit Login GDR Event,Mode EXEC sp_trace_setevent @traceidout, 105,33, @on --Audit Login GDR Event,Handle EXEC sp_trace_setevent @traceidout, 105,34, @on --Audit Login GDR Event,ObjectName EXEC sp_trace_setevent @traceidout, 105,35, @on --Audit Login GDR Event,DatabaseName EXEC sp_trace_setevent @traceidout, 105,36, @on --Audit Login GDR Event,FileName EXEC sp_trace_setevent @traceidout, 105,37, @on --Audit Login GDR Event,OwnerName EXEC sp_trace_setevent @traceidout, 105,38, @on --Audit Login GDR Event,RoleName EXEC sp_trace_setevent @traceidout, 105,39, @on --Audit Login GDR Event,TargetUserName 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,43, @on --Audit Login GDR Event,TargetLoginSid EXEC sp_trace_setevent @traceidout, 105,44, @on --Audit Login GDR Event,ColumnPermissions EXEC sp_trace_setevent @traceidout, 105,45, @on --Audit Login GDR Event,LinkedServerName EXEC sp_trace_setevent @traceidout, 105,46, @on --Audit Login GDR Event,ProviderName EXEC sp_trace_setevent @traceidout, 105,47, @on --Audit Login GDR Event,,MethodName EXEC sp_trace_setevent @traceidout, 105,48, @on --Audit Login GDR Event,RowCounts 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,52, @on --Audit Login GDR Event,BigintData1 EXEC sp_trace_setevent @traceidout, 105,53, @on --Audit Login GDR Event,BigintData2 EXEC sp_trace_setevent @traceidout, 105,54, @on --Audit Login GDR Event,GUID EXEC sp_trace_setevent @traceidout, 105,55, @on --Audit Login GDR Event,IntegerData2 EXEC sp_trace_setevent @traceidout, 105,56, @on --Audit Login GDR Event,ObjectID2 EXEC sp_trace_setevent @traceidout, 105,57, @on --Audit Login GDR Event,Type EXEC sp_trace_setevent @traceidout, 105,58, @on --Audit Login GDR Event,OwnerID EXEC sp_trace_setevent @traceidout, 105,59, @on --Audit Login GDR Event,ParentName EXEC sp_trace_setevent @traceidout, 105,60, @on --Audit Login GDR Event,IsSystem EXEC sp_trace_setevent @traceidout, 105,61, @on --Audit Login GDR Event,Offset EXEC sp_trace_setevent @traceidout, 105,62, @on --Audit Login GDR Event,SourceDatabaseID EXEC sp_trace_setevent @traceidout, 105,63, @on --Audit Login GDR Event,SqlHandle EXEC sp_trace_setevent @traceidout, 105,64, @on --Audit Login GDR Event,SessionLoginName EXEC sp_trace_setevent @traceidout, 106,1, @on --Audit Login Change Property Event,TextData EXEC sp_trace_setevent @traceidout, 106,2, @on --Audit Login Change Property Event,BinaryData 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,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,13, @on --Audit Login Change Property Event,Duration EXEC sp_trace_setevent @traceidout, 106,14, @on --Audit Login Change Property Event,StartTime EXEC sp_trace_setevent @traceidout, 106,15, @on --Audit Login Change Property Event,EndTime EXEC sp_trace_setevent @traceidout, 106,16, @on --Audit Login Change Property Event,Reads EXEC sp_trace_setevent @traceidout, 106,17, @on --Audit Login Change Property Event,Writes EXEC sp_trace_setevent @traceidout, 106,18, @on --Audit Login Change Property Event,CPU EXEC sp_trace_setevent @traceidout, 106,19, @on --Audit Login Change Property Event,Permissions EXEC sp_trace_setevent @traceidout, 106,20, @on --Audit Login Change Property Event,Severity EXEC sp_trace_setevent @traceidout, 106,21, @on --Audit Login Change Property Event,EventSubClass EXEC sp_trace_setevent @traceidout, 106,22, @on --Audit Login Change Property Event,ObjectID EXEC sp_trace_setevent @traceidout, 106,23, @on --Audit Login Change Property Event,Success EXEC sp_trace_setevent @traceidout, 106,24, @on --Audit Login Change Property Event,IndexID EXEC sp_trace_setevent @traceidout, 106,25, @on --Audit Login Change Property Event,IntegerData EXEC sp_trace_setevent @traceidout, 106,26, @on --Audit Login Change Property Event,ServerName EXEC sp_trace_setevent @traceidout, 106,27, @on --Audit Login Change Property Event,EventClass 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,30, @on --Audit Login Change Property Event,State EXEC sp_trace_setevent @traceidout, 106,31, @on --Audit Login Change Property Event,Error EXEC sp_trace_setevent @traceidout, 106,32, @on --Audit Login Change Property Event,Mode EXEC sp_trace_setevent @traceidout, 106,33, @on --Audit Login Change Property Event,Handle EXEC sp_trace_setevent @traceidout, 106,34, @on --Audit Login Change Property Event,ObjectName EXEC sp_trace_setevent @traceidout, 106,35, @on --Audit Login Change Property Event,DatabaseName EXEC sp_trace_setevent @traceidout, 106,36, @on --Audit Login Change Property Event,FileName EXEC sp_trace_setevent @traceidout, 106,37, @on --Audit Login Change Property Event,OwnerName EXEC sp_trace_setevent @traceidout, 106,38, @on --Audit Login Change Property Event,RoleName EXEC sp_trace_setevent @traceidout, 106,39, @on --Audit Login Change Property Event,TargetUserName 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,44, @on --Audit Login Change Property Event,ColumnPermissions EXEC sp_trace_setevent @traceidout, 106,45, @on --Audit Login Change Property Event,LinkedServerName EXEC sp_trace_setevent @traceidout, 106,46, @on --Audit Login Change Property Event,ProviderName EXEC sp_trace_setevent @traceidout, 106,47, @on --Audit Login Change Property Event,MethodName EXEC sp_trace_setevent @traceidout, 106,48, @on --Audit Login Change Property Event,RowCounts 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,52, @on --Audit Login Change Property Event,BigintData1 EXEC sp_trace_setevent @traceidout, 106,53, @on --Audit Login Change Property Event,BigintData2 EXEC sp_trace_setevent @traceidout, 106,54, @on --Audit Login Change Property Event,GUID EXEC sp_trace_setevent @traceidout, 106,55, @on --Audit Login Change Property Event,IntegerData2 EXEC sp_trace_setevent @traceidout, 106,56, @on --Audit Login Change Property Event,ObjectID2 EXEC sp_trace_setevent @traceidout, 106,57, @on --Audit Login Change Property Event,Type EXEC sp_trace_setevent @traceidout, 106,58, @on --Audit Login Change Property Event,OwnerID EXEC sp_trace_setevent @traceidout, 106,59, @on --Audit Login Change Property Event,ParentName EXEC sp_trace_setevent @traceidout, 106,60, @on --Audit Login Change Property Event,IsSystem EXEC sp_trace_setevent @traceidout, 106,61, @on --Audit Login Change Property Event,Offset EXEC sp_trace_setevent @traceidout, 106,62, @on --Audit Login Change Property Event,SourceDatabaseID EXEC sp_trace_setevent @traceidout, 106,63, @on --Audit Login Change Property Event,SqlHandle EXEC sp_trace_setevent @traceidout, 106,64, @on --Audit Login Change Property Event,SessionLoginName EXEC sp_trace_setevent @traceidout, 108,1, @on --Audit Add Login to Server Role Event,TextData EXEC sp_trace_setevent @traceidout, 108,2, @on --Audit Add Login to Server Role Event,BinaryData 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,5, @on --Audit Add Login to Server Role Event,LineNumber 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,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,13, @on --Audit Add Login to Server Role Event,Duration EXEC sp_trace_setevent @traceidout, 108,14, @on --Audit Add Login to Server Role Event,StartTime EXEC sp_trace_setevent @traceidout, 108,15, @on --Audit Add Login to Server Role Event,EndTime EXEC sp_trace_setevent @traceidout, 108,16, @on --Audit Add Login to Server Role Event,Reads EXEC sp_trace_setevent @traceidout, 108,17, @on --Audit Add Login to Server Role Event,Writes EXEC sp_trace_setevent @traceidout, 108,18, @on --Audit Add Login to Server Role Event,CPU EXEC sp_trace_setevent @traceidout, 108,19, @on --Audit Add Login to Server Role Event,Permissions EXEC sp_trace_setevent @traceidout, 108,20, @on --Audit Add Login to Server Role Event,Severity EXEC sp_trace_setevent @traceidout, 108,21, @on --Audit Add Login to Server Role Event,EventSubClass EXEC sp_trace_setevent @traceidout, 108,22, @on --Audit Add Login to Server Role Event,ObjectID EXEC sp_trace_setevent @traceidout, 108,23, @on --Audit Add Login to Server Role Event,Success EXEC sp_trace_setevent @traceidout, 108,24, @on --Audit Add Login to Server Role Event,IndexID EXEC sp_trace_setevent @traceidout, 108,25, @on --Audit Add Login to Server Role Event,IntegerData EXEC sp_trace_setevent @traceidout, 108,26, @on --Audit Add Login to Server Role Event,ServerName EXEC sp_trace_setevent @traceidout, 108,27, @on --Audit Add Login to Server Role Event,EventClass 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,30, @on --Audit Add Login to Server Role Event,State EXEC sp_trace_setevent @traceidout, 108,31, @on --Audit Add Login to Server Role Event,Error EXEC sp_trace_setevent @traceidout, 108,32, @on --Audit Add Login to Server Role Event,Mode EXEC sp_trace_setevent @traceidout, 108,33, @on --Audit Add Login to Server Role Event,Handle 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,36, @on --Audit Add Login to Server Role Event,FileName 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,39, @on --Audit Add Login to Server Role Event,TargetUserName 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,44, @on --Audit Add Login to Server Role Event,ColumnPermissions EXEC sp_trace_setevent @traceidout, 108,45, @on --Audit Add Login to Server Role Event,LinkedServerName EXEC sp_trace_setevent @traceidout, 108,46, @on --Audit Add Login to Server Role Event,ProviderName EXEC sp_trace_setevent @traceidout, 108,47, @on --Audit Add Login to Server Role Event,MethodName EXEC sp_trace_setevent @traceidout, 108,48, @on --Audit Add Login to Server Role Event,RowCounts 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,52, @on --Audit Add Login to Server Role Event,BigintData1 EXEC sp_trace_setevent @traceidout, 108,53, @on --Audit Add Login to Server Role Event,BigintData2 EXEC sp_trace_setevent @traceidout, 108,54, @on --Audit Add Login to Server Role Event,GUID EXEC sp_trace_setevent @traceidout, 108,55, @on --Audit Add Login to Server Role Event,IntegerData2 EXEC sp_trace_setevent @traceidout, 108,56, @on --Audit Add Login to Server Role Event,ObjectID2 EXEC sp_trace_setevent @traceidout, 108,57, @on --Audit Add Login to Server Role Event,Type EXEC sp_trace_setevent @traceidout, 108,58, @on --Audit Add Login to Server Role Event,OwnerID EXEC sp_trace_setevent @traceidout, 108,59, @on --Audit Add Login to Server Role Event,ParentName EXEC sp_trace_setevent @traceidout, 108,60, @on --Audit Add Login to Server Role Event,IsSystem EXEC sp_trace_setevent @traceidout, 108,61, @on --Audit Add Login to Server Role Event,Offset EXEC sp_trace_setevent @traceidout, 108,62, @on --Audit Add Login to Server Role Event,SourceDatabaseID EXEC sp_trace_setevent @traceidout, 108,63, @on --Audit Add Login to Server Role Event,SqlHandle EXEC sp_trace_setevent @traceidout, 108,64, @on --Audit Add Login to Server Role Event,SessionLoginName EXEC sp_trace_setevent @traceidout, 109,1, @on --Audit Add DB User Event,TextData EXEC sp_trace_setevent @traceidout, 109,2, @on --Audit Add DB User Event,BinaryData 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,5, @on --Audit Add DB User Event,LineNumber 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,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,13, @on --Audit Add DB User Event,Duration EXEC sp_trace_setevent @traceidout, 109,14, @on --Audit Add DB User Event,StartTime EXEC sp_trace_setevent @traceidout, 109,15, @on --Audit Add DB User Event,EndTime EXEC sp_trace_setevent @traceidout, 109,16, @on --Audit Add DB User Event,Reads EXEC sp_trace_setevent @traceidout, 109,17, @on --Audit Add DB User Event,Writes EXEC sp_trace_setevent @traceidout, 109,18, @on --Audit Add DB User Event,CPU EXEC sp_trace_setevent @traceidout, 109,19, @on --Audit Add DB User Event,Permissions EXEC sp_trace_setevent @traceidout, 109,20, @on --Audit Add DB User Event,Severity EXEC sp_trace_setevent @traceidout, 109,21, @on --Audit Add DB User Event,EventSubClass EXEC sp_trace_setevent @traceidout, 109,22, @on --Audit Add DB User Event,ObjectID EXEC sp_trace_setevent @traceidout, 109,23, @on --Audit Add DB User Event,Success EXEC sp_trace_setevent @traceidout, 109,24, @on --Audit Add DB User Event,IndexID EXEC sp_trace_setevent @traceidout, 109,25, @on --Audit Add DB User Event,IntegerData EXEC sp_trace_setevent @traceidout, 109,26, @on --Audit Add DB User Event,ServerName EXEC sp_trace_setevent @traceidout, 109,27, @on --Audit Add DB User Event,EventClass 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,30, @on --Audit Add DB User Event,State EXEC sp_trace_setevent @traceidout, 109,31, @on --Audit Add DB User Event,Error EXEC sp_trace_setevent @traceidout, 109,32, @on --Audit Add DB User Event,Mode EXEC sp_trace_setevent @traceidout, 109,33, @on --Audit Add DB User Event,Handle EXEC sp_trace_setevent @traceidout, 109,34, @on --Audit Add DB User Event,ObjectName EXEC sp_trace_setevent @traceidout, 109,35, @on --Audit Add DB User Event,DatabaseName EXEC sp_trace_setevent @traceidout, 109,36, @on --Audit Add DB User Event,FileName 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,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,45, @on --Audit Add DB User Event,LinkedServerName EXEC sp_trace_setevent @traceidout, 109,46, @on --Audit Add DB User Evvent,ProviderName EXEC sp_trace_setevent @traceidout, 109,47, @on --Audit Add DB User Event,MethodName EXEC sp_trace_setevent @traceidout, 109,48, @on --Audit Add DB User Event,RowCounts 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,52, @on --Audit Add DB User Event,BigintData1 EXEC sp_trace_setevent @traceidout, 109,53, @on --Audit Add DB User Event,BigintData2 EXEC sp_trace_setevent @traceidout, 109,54, @on --Audit Add DB User Event,GUID EXEC sp_trace_setevent @traceidout, 109,55, @on --Audit Add DB User Event,IntegerData2 EXEC sp_trace_setevent @traceidout, 109,56, @on --Audit Add DB User Event,ObjectID2 EXEC sp_trace_setevent @traceidout, 109,57, @on --Audit Add DB User Event,Type EXEC sp_trace_setevent @traceidout, 109,58, @on --Audit Add DB User Event,OwnerID EXEC sp_trace_setevent @traceidout, 109,59, @on --Audit Add DB User Event,ParentName EXEC sp_trace_setevent @traceidout, 109,60, @on --Audit Add DB User Event,IsSystem EXEC sp_trace_setevent @traceidout, 109,61, @on --Audit Add DB User Event,Offset EXEC sp_trace_setevent @traceidout, 109,62, @on --Audit Add DB User Event,SourceDatabaseID EXEC sp_trace_setevent @traceidout, 109,63, @on --Audit Add DB User Event,SqlHandle EXEC sp_trace_setevent @traceidout, 109,64, @on --Audit Add DB User Event,SessionLoginName EXEC sp_trace_setevent @traceidout, 110,1, @on --Audit Add Member to DB Role Event,TextData EXEC sp_trace_setevent @traceidout, 110,2, @on --Audit Add Member to DB Role Event,BinaryData 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,5, @on --Audit Add Member to DB Role Event,LineNumber 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,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,13, @on --Audit Add Member to DB Role Event,Duration EXEC sp_trace_setevent @traceidout, 110,14, @on --Audit Add Member to DB Role Event,StartTime EXEC sp_trace_setevent @traceidout, 110,15, @on --Audit Add Member to DB Role Event,EndTime EXEC sp_trace_setevent @traceidout, 110,16, @on --Audit Add Member to DB Role Event,Reads EXEC sp_trace_setevent @traceidout, 110,17, @on --Audit Add Member to DB Role Event,Writes EXEC sp_trace_setevent @traceidout, 110,18, @on --Audit Add Member to DB Role Event,CPU EXEC sp_trace_setevent @traceidout, 110,19, @on --Audit Add Member to DB Role Event,Permissions EXEC sp_trace_setevent @traceidout, 110,20, @on --Audit Add Member to DB Role Event,Severity EXEC sp_trace_setevent @traceidout, 110,21, @on --Audit Add Member to DB Role Event,EventSubClass EXEC sp_trace_setevent @traceidout, 110,22, @on --Audit Add Member to DB Role Event,ObjectID EXEC sp_trace_setevent @traceidout, 110,23, @on --Audit Add Member to DB Role Event,Success EXEC sp_trace_setevent @traceidout, 110,24, @on --Audit Add Member to DB Role Event,IndexID EXEC sp_trace_setevent @traceidout, 110,25, @on --Audit Add Member to DB Role Event,IntegerData EXEC sp_trace_setevent @traceidout, 110,26, @on --Audit Add Member to DB Role Event,ServerName EXEC sp_trace_setevent @traceidout, 110,27, @on --Audit Add Member to DB Role Event,EventClass 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,30, @on --Audit Add Member to DB Role Event,State EXEC sp_trace_setevent @traceidout, 110,31, @on --Audit Add Member to DB Role Event,Error EXEC sp_trace_setevent @traceidout, 110,32, @on --Audit Add Member to DB Role Event,Mode EXEC sp_trace_setevent @traceidout, 110,33, @on --Audit Add Member to DB Role Event,Handle 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,36, @on --Audit Add Member to DB Role Event,FileName 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,43, @on --Audit Add Member to DB Role Event,TargetLoginSid EXEC sp_trace_setevent @traceidout, 110,44, @on --Audit Add Member to DB Role Event,ColumnPermissions EXEC sp_trace_setevent @traceidout, 110,45, @on --Audit Add Member to DB Role Event,LinkedServerName EXEC sp_trace_setevent @traceidout, 110,46, @on --Audit Add Member to DB Role Event,ProviderName EXEC sp_trace_setevent @traceidout, 110,47, @on --Audit Add Member to DB Role Event,MethodName EXEC sp_trace_setevent @traceidout, 110,48, @on --Audit Add Member to DB Role Event,RowCounts 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,52, @on --Audit Add Member to DB Role Event,BigintData1 EXEC sp_trace_setevent @traceidout, 110,53, @on --Audit Add Member to DB Role Event,BigintData2 EXEC sp_trace_setevent @traceidout, 110,54, @on --Audit Add Member to DB Role Event,GUID EXEC sp_trace_setevent @traceidout, 110,55, @on --Audit Add Member to DB Role Event,IntegerData2 EXEC sp_trace_setevent @traceidout, 110,56, @on --Audit Add Member to DB Role Event,ObjectID2 EXEC sp_trace_setevent @traceidout, 110,57, @on --Audit Add Member to DB Role Event,Type EXEC sp_trace_setevent @traceidout, 110,58, @on --Audit Add Member to DB Role Event,OwnerID EXEC sp_trace_setevent @traceidout, 110,59, @on --Audit Add Member to DB Role Event,ParentName EXEC sp_trace_setevent @traceidout, 110,60, @on --Audit Add Member to DB Role Event,IsSystem EXEC sp_trace_setevent @traceidout, 110,61, @on --Audit Add Member to DB Role Event,Offset EXEC sp_trace_setevent @traceidout, 110,62, @on --Audit Add Member to DB Role Event,SourceDatabaseID EXEC sp_trace_setevent @traceidout, 110,63, @on --Audit Add Member to DB Role Event,SqlHandle EXEC sp_trace_setevent @traceidout, 110,64, @on --Audit Add Member to DB Role Event,SessionLoginName EXEC sp_trace_setevent @traceidout, 111,1, @on --Audit Add Role Event,TextData EXEC sp_trace_setevent @traceidout, 111,2, @on --Audit Add Role Event,BinaryData 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,5, @on --Audit Add Role Event,LineNumber 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,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,13, @on --Audit Add Role Event,Duration EXEC sp_trace_setevent @traceidout, 111,14, @on --Audit Add Role Event,StartTime EXEC sp_trace_setevent @traceidout, 111,15, @on --Audit Add Role Event,EndTime EXEC sp_trace_setevent @traceidout, 111,16, @on --Audit Add Role Event,Reads EXEC sp_trace_setevent @traceidout, 111,17, @on --Audit Add Role Event,Writes EXEC sp_trace_setevent @traceidout, 111,18, @on --Audit Add Role Event,CPU EXEC sp_trace_setevent @traceidout, 111,19, @on --Audit Add Role Event,Permissions EXEC sp_trace_setevent @traceidout, 111,20, @on --Audit Add Role Event,Severity EXEC sp_trace_setevent @traceidout, 111,21, @on --Audit Add Role Event,EventSubClass EXEC sp_trace_setevent @traceidout, 111,22, @on --Audit Add Role Event,ObjectID EXEC sp_trace_setevent @traceidout, 111,23, @on --Audit Add Role Event,Success EXEC sp_trace_setevent @traceidout, 111,24, @on --Audit Add Role Event,IndexID EXEC sp_trace_setevent @traceidout, 111,25, @on --Audit Add Role Event,IntegerData EXEC sp_trace_setevent @traceidout, 111,26, @on --Audit Add Role Event,ServerName EXEC sp_trace_setevent @traceidout, 111,27, @on --Audit Add Role Event,EventClass 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,30, @on --Audit Add Role Event,State EXEC sp_trace_setevent @traceidout, 111,31, @on --Audit Add Role Event,Error EXEC sp_trace_setevent @traceidout, 111,32, @on --Audit Add Role Event,Mode EXEC sp_trace_setevent @traceidout, 111,33, @on --Audit Add Role Event,Handle EXEC sp_trace_setevent @traceidout, 111,34, @on --Audit Add Role Event,ObjectName EXEC sp_trace_setevent @traceidout, 111,35, @on --Audit Add Role Event,DatabaseName EXEC sp_trace_setevent @traceidout, 111,36, @on --Audit Add Role Event,FileName EXEC sp_trace_setevent @traceidout, 111,37, @on --Audit Add Role Event,OwnerName EXEC sp_trace_setevent @traceidout, 111,38, @on --Audit Add Role Event,RoleName EXEC sp_trace_setevent @traceidout, 111,39, @on --Audit Add Role Event,TargetUserName EXEC sp_trace_setevent @traceidout, 111,40, @on --Audit Add Role Event,DBUserName EXEC sp_trace_setevent @traceidout, 111,41, @on --Audit Add Role Event,LoginSid EXEC sp_trace_setevent @traceidout, 111,42, @on --Audit Add Role Event,TargetLoginName EXEC sp_trace_setevent @traceidout, 111,43, @on --Audit Add Role Event,TargetLoginSid EXEC sp_trace_setevent @traceidout, 111,44, @on --Audit Add Role Event,ColumnPermissions EXEC sp_trace_setevent @traceidout, 111,45, @on --Audit Add Role Event,LinkedServerName EXEC sp_trace_setevent @traceidout, 111,46, @on --Audit Add Role Event,ProviderName EXEC sp_trace_setevent @traceidout, 111,47, @on --Audit Add Role Event,MethodName EXEC sp_trace_setevent @traceidout, 111,48, @on --Audit Add Role Event,RowCounts 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,52, @on --Audit Add Role Event,BigintData1 EXEC sp_trace_setevent @traceidout, 111,53, @on --Audit Add Role Event,BigintData2 EXEC sp_trace_setevent @traceidout, 111,54, @on --Audit Add Role Event,GUID EXEC sp_trace_setevent @traceidout, 111,55, @on --Audit Add Role Event,IntegerData2 EXEC sp_trace_setevent @traceidout, 111,56, @on --Audit Add Role Event,ObjectID2 EXEC sp_trace_setevent @traceidout, 111,57, @on --Audit Add Role Event,Type EXEC sp_trace_setevent @traceidout, 111,58, @on --Audit Add Role Event,OwnerID EXEC sp_trace_setevent @traceidout, 111,59, @on --Audit Add Role Event,ParentName EXEC sp_trace_setevent @traceidout, 111,60, @on --Audit Add Role Event,IsSystem EXEC sp_trace_setevent @traceidout, 111,61, @on --Audit Add Role Event,Offset EXEC sp_trace_setevent @traceidout, 111,62, @on --Audit Add Role Event,SourceDatabaseID EXEC sp_trace_setevent @traceidout, 111,63, @on --Audit Add Role Event,SqlHandle EXEC sp_trace_setevent @traceidout, 111,64, @on --Audit Add Role Event,SessionLoginName --filters exec sp_trace_setfilter @traceidout,6, 0,7, N'NETWORK SERVICE%' -- AND NTUserName NOT LIKE NETWORK SERVICE% exec sp_trace_setfilter @traceidout,6, 0,7, N'SYSTEM%' -- AND NTUserName NOT LIKE SYSTEM% exec sp_trace_setfilter @traceidout,12,0,4, N'50' -- AND SPID >= 50 --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 IF EXISTS(select * from sysobjects where xtype='V' and name='sp_LogonTrace') BEGIN SET @sql = 'ALTER VIEW sp_LogonTrace AS SELECT ev.name , tr.* FROM ::fn_trace_gettable(''' + @path +'.trc'', default) tr INNER join sys.trace_events ev ON tr.eventclass = ev.trace_event_id' exec(@sql) END ELSE BEGIN SET @sql = 'CREATE VIEW sp_LogonTrace AS SELECT ev.name , tr.* FROM ::fn_trace_gettable(''' + @path +'.trc'', default) tr INNER join sys.trace_events ev ON tr.eventclass = ev.trace_event_id' exec(@sql) END SELECT 'Trace Created, View sp_LogonTrace Created As Well' END --ELSE Trace Does Not Exist COMMIT TRAN END --PROC GO