SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


sp_trace_create TSQL Newbie


sp_trace_create TSQL Newbie

Author
Message
ian howard
ian howard
Valued Member
Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)

Group: General Forum Members
Points: 58 Visits: 5
CrazyCrazyCan someone please assist I've gone blind trying to see what is wrong with the two select statements (@instancename & @filename) they are the only things giving an error. I'm trying to create a security audit trace that will rollover like C2 auditing and I can then create a procedure etc.....see bottom of post. Big thank you to anyone who will help..



--Trace for usp_secaudit

declare @TraceID int
declare @maxfilesize bigint
DECLARE @filecount INT
DECLARE @filename NVARCHAR(245)
DECLARE @instancename NVARCHAR(128)
set @maxfilesize = 20
SET @filecount = 15

SELECT @instancename = CONVERT(VARCHAR, SERVERPROPERTY(’InstanceName’))

SELECT @filename = N’D:\MSSQL\’ + @instancename + REPLACE(REPLACE(REPLACE(CONVERT(VARCHAR,GETDATE(),120),’-’,’’),’:’,’’),’ ’,’’)

-- @filename, e.g., D:\MSSQL\ The .trc extension
-- will be appended to the filename automatically. If you are writing from
-- remote server to local drive, please use UNC path and make sure server has
-- write access to your network share


EXEC sp_trace_create @TraceID OUTPUT, 2, @filename, @maxfilesize, NULL, @filecount

-- Set the events
declare @on bit
set @on = 1
exec sp_trace_setevent @TraceID, 164, 7, @on
exec sp_trace_setevent @TraceID, 164, 8, @on
exec sp_trace_setevent @TraceID, 164, 24, @on
exec sp_trace_setevent @TraceID, 164, 56, @on
exec sp_trace_setevent @TraceID, 164, 64, @on
exec sp_trace_setevent @TraceID, 164, 9, @on
exec sp_trace_setevent @TraceID, 164, 25, @on
exec sp_trace_setevent @TraceID, 164, 41, @on
exec sp_trace_setevent @TraceID, 164, 49, @on
exec sp_trace_setevent @TraceID, 164, 6, @on
exec sp_trace_setevent @TraceID, 164, 10, @on
exec sp_trace_setevent @TraceID, 164, 14, @on
exec sp_trace_setevent @TraceID, 164, 22, @on
exec sp_trace_setevent @TraceID, 164, 26, @on
exec sp_trace_setevent @TraceID, 164, 34, @on
exec sp_trace_setevent @TraceID, 164, 50, @on
exec sp_trace_setevent @TraceID, 164, 66, @on
exec sp_trace_setevent @TraceID, 164, 3, @on
exec sp_trace_setevent @TraceID, 164, 11, @on
exec sp_trace_setevent @TraceID, 164, 35, @on
exec sp_trace_setevent @TraceID, 164, 51, @on
exec sp_trace_setevent @TraceID, 164, 4, @on
exec sp_trace_setevent @TraceID, 164, 12, @on
exec sp_trace_setevent @TraceID, 164, 28, @on
exec sp_trace_setevent @TraceID, 164, 52, @on
exec sp_trace_setevent @TraceID, 164, 60, @on
exec sp_trace_setevent @TraceID, 164, 21, @on
exec sp_trace_setevent @TraceID, 46, 7, @on
exec sp_trace_setevent @TraceID, 46, 8, @on
exec sp_trace_setevent @TraceID, 46, 24, @on
exec sp_trace_setevent @TraceID, 46, 56, @on
exec sp_trace_setevent @TraceID, 46, 64, @on
exec sp_trace_setevent @TraceID, 46, 9, @on
exec sp_trace_setevent @TraceID, 46, 25, @on
exec sp_trace_setevent @TraceID, 46, 41, @on
exec sp_trace_setevent @TraceID, 46, 49, @on
exec sp_trace_setevent @TraceID, 46, 6, @on
exec sp_trace_setevent @TraceID, 46, 10, @on
exec sp_trace_setevent @TraceID, 46, 14, @on
exec sp_trace_setevent @TraceID, 46, 22, @on
exec sp_trace_setevent @TraceID, 46, 26, @on
exec sp_trace_setevent @TraceID, 46, 34, @on
exec sp_trace_setevent @TraceID, 46, 50, @on
exec sp_trace_setevent @TraceID, 46, 66, @on
exec sp_trace_setevent @TraceID, 46, 3, @on
exec sp_trace_setevent @TraceID, 46, 11, @on
exec sp_trace_setevent @TraceID, 46, 35, @on
exec sp_trace_setevent @TraceID, 46, 51, @on
exec sp_trace_setevent @TraceID, 46, 4, @on
exec sp_trace_setevent @TraceID, 46, 12, @on
exec sp_trace_setevent @TraceID, 46, 28, @on
exec sp_trace_setevent @TraceID, 46, 52, @on
exec sp_trace_setevent @TraceID, 46, 60, @on
exec sp_trace_setevent @TraceID, 46, 21, @on
exec sp_trace_setevent @TraceID, 47, 7, @on
exec sp_trace_setevent @TraceID, 47, 8, @on
exec sp_trace_setevent @TraceID, 47, 24, @on
exec sp_trace_setevent @TraceID, 47, 56, @on
exec sp_trace_setevent @TraceID, 47, 64, @on
exec sp_trace_setevent @TraceID, 47, 9, @on
exec sp_trace_setevent @TraceID, 47, 25, @on
exec sp_trace_setevent @TraceID, 47, 41, @on
exec sp_trace_setevent @TraceID, 47, 49, @on
exec sp_trace_setevent @TraceID, 47, 6, @on
exec sp_trace_setevent @TraceID, 47, 10, @on
exec sp_trace_setevent @TraceID, 47, 14, @on
exec sp_trace_setevent @TraceID, 47, 22, @on
exec sp_trace_setevent @TraceID, 47, 26, @on
exec sp_trace_setevent @TraceID, 47, 34, @on
exec sp_trace_setevent @TraceID, 47, 50, @on
exec sp_trace_setevent @TraceID, 47, 66, @on
exec sp_trace_setevent @TraceID, 47, 3, @on
exec sp_trace_setevent @TraceID, 47, 11, @on
exec sp_trace_setevent @TraceID, 47, 35, @on
exec sp_trace_setevent @TraceID, 47, 51, @on
exec sp_trace_setevent @TraceID, 47, 4, @on
exec sp_trace_setevent @TraceID, 47, 12, @on
exec sp_trace_setevent @TraceID, 47, 28, @on
exec sp_trace_setevent @TraceID, 47, 52, @on
exec sp_trace_setevent @TraceID, 47, 60, @on
exec sp_trace_setevent @TraceID, 47, 21, @on
exec sp_trace_setevent @TraceID, 109, 7, @on
exec sp_trace_setevent @TraceID, 109, 23, @on
exec sp_trace_setevent @TraceID, 109, 39, @on
exec sp_trace_setevent @TraceID, 109, 8, @on
exec sp_trace_setevent @TraceID, 109, 40, @on
exec sp_trace_setevent @TraceID, 109, 64, @on
exec sp_trace_setevent @TraceID, 109, 9, @on
exec sp_trace_setevent @TraceID, 109, 41, @on
exec sp_trace_setevent @TraceID, 109, 49, @on
exec sp_trace_setevent @TraceID, 109, 10, @on
exec sp_trace_setevent @TraceID, 109, 26, @on
exec sp_trace_setevent @TraceID, 109, 42, @on
exec sp_trace_setevent @TraceID, 109, 50, @on
exec sp_trace_setevent @TraceID, 109, 3, @on
exec sp_trace_setevent @TraceID, 109, 11, @on
exec sp_trace_setevent @TraceID, 109, 35, @on
exec sp_trace_setevent @TraceID, 109, 43, @on
exec sp_trace_setevent @TraceID, 109, 51, @on
exec sp_trace_setevent @TraceID, 109, 4, @on
exec sp_trace_setevent @TraceID, 109, 12, @on
exec sp_trace_setevent @TraceID, 109, 28, @on
exec sp_trace_setevent @TraceID, 109, 44, @on
exec sp_trace_setevent @TraceID, 109, 60, @on
exec sp_trace_setevent @TraceID, 109, 21, @on
exec sp_trace_setevent @TraceID, 109, 29, @on
exec sp_trace_setevent @TraceID, 109, 37, @on
exec sp_trace_setevent @TraceID, 109, 6, @on
exec sp_trace_setevent @TraceID, 109, 14, @on
exec sp_trace_setevent @TraceID, 109, 38, @on
exec sp_trace_setevent @TraceID, 108, 7, @on
exec sp_trace_setevent @TraceID, 108, 23, @on
exec sp_trace_setevent @TraceID, 108, 8, @on
exec sp_trace_setevent @TraceID, 108, 40, @on
exec sp_trace_setevent @TraceID, 108, 64, @on
exec sp_trace_setevent @TraceID, 108, 1, @on
exec sp_trace_setevent @TraceID, 108, 9, @on
exec sp_trace_setevent @TraceID, 108, 41, @on
exec sp_trace_setevent @TraceID, 108, 49, @on
exec sp_trace_setevent @TraceID, 108, 10, @on
exec sp_trace_setevent @TraceID, 108, 26, @on
exec sp_trace_setevent @TraceID, 108, 34, @on
exec sp_trace_setevent @TraceID, 108, 42, @on
exec sp_trace_setevent @TraceID, 108, 50, @on
exec sp_trace_setevent @TraceID, 108, 3, @on
exec sp_trace_setevent @TraceID, 108, 11, @on
exec sp_trace_setevent @TraceID, 108, 35, @on
exec sp_trace_setevent @TraceID, 108, 43, @on
exec sp_trace_setevent @TraceID, 108, 51, @on
exec sp_trace_setevent @TraceID, 108, 4, @on
exec sp_trace_setevent @TraceID, 108, 12, @on
exec sp_trace_setevent @TraceID, 108, 28, @on
exec sp_trace_setevent @TraceID, 108, 60, @on
exec sp_trace_setevent @TraceID, 108, 21, @on
exec sp_trace_setevent @TraceID, 108, 29, @on
exec sp_trace_setevent @TraceID, 108, 37, @on
exec sp_trace_setevent @TraceID, 108, 6, @on
exec sp_trace_setevent @TraceID, 108, 14, @on
exec sp_trace_setevent @TraceID, 108, 38, @on
exec sp_trace_setevent @TraceID, 110, 7, @on
exec sp_trace_setevent @TraceID, 110, 23, @on
exec sp_trace_setevent @TraceID, 110, 39, @on
exec sp_trace_setevent @TraceID, 110, 8, @on
exec sp_trace_setevent @TraceID, 110, 40, @on
exec sp_trace_setevent @TraceID, 110, 64, @on
exec sp_trace_setevent @TraceID, 110, 1, @on
exec sp_trace_setevent @TraceID, 110, 9, @on
exec sp_trace_setevent @TraceID, 110, 41, @on
exec sp_trace_setevent @TraceID, 110, 49, @on
exec sp_trace_setevent @TraceID, 110, 10, @on
exec sp_trace_setevent @TraceID, 110, 26, @on
exec sp_trace_setevent @TraceID, 110, 34, @on
exec sp_trace_setevent @TraceID, 110, 42, @on
exec sp_trace_setevent @TraceID, 110, 50, @on
exec sp_trace_setevent @TraceID, 110, 3, @on
exec sp_trace_setevent @TraceID, 110, 11, @on
exec sp_trace_setevent @TraceID, 110, 35, @on
exec sp_trace_setevent @TraceID, 110, 43, @on
exec sp_trace_setevent @TraceID, 110, 51, @on
exec sp_trace_setevent @TraceID, 110, 4, @on
exec sp_trace_setevent @TraceID, 110, 12, @on
exec sp_trace_setevent @TraceID, 110, 28, @on
exec sp_trace_setevent @TraceID, 110, 60, @on
exec sp_trace_setevent @TraceID, 110, 21, @on
exec sp_trace_setevent @TraceID, 110, 29, @on
exec sp_trace_setevent @TraceID, 110, 37, @on
exec sp_trace_setevent @TraceID, 110, 6, @on
exec sp_trace_setevent @TraceID, 110, 14, @on
exec sp_trace_setevent @TraceID, 110, 38, @on
exec sp_trace_setevent @TraceID, 111, 7, @on
exec sp_trace_setevent @TraceID, 111, 23, @on
exec sp_trace_setevent @TraceID, 111, 8, @on
exec sp_trace_setevent @TraceID, 111, 40, @on
exec sp_trace_setevent @TraceID, 111, 64, @on
exec sp_trace_setevent @TraceID, 111, 9, @on
exec sp_trace_setevent @TraceID, 111, 41, @on
exec sp_trace_setevent @TraceID, 111, 49, @on
exec sp_trace_setevent @TraceID, 111, 6, @on
exec sp_trace_setevent @TraceID, 111, 10, @on
exec sp_trace_setevent @TraceID, 111, 14, @on
exec sp_trace_setevent @TraceID, 111, 26, @on
exec sp_trace_setevent @TraceID, 111, 38, @on
exec sp_trace_setevent @TraceID, 111, 50, @on
exec sp_trace_setevent @TraceID, 111, 3, @on
exec sp_trace_setevent @TraceID, 111, 11, @on
exec sp_trace_setevent @TraceID, 111, 35, @on
exec sp_trace_setevent @TraceID, 111, 51, @on
exec sp_trace_setevent @TraceID, 111, 4, @on
exec sp_trace_setevent @TraceID, 111, 12, @on
exec sp_trace_setevent @TraceID, 111, 28, @on
exec sp_trace_setevent @TraceID, 111, 60, @on
exec sp_trace_setevent @TraceID, 111, 21, @on
exec sp_trace_setevent @TraceID, 111, 29, @on
exec sp_trace_setevent @TraceID, 104, 7, @on
exec sp_trace_setevent @TraceID, 104, 23, @on
exec sp_trace_setevent @TraceID, 104, 8, @on
exec sp_trace_setevent @TraceID, 104, 40, @on
exec sp_trace_setevent @TraceID, 104, 64, @on
exec sp_trace_setevent @TraceID, 104, 9, @on
exec sp_trace_setevent @TraceID, 104, 41, @on
exec sp_trace_setevent @TraceID, 104, 49, @on
exec sp_trace_setevent @TraceID, 104, 6, @on
exec sp_trace_setevent @TraceID, 104, 10, @on
exec sp_trace_setevent @TraceID, 104, 14, @on
exec sp_trace_setevent @TraceID, 104, 26, @on
exec sp_trace_setevent @TraceID, 104, 42, @on
exec sp_trace_setevent @TraceID, 104, 50, @on
exec sp_trace_setevent @TraceID, 104, 3, @on
exec sp_trace_setevent @TraceID, 104, 11, @on
exec sp_trace_setevent @TraceID, 104, 35, @on
exec sp_trace_setevent @TraceID, 104, 43, @on
exec sp_trace_setevent @TraceID, 104, 51, @on
exec sp_trace_setevent @TraceID, 104, 4, @on
exec sp_trace_setevent @TraceID, 104, 12, @on
exec sp_trace_setevent @TraceID, 104, 28, @on
exec sp_trace_setevent @TraceID, 104, 60, @on
exec sp_trace_setevent @TraceID, 104, 5, @on
exec sp_trace_setevent @TraceID, 104, 21, @on
exec sp_trace_setevent @TraceID, 112, 7, @on
exec sp_trace_setevent @TraceID, 112, 23, @on
exec sp_trace_setevent @TraceID, 112, 8, @on
exec sp_trace_setevent @TraceID, 112, 40, @on
exec sp_trace_setevent @TraceID, 112, 64, @on
exec sp_trace_setevent @TraceID, 112, 1, @on
exec sp_trace_setevent @TraceID, 112, 9, @on
exec sp_trace_setevent @TraceID, 112, 41, @on
exec sp_trace_setevent @TraceID, 112, 49, @on
exec sp_trace_setevent @TraceID, 112, 6, @on
exec sp_trace_setevent @TraceID, 112, 10, @on
exec sp_trace_setevent @TraceID, 112, 14, @on
exec sp_trace_setevent @TraceID, 112, 26, @on
exec sp_trace_setevent @TraceID, 112, 34, @on
exec sp_trace_setevent @TraceID, 112, 38, @on
exec sp_trace_setevent @TraceID, 112, 50, @on
exec sp_trace_setevent @TraceID, 112, 3, @on
exec sp_trace_setevent @TraceID, 112, 11, @on
exec sp_trace_setevent @TraceID, 112, 35, @on
exec sp_trace_setevent @TraceID, 112, 51, @on
exec sp_trace_setevent @TraceID, 112, 4, @on
exec sp_trace_setevent @TraceID, 112, 12, @on
exec sp_trace_setevent @TraceID, 112, 28, @on
exec sp_trace_setevent @TraceID, 112, 60, @on
exec sp_trace_setevent @TraceID, 112, 29, @on
exec sp_trace_setevent @TraceID, 112, 37, @on
exec sp_trace_setevent @TraceID, 115, 7, @on
exec sp_trace_setevent @TraceID, 115, 23, @on
exec sp_trace_setevent @TraceID, 115, 8, @on
exec sp_trace_setevent @TraceID, 115, 40, @on
exec sp_trace_setevent @TraceID, 115, 64, @on
exec sp_trace_setevent @TraceID, 115, 1, @on
exec sp_trace_setevent @TraceID, 115, 9, @on
exec sp_trace_setevent @TraceID, 115, 41, @on
exec sp_trace_setevent @TraceID, 115, 49, @on
exec sp_trace_setevent @TraceID, 115, 6, @on
exec sp_trace_setevent @TraceID, 115, 10, @on
exec sp_trace_setevent @TraceID, 115, 14, @on
exec sp_trace_setevent @TraceID, 115, 26, @on
exec sp_trace_setevent @TraceID, 115, 34, @on
exec sp_trace_setevent @TraceID, 115, 50, @on
exec sp_trace_setevent @TraceID, 115, 3, @on
exec sp_trace_setevent @TraceID, 115, 11, @on
exec sp_trace_setevent @TraceID, 115, 35, @on
exec sp_trace_setevent @TraceID, 115, 51, @on
exec sp_trace_setevent @TraceID, 115, 4, @on
exec sp_trace_setevent @TraceID, 115, 12, @on
exec sp_trace_setevent @TraceID, 115, 28, @on
exec sp_trace_setevent @TraceID, 115, 60, @on
exec sp_trace_setevent @TraceID, 115, 5, @on
exec sp_trace_setevent @TraceID, 115, 21, @on
exec sp_trace_setevent @TraceID, 115, 29, @on
exec sp_trace_setevent @TraceID, 115, 37, @on
exec sp_trace_setevent @TraceID, 159, 7, @on
exec sp_trace_setevent @TraceID, 159, 39, @on
exec sp_trace_setevent @TraceID, 159, 8, @on
exec sp_trace_setevent @TraceID, 159, 64, @on
exec sp_trace_setevent @TraceID, 159, 1, @on
exec sp_trace_setevent @TraceID, 159, 9, @on
exec sp_trace_setevent @TraceID, 159, 41, @on
exec sp_trace_setevent @TraceID, 159, 6, @on
exec sp_trace_setevent @TraceID, 159, 10, @on
exec sp_trace_setevent @TraceID, 159, 14, @on
exec sp_trace_setevent @TraceID, 159, 26, @on
exec sp_trace_setevent @TraceID, 159, 30, @on
exec sp_trace_setevent @TraceID, 159, 34, @on
exec sp_trace_setevent @TraceID, 159, 38, @on
exec sp_trace_setevent @TraceID, 159, 46, @on
exec sp_trace_setevent @TraceID, 159, 54, @on
exec sp_trace_setevent @TraceID, 159, 3, @on
exec sp_trace_setevent @TraceID, 159, 11, @on
exec sp_trace_setevent @TraceID, 159, 51, @on
exec sp_trace_setevent @TraceID, 159, 4, @on
exec sp_trace_setevent @TraceID, 159, 12, @on
exec sp_trace_setevent @TraceID, 159, 36, @on
exec sp_trace_setevent @TraceID, 159, 60, @on
exec sp_trace_setevent @TraceID, 159, 21, @on
exec sp_trace_setevent @TraceID, 159, 37, @on
exec sp_trace_setevent @TraceID, 117, 7, @on
exec sp_trace_setevent @TraceID, 117, 23, @on
exec sp_trace_setevent @TraceID, 117, 8, @on
exec sp_trace_setevent @TraceID, 117, 40, @on
exec sp_trace_setevent @TraceID, 117, 64, @on
exec sp_trace_setevent @TraceID, 117, 1, @on
exec sp_trace_setevent @TraceID, 117, 9, @on
exec sp_trace_setevent @TraceID, 117, 41, @on
exec sp_trace_setevent @TraceID, 117, 49, @on
exec sp_trace_setevent @TraceID, 117, 6, @on
exec sp_trace_setevent @TraceID, 117, 10, @on
exec sp_trace_setevent @TraceID, 117, 14, @on
exec sp_trace_setevent @TraceID, 117, 26, @on
exec sp_trace_setevent @TraceID, 117, 50, @on
exec sp_trace_setevent @TraceID, 117, 3, @on
exec sp_trace_setevent @TraceID, 117, 11, @on
exec sp_trace_setevent @TraceID, 117, 35, @on
exec sp_trace_setevent @TraceID, 117, 51, @on
exec sp_trace_setevent @TraceID, 117, 12, @on
exec sp_trace_setevent @TraceID, 117, 44, @on
exec sp_trace_setevent @TraceID, 117, 60, @on
exec sp_trace_setevent @TraceID, 117, 5, @on
exec sp_trace_setevent @TraceID, 117, 21, @on
exec sp_trace_setevent @TraceID, 117, 29, @on
exec sp_trace_setevent @TraceID, 117, 37, @on
exec sp_trace_setevent @TraceID, 152, 7, @on
exec sp_trace_setevent @TraceID, 152, 23, @on
exec sp_trace_setevent @TraceID, 152, 39, @on
exec sp_trace_setevent @TraceID, 152, 8, @on
exec sp_trace_setevent @TraceID, 152, 40, @on
exec sp_trace_setevent @TraceID, 152, 64, @on
exec sp_trace_setevent @TraceID, 152, 1, @on
exec sp_trace_setevent @TraceID, 152, 9, @on
exec sp_trace_setevent @TraceID, 152, 41, @on
exec sp_trace_setevent @TraceID, 152, 49, @on
exec sp_trace_setevent @TraceID, 152, 10, @on
exec sp_trace_setevent @TraceID, 152, 26, @on
exec sp_trace_setevent @TraceID, 152, 34, @on
exec sp_trace_setevent @TraceID, 152, 42, @on
exec sp_trace_setevent @TraceID, 152, 50, @on
exec sp_trace_setevent @TraceID, 152, 3, @on
exec sp_trace_setevent @TraceID, 152, 11, @on
exec sp_trace_setevent @TraceID, 152, 35, @on
exec sp_trace_setevent @TraceID, 152, 43, @on
exec sp_trace_setevent @TraceID, 152, 51, @on
exec sp_trace_setevent @TraceID, 152, 4, @on
exec sp_trace_setevent @TraceID, 152, 12, @on
exec sp_trace_setevent @TraceID, 152, 28, @on
exec sp_trace_setevent @TraceID, 152, 60, @on
exec sp_trace_setevent @TraceID, 152, 29, @on
exec sp_trace_setevent @TraceID, 152, 37, @on
exec sp_trace_setevent @TraceID, 152, 6, @on
exec sp_trace_setevent @TraceID, 152, 14, @on
exec sp_trace_setevent @TraceID, 116, 7, @on
exec sp_trace_setevent @TraceID, 116, 23, @on
exec sp_trace_setevent @TraceID, 116, 8, @on
exec sp_trace_setevent @TraceID, 116, 40, @on
exec sp_trace_setevent @TraceID, 116, 64, @on
exec sp_trace_setevent @TraceID, 116, 1, @on
exec sp_trace_setevent @TraceID, 116, 9, @on
exec sp_trace_setevent @TraceID, 116, 41, @on
exec sp_trace_setevent @TraceID, 116, 49, @on
exec sp_trace_setevent @TraceID, 116, 6, @on
exec sp_trace_setevent @TraceID, 116, 10, @on
exec sp_trace_setevent @TraceID, 116, 14, @on
exec sp_trace_setevent @TraceID, 116, 26, @on
exec sp_trace_setevent @TraceID, 116, 50, @on
exec sp_trace_setevent @TraceID, 116, 3, @on
exec sp_trace_setevent @TraceID, 116, 11, @on
exec sp_trace_setevent @TraceID, 116, 35, @on
exec sp_trace_setevent @TraceID, 116, 51, @on
exec sp_trace_setevent @TraceID, 116, 4, @on
exec sp_trace_setevent @TraceID, 116, 12, @on
exec sp_trace_setevent @TraceID, 116, 44, @on
exec sp_trace_setevent @TraceID, 116, 60, @on
exec sp_trace_setevent @TraceID, 116, 5, @on
exec sp_trace_setevent @TraceID, 116, 29, @on
exec sp_trace_setevent @TraceID, 116, 37, @on
exec sp_trace_setevent @TraceID, 128, 7, @on
exec sp_trace_setevent @TraceID, 128, 23, @on
exec sp_trace_setevent @TraceID, 128, 8, @on
exec sp_trace_setevent @TraceID, 128, 40, @on
exec sp_trace_setevent @TraceID, 128, 64, @on
exec sp_trace_setevent @TraceID, 128, 1, @on
exec sp_trace_setevent @TraceID, 128, 41, @on
exec sp_trace_setevent @TraceID, 128, 49, @on
exec sp_trace_setevent @TraceID, 128, 6, @on
exec sp_trace_setevent @TraceID, 128, 10, @on
exec sp_trace_setevent @TraceID, 128, 14, @on
exec sp_trace_setevent @TraceID, 128, 26, @on
exec sp_trace_setevent @TraceID, 128, 34, @on
exec sp_trace_setevent @TraceID, 128, 50, @on
exec sp_trace_setevent @TraceID, 128, 3, @on
exec sp_trace_setevent @TraceID, 128, 11, @on
exec sp_trace_setevent @TraceID, 128, 35, @on
exec sp_trace_setevent @TraceID, 128, 51, @on
exec sp_trace_setevent @TraceID, 128, 4, @on
exec sp_trace_setevent @TraceID, 128, 12, @on
exec sp_trace_setevent @TraceID, 128, 28, @on
exec sp_trace_setevent @TraceID, 128, 60, @on
exec sp_trace_setevent @TraceID, 128, 21, @on
exec sp_trace_setevent @TraceID, 128, 29, @on
exec sp_trace_setevent @TraceID, 128, 37, @on
exec sp_trace_setevent @TraceID, 180, 7, @on
exec sp_trace_setevent @TraceID, 180, 23, @on
exec sp_trace_setevent @TraceID, 180, 8, @on
exec sp_trace_setevent @TraceID, 180, 40, @on
exec sp_trace_setevent @TraceID, 180, 64, @on
exec sp_trace_setevent @TraceID, 180, 1, @on
exec sp_trace_setevent @TraceID, 180, 41, @on
exec sp_trace_setevent @TraceID, 180, 49, @on
exec sp_trace_setevent @TraceID, 180, 6, @on
exec sp_trace_setevent @TraceID, 180, 10, @on
exec sp_trace_setevent @TraceID, 180, 14, @on
exec sp_trace_setevent @TraceID, 180, 26, @on
exec sp_trace_setevent @TraceID, 180, 34, @on
exec sp_trace_setevent @TraceID, 180, 50, @on
exec sp_trace_setevent @TraceID, 180, 3, @on
exec sp_trace_setevent @TraceID, 180, 11, @on
exec sp_trace_setevent @TraceID, 180, 19, @on
exec sp_trace_setevent @TraceID, 180, 35, @on
exec sp_trace_setevent @TraceID, 180, 51, @on
exec sp_trace_setevent @TraceID, 180, 4, @on
exec sp_trace_setevent @TraceID, 180, 12, @on
exec sp_trace_setevent @TraceID, 180, 28, @on
exec sp_trace_setevent @TraceID, 180, 60, @on
exec sp_trace_setevent @TraceID, 180, 29, @on
exec sp_trace_setevent @TraceID, 180, 37, @on
exec sp_trace_setevent @TraceID, 172, 7, @on
exec sp_trace_setevent @TraceID, 172, 23, @on
exec sp_trace_setevent @TraceID, 172, 39, @on
exec sp_trace_setevent @TraceID, 172, 8, @on
exec sp_trace_setevent @TraceID, 172, 40, @on
exec sp_trace_setevent @TraceID, 172, 64, @on
exec sp_trace_setevent @TraceID, 172, 1, @on
exec sp_trace_setevent @TraceID, 172, 9, @on
exec sp_trace_setevent @TraceID, 172, 41, @on
exec sp_trace_setevent @TraceID, 172, 49, @on
exec sp_trace_setevent @TraceID, 172, 10, @on
exec sp_trace_setevent @TraceID, 172, 26, @on
exec sp_trace_setevent @TraceID, 172, 34, @on
exec sp_trace_setevent @TraceID, 172, 42, @on
exec sp_trace_setevent @TraceID, 172, 50, @on
exec sp_trace_setevent @TraceID, 172, 3, @on
exec sp_trace_setevent @TraceID, 172, 11, @on
exec sp_trace_setevent @TraceID, 172, 19, @on
exec sp_trace_setevent @TraceID, 172, 35, @on
exec sp_trace_setevent @TraceID, 172, 43, @on
exec sp_trace_setevent @TraceID, 172, 51, @on
exec sp_trace_setevent @TraceID, 172, 4, @on
exec sp_trace_setevent @TraceID, 172, 12, @on
exec sp_trace_setevent @TraceID, 172, 28, @on
exec sp_trace_setevent @TraceID, 172, 60, @on
exec sp_trace_setevent @TraceID, 172, 21, @on
exec sp_trace_setevent @TraceID, 172, 29, @on
exec sp_trace_setevent @TraceID, 172, 37, @on
exec sp_trace_setevent @TraceID, 172, 6, @on
exec sp_trace_setevent @TraceID, 172, 14, @on
exec sp_trace_setevent @TraceID, 129, 7, @on
exec sp_trace_setevent @TraceID, 129, 23, @on
exec sp_trace_setevent @TraceID, 129, 8, @on
exec sp_trace_setevent @TraceID, 129, 40, @on
exec sp_trace_setevent @TraceID, 129, 64, @on
exec sp_trace_setevent @TraceID, 129, 1, @on
exec sp_trace_setevent @TraceID, 129, 41, @on
exec sp_trace_setevent @TraceID, 129, 49, @on
exec sp_trace_setevent @TraceID, 129, 6, @on
exec sp_trace_setevent @TraceID, 129, 10, @on
exec sp_trace_setevent @TraceID, 129, 14, @on
exec sp_trace_setevent @TraceID, 129, 26, @on
exec sp_trace_setevent @TraceID, 129, 34, @on
exec sp_trace_setevent @TraceID, 129, 50, @on
exec sp_trace_setevent @TraceID, 129, 3, @on
exec sp_trace_setevent @TraceID, 129, 11, @on
exec sp_trace_setevent @TraceID, 129, 35, @on
exec sp_trace_setevent @TraceID, 129, 51, @on
exec sp_trace_setevent @TraceID, 129, 4, @on
exec sp_trace_setevent @TraceID, 129, 12, @on
exec sp_trace_setevent @TraceID, 129, 28, @on
exec sp_trace_setevent @TraceID, 129, 60, @on
exec sp_trace_setevent @TraceID, 129, 5, @on
exec sp_trace_setevent @TraceID, 129, 21, @on
exec sp_trace_setevent @TraceID, 129, 29, @on
exec sp_trace_setevent @TraceID, 129, 37, @on
exec sp_trace_setevent @TraceID, 135, 7, @on
exec sp_trace_setevent @TraceID, 135, 23, @on
exec sp_trace_setevent @TraceID, 135, 39, @on
exec sp_trace_setevent @TraceID, 135, 8, @on
exec sp_trace_setevent @TraceID, 135, 40, @on
exec sp_trace_setevent @TraceID, 135, 64, @on
exec sp_trace_setevent @TraceID, 135, 1, @on
exec sp_trace_setevent @TraceID, 135, 41, @on
exec sp_trace_setevent @TraceID, 135, 49, @on
exec sp_trace_setevent @TraceID, 135, 6, @on
exec sp_trace_setevent @TraceID, 135, 10, @on
exec sp_trace_setevent @TraceID, 135, 14, @on
exec sp_trace_setevent @TraceID, 135, 26, @on
exec sp_trace_setevent @TraceID, 135, 34, @on
exec sp_trace_setevent @TraceID, 135, 50, @on
exec sp_trace_setevent @TraceID, 135, 3, @on
exec sp_trace_setevent @TraceID, 135, 11, @on
exec sp_trace_setevent @TraceID, 135, 35, @on
exec sp_trace_setevent @TraceID, 135, 51, @on
exec sp_trace_setevent @TraceID, 135, 4, @on
exec sp_trace_setevent @TraceID, 135, 12, @on
exec sp_trace_setevent @TraceID, 135, 28, @on
exec sp_trace_setevent @TraceID, 135, 60, @on
exec sp_trace_setevent @TraceID, 135, 29, @on
exec sp_trace_setevent @TraceID, 135, 37, @on
exec sp_trace_setevent @TraceID, 178, 7, @on
exec sp_trace_setevent @TraceID, 178, 23, @on
exec sp_trace_setevent @TraceID, 178, 8, @on
exec sp_trace_setevent @TraceID, 178, 40, @on
exec sp_trace_setevent @TraceID, 178, 64, @on
exec sp_trace_setevent @TraceID, 178, 1, @on
exec sp_trace_setevent @TraceID, 178, 41, @on
exec sp_trace_setevent @TraceID, 178, 49, @on
exec sp_trace_setevent @TraceID, 178, 6, @on
exec sp_trace_setevent @TraceID, 178, 10, @on
exec sp_trace_setevent @TraceID, 178, 14, @on
exec sp_trace_setevent @TraceID, 178, 26, @on
exec sp_trace_setevent @TraceID, 178, 34, @on
exec sp_trace_setevent @TraceID, 178, 50, @on
exec sp_trace_setevent @TraceID, 178, 3, @on
exec sp_trace_setevent @TraceID, 178, 11, @on
exec sp_trace_setevent @TraceID, 178, 35, @on
exec sp_trace_setevent @TraceID, 178, 51, @on
exec sp_trace_setevent @TraceID, 178, 4, @on
exec sp_trace_setevent @TraceID, 178, 12, @on
exec sp_trace_setevent @TraceID, 178, 28, @on
exec sp_trace_setevent @TraceID, 178, 60, @on
exec sp_trace_setevent @TraceID, 178, 21, @on
exec sp_trace_setevent @TraceID, 178, 29, @on
exec sp_trace_setevent @TraceID, 178, 37, @on
exec sp_trace_setevent @TraceID, 133, 7, @on
exec sp_trace_setevent @TraceID, 133, 23, @on
exec sp_trace_setevent @TraceID, 133, 8, @on
exec sp_trace_setevent @TraceID, 133, 40, @on
exec sp_trace_setevent @TraceID, 133, 64, @on
exec sp_trace_setevent @TraceID, 133, 1, @on
exec sp_trace_setevent @TraceID, 133, 41, @on
exec sp_trace_setevent @TraceID, 133, 49, @on
exec sp_trace_setevent @TraceID, 133, 6, @on
exec sp_trace_setevent @TraceID, 133, 10, @on
exec sp_trace_setevent @TraceID, 133, 14, @on
exec sp_trace_setevent @TraceID, 133, 26, @on
exec sp_trace_setevent @TraceID, 133, 34, @on
exec sp_trace_setevent @TraceID, 133, 38, @on
exec sp_trace_setevent @TraceID, 133, 50, @on
exec sp_trace_setevent @TraceID, 133, 3, @on
exec sp_trace_setevent @TraceID, 133, 11, @on
exec sp_trace_setevent @TraceID, 133, 19, @on
exec sp_trace_setevent @TraceID, 133, 35, @on
exec sp_trace_setevent @TraceID, 133, 51, @on
exec sp_trace_setevent @TraceID, 133, 4, @on
exec sp_trace_setevent @TraceID, 133, 12, @on
exec sp_trace_setevent @TraceID, 133, 28, @on
exec sp_trace_setevent @TraceID, 133, 60, @on
exec sp_trace_setevent @TraceID, 133, 21, @on
exec sp_trace_setevent @TraceID, 133, 29, @on
exec sp_trace_setevent @TraceID, 133, 37, @on
exec sp_trace_setevent @TraceID, 130, 7, @on
exec sp_trace_setevent @TraceID, 130, 23, @on
exec sp_trace_setevent @TraceID, 130, 39, @on
exec sp_trace_setevent @TraceID, 130, 8, @on
exec sp_trace_setevent @TraceID, 130, 40, @on
exec sp_trace_setevent @TraceID, 130, 64, @on
exec sp_trace_setevent @TraceID, 130, 1, @on
exec sp_trace_setevent @TraceID, 130, 41, @on
exec sp_trace_setevent @TraceID, 130, 49, @on
exec sp_trace_setevent @TraceID, 130, 10, @on
exec sp_trace_setevent @TraceID, 130, 26, @on
exec sp_trace_setevent @TraceID, 130, 34, @on
exec sp_trace_setevent @TraceID, 130, 42, @on
exec sp_trace_setevent @TraceID, 130, 50, @on
exec sp_trace_setevent @TraceID, 130, 3, @on
exec sp_trace_setevent @TraceID, 130, 11, @on
exec sp_trace_setevent @TraceID, 130, 35, @on
exec sp_trace_setevent @TraceID, 130, 43, @on
exec sp_trace_setevent @TraceID, 130, 51, @on
exec sp_trace_setevent @TraceID, 130, 4, @on
exec sp_trace_setevent @TraceID, 130, 12, @on
exec sp_trace_setevent @TraceID, 130, 28, @on
exec sp_trace_setevent @TraceID, 130, 60, @on
exec sp_trace_setevent @TraceID, 130, 21, @on
exec sp_trace_setevent @TraceID, 130, 29, @on
exec sp_trace_setevent @TraceID, 130, 37, @on
exec sp_trace_setevent @TraceID, 130, 6, @on
exec sp_trace_setevent @TraceID, 130, 14, @on
exec sp_trace_setevent @TraceID, 102, 7, @on
exec sp_trace_setevent @TraceID, 102, 23, @on
exec sp_trace_setevent @TraceID, 102, 39, @on
exec sp_trace_setevent @TraceID, 102, 8, @on
exec sp_trace_setevent @TraceID, 102, 40, @on
exec sp_trace_setevent @TraceID, 102, 64, @on
exec sp_trace_setevent @TraceID, 102, 1, @on
exec sp_trace_setevent @TraceID, 102, 9, @on
exec sp_trace_setevent @TraceID, 102, 41, @on
exec sp_trace_setevent @TraceID, 102, 49, @on
exec sp_trace_setevent @TraceID, 102, 10, @on
exec sp_trace_setevent @TraceID, 102, 26, @on
exec sp_trace_setevent @TraceID, 102, 34, @on
exec sp_trace_setevent @TraceID, 102, 42, @on
exec sp_trace_setevent @TraceID, 102, 50, @on
exec sp_trace_setevent @TraceID, 102, 3, @on
exec sp_trace_setevent @TraceID, 102, 11, @on
exec sp_trace_setevent @TraceID, 102, 19, @on
exec sp_trace_setevent @TraceID, 102, 35, @on
exec sp_trace_setevent @TraceID, 102, 43, @on
exec sp_trace_setevent @TraceID, 102, 51, @on
exec sp_trace_setevent @TraceID, 102, 4, @on
exec sp_trace_setevent @TraceID, 102, 12, @on
exec sp_trace_setevent @TraceID, 102, 28, @on
exec sp_trace_setevent @TraceID, 102, 60, @on
exec sp_trace_setevent @TraceID, 102, 5, @on
exec sp_trace_setevent @TraceID, 102, 21, @on
exec sp_trace_setevent @TraceID, 102, 29, @on
exec sp_trace_setevent @TraceID, 102, 37, @on
exec sp_trace_setevent @TraceID, 102, 6, @on
exec sp_trace_setevent @TraceID, 102, 14, @on
exec sp_trace_setevent @TraceID, 235, 23, @on
exec sp_trace_setevent @TraceID, 235, 31, @on
exec sp_trace_setevent @TraceID, 235, 43, @on
exec sp_trace_setevent @TraceID, 235, 51, @on
exec sp_trace_setevent @TraceID, 235, 12, @on
exec sp_trace_setevent @TraceID, 235, 14, @on
exec sp_trace_setevent @TraceID, 235, 42, @on
exec sp_trace_setevent @TraceID, 235, 60, @on
exec sp_trace_setevent @TraceID, 235, 64, @on
exec sp_trace_setevent @TraceID, 235, 1, @on
exec sp_trace_setevent @TraceID, 235, 21, @on
exec sp_trace_setevent @TraceID, 14, 7, @on
exec sp_trace_setevent @TraceID, 14, 23, @on
exec sp_trace_setevent @TraceID, 14, 8, @on
exec sp_trace_setevent @TraceID, 14, 64, @on
exec sp_trace_setevent @TraceID, 14, 1, @on
exec sp_trace_setevent @TraceID, 14, 9, @on
exec sp_trace_setevent @TraceID, 14, 21, @on
exec sp_trace_setevent @TraceID, 14, 25, @on
exec sp_trace_setevent @TraceID, 14, 41, @on
exec sp_trace_setevent @TraceID, 14, 49, @on
exec sp_trace_setevent @TraceID, 14, 57, @on
exec sp_trace_setevent @TraceID, 14, 2, @on
exec sp_trace_setevent @TraceID, 14, 6, @on
exec sp_trace_setevent @TraceID, 14, 10, @on
exec sp_trace_setevent @TraceID, 14, 14, @on
exec sp_trace_setevent @TraceID, 14, 26, @on
exec sp_trace_setevent @TraceID, 14, 66, @on
exec sp_trace_setevent @TraceID, 14, 3, @on
exec sp_trace_setevent @TraceID, 14, 11, @on
exec sp_trace_setevent @TraceID, 14, 35, @on
exec sp_trace_setevent @TraceID, 14, 51, @on
exec sp_trace_setevent @TraceID, 14, 12, @on
exec sp_trace_setevent @TraceID, 14, 60, @on
exec sp_trace_setevent @TraceID, 107, 7, @on
exec sp_trace_setevent @TraceID, 107, 23, @on
exec sp_trace_setevent @TraceID, 107, 8, @on
exec sp_trace_setevent @TraceID, 107, 40, @on
exec sp_trace_setevent @TraceID, 107, 64, @on
exec sp_trace_setevent @TraceID, 107, 1, @on
exec sp_trace_setevent @TraceID, 107, 9, @on
exec sp_trace_setevent @TraceID, 107, 41, @on
exec sp_trace_setevent @TraceID, 107, 49, @on
exec sp_trace_setevent @TraceID, 107, 10, @on
exec sp_trace_setevent @TraceID, 107, 26, @on
exec sp_trace_setevent @TraceID, 107, 34, @on
exec sp_trace_setevent @TraceID, 107, 42, @on
exec sp_trace_setevent @TraceID, 107, 50, @on
exec sp_trace_setevent @TraceID, 107, 3, @on
exec sp_trace_setevent @TraceID, 107, 11, @on
exec sp_trace_setevent @TraceID, 107, 35, @on
exec sp_trace_setevent @TraceID, 107, 43, @on
exec sp_trace_setevent @TraceID, 107, 51, @on
exec sp_trace_setevent @TraceID, 107, 4, @on
exec sp_trace_setevent @TraceID, 107, 12, @on
exec sp_trace_setevent @TraceID, 107, 28, @on
exec sp_trace_setevent @TraceID, 107, 60, @on
exec sp_trace_setevent @TraceID, 107, 21, @on
exec sp_trace_setevent @TraceID, 107, 29, @on
exec sp_trace_setevent @TraceID, 107, 37, @on
exec sp_trace_setevent @TraceID, 107, 6, @on
exec sp_trace_setevent @TraceID, 107, 14, @on
exec sp_trace_setevent @TraceID, 106, 7, @on
exec sp_trace_setevent @TraceID, 106, 23, @on
exec sp_trace_setevent @TraceID, 106, 8, @on
exec sp_trace_setevent @TraceID, 106, 40, @on
exec sp_trace_setevent @TraceID, 106, 64, @on
exec sp_trace_setevent @TraceID, 106, 1, @on
exec sp_trace_setevent @TraceID, 106, 9, @on
exec sp_trace_setevent @TraceID, 106, 41, @on
exec sp_trace_setevent @TraceID, 106, 49, @on
exec sp_trace_setevent @TraceID, 106, 10, @on
exec sp_trace_setevent @TraceID, 106, 26, @on
exec sp_trace_setevent @TraceID, 106, 34, @on
exec sp_trace_setevent @TraceID, 106, 42, @on
exec sp_trace_setevent @TraceID, 106, 50, @on
exec sp_trace_setevent @TraceID, 106, 3, @on
exec sp_trace_setevent @TraceID, 106, 11, @on
exec sp_trace_setevent @TraceID, 106, 35, @on
exec sp_trace_setevent @TraceID, 106, 43, @on
exec sp_trace_setevent @TraceID, 106, 51, @on
exec sp_trace_setevent @TraceID, 106, 4, @on
exec sp_trace_setevent @TraceID, 106, 12, @on
exec sp_trace_setevent @TraceID, 106, 28, @on
exec sp_trace_setevent @TraceID, 106, 60, @on
exec sp_trace_setevent @TraceID, 106, 5, @on
exec sp_trace_setevent @TraceID, 106, 21, @on
exec sp_trace_setevent @TraceID, 106, 29, @on
exec sp_trace_setevent @TraceID, 106, 37, @on
exec sp_trace_setevent @TraceID, 106, 6, @on
exec sp_trace_setevent @TraceID, 106, 14, @on
exec sp_trace_setevent @TraceID, 20, 7, @on
exec sp_trace_setevent @TraceID, 20, 23, @on
exec sp_trace_setevent @TraceID, 20, 31, @on
exec sp_trace_setevent @TraceID, 20, 8, @on
exec sp_trace_setevent @TraceID, 20, 64, @on
exec sp_trace_setevent @TraceID, 20, 1, @on
exec sp_trace_setevent @TraceID, 20, 9, @on
exec sp_trace_setevent @TraceID, 20, 21, @on
exec sp_trace_setevent @TraceID, 20, 49, @on
exec sp_trace_setevent @TraceID, 20, 57, @on
exec sp_trace_setevent @TraceID, 20, 6, @on
exec sp_trace_setevent @TraceID, 20, 10, @on
exec sp_trace_setevent @TraceID, 20, 14, @on
exec sp_trace_setevent @TraceID, 20, 26, @on
exec sp_trace_setevent @TraceID, 20, 30, @on
exec sp_trace_setevent @TraceID, 20, 3, @on
exec sp_trace_setevent @TraceID, 20, 11, @on
exec sp_trace_setevent @TraceID, 20, 35, @on
exec sp_trace_setevent @TraceID, 20, 51, @on
exec sp_trace_setevent @TraceID, 20, 12, @on
exec sp_trace_setevent @TraceID, 20, 60, @on
exec sp_trace_setevent @TraceID, 105, 7, @on
exec sp_trace_setevent @TraceID, 105, 23, @on
exec sp_trace_setevent @TraceID, 105, 8, @on
exec sp_trace_setevent @TraceID, 105, 40, @on
exec sp_trace_setevent @TraceID, 105, 64, @on
exec sp_trace_setevent @TraceID, 105, 9, @on
exec sp_trace_setevent @TraceID, 105, 41, @on
exec sp_trace_setevent @TraceID, 105, 49, @on
exec sp_trace_setevent @TraceID, 105, 6, @on
exec sp_trace_setevent @TraceID, 105, 10, @on
exec sp_trace_setevent @TraceID, 105, 14, @on
exec sp_trace_setevent @TraceID, 105, 26, @on
exec sp_trace_setevent @TraceID, 105, 42, @on
exec sp_trace_setevent @TraceID, 105, 50, @on
exec sp_trace_setevent @TraceID, 105, 3, @on
exec sp_trace_setevent @TraceID, 105, 11, @on
exec sp_trace_setevent @TraceID, 105, 35, @on
exec sp_trace_setevent @TraceID, 105, 43, @on
exec sp_trace_setevent @TraceID, 105, 51, @on
exec sp_trace_setevent @TraceID, 105, 4, @on
exec sp_trace_setevent @TraceID, 105, 12, @on
exec sp_trace_setevent @TraceID, 105, 28, @on
exec sp_trace_setevent @TraceID, 105, 60, @on
exec sp_trace_setevent @TraceID, 105, 21, @on
exec sp_trace_setevent @TraceID, 15, 7, @on
exec sp_trace_setevent @TraceID, 15, 15, @on
exec sp_trace_setevent @TraceID, 15, 23, @on
exec sp_trace_setevent @TraceID, 15, 8, @on
exec sp_trace_setevent @TraceID, 15, 16, @on
exec sp_trace_setevent @TraceID, 15, 64, @on
exec sp_trace_setevent @TraceID, 15, 9, @on
exec sp_trace_setevent @TraceID, 15, 17, @on
exec sp_trace_setevent @TraceID, 15, 41, @on
exec sp_trace_setevent @TraceID, 15, 49, @on
exec sp_trace_setevent @TraceID, 15, 57, @on
exec sp_trace_setevent @TraceID, 15, 6, @on
exec sp_trace_setevent @TraceID, 15, 10, @on
exec sp_trace_setevent @TraceID, 15, 14, @on
exec sp_trace_setevent @TraceID, 15, 26, @on
exec sp_trace_setevent @TraceID, 15, 66, @on
exec sp_trace_setevent @TraceID, 15, 3, @on
exec sp_trace_setevent @TraceID, 15, 11, @on
exec sp_trace_setevent @TraceID, 15, 35, @on
exec sp_trace_setevent @TraceID, 15, 51, @on
exec sp_trace_setevent @TraceID, 15, 12, @on
exec sp_trace_setevent @TraceID, 15, 60, @on
exec sp_trace_setevent @TraceID, 15, 13, @on
exec sp_trace_setevent @TraceID, 15, 21, @on
exec sp_trace_setevent @TraceID, 118, 7, @on
exec sp_trace_setevent @TraceID, 118, 23, @on
exec sp_trace_setevent @TraceID, 118, 8, @on
exec sp_trace_setevent @TraceID, 118, 40, @on
exec sp_trace_setevent @TraceID, 118, 64, @on
exec sp_trace_setevent @TraceID, 118, 1, @on
exec sp_trace_setevent @TraceID, 118, 9, @on
exec sp_trace_setevent @TraceID, 118, 41, @on
exec sp_trace_setevent @TraceID, 118, 49, @on
exec sp_trace_setevent @TraceID, 118, 6, @on
exec sp_trace_setevent @TraceID, 118, 10, @on
exec sp_trace_setevent @TraceID, 118, 14, @on
exec sp_trace_setevent @TraceID, 118, 26, @on
exec sp_trace_setevent @TraceID, 118, 34, @on
exec sp_trace_setevent @TraceID, 118, 50, @on
exec sp_trace_setevent @TraceID, 118, 3, @on
exec sp_trace_setevent @TraceID, 118, 11, @on
exec sp_trace_setevent @TraceID, 118, 35, @on
exec sp_trace_setevent @TraceID, 118, 51, @on
exec sp_trace_setevent @TraceID, 118, 4, @on
exec sp_trace_setevent @TraceID, 118, 12, @on
exec sp_trace_setevent @TraceID, 118, 28, @on
exec sp_trace_setevent @TraceID, 118, 60, @on
exec sp_trace_setevent @TraceID, 118, 5, @on
exec sp_trace_setevent @TraceID, 118, 21, @on
exec sp_trace_setevent @TraceID, 118, 29, @on
exec sp_trace_setevent @TraceID, 118, 37, @on
exec sp_trace_setevent @TraceID, 114, 7, @on
exec sp_trace_setevent @TraceID, 114, 23, @on
exec sp_trace_setevent @TraceID, 114, 8, @on
exec sp_trace_setevent @TraceID, 114, 40, @on
exec sp_trace_setevent @TraceID, 114, 64, @on
exec sp_trace_setevent @TraceID, 114, 1, @on
exec sp_trace_setevent @TraceID, 114, 9, @on
exec sp_trace_setevent @TraceID, 114, 41, @on
exec sp_trace_setevent @TraceID, 114, 49, @on
exec sp_trace_setevent @TraceID, 114, 2, @on
exec sp_trace_setevent @TraceID, 114, 10, @on
exec sp_trace_setevent @TraceID, 114, 26, @on
exec sp_trace_setevent @TraceID, 114, 34, @on
exec sp_trace_setevent @TraceID, 114, 50, @on
exec sp_trace_setevent @TraceID, 114, 3, @on
exec sp_trace_setevent @TraceID, 114, 11, @on
exec sp_trace_setevent @TraceID, 114, 19, @on
exec sp_trace_setevent @TraceID, 114, 35, @on
exec sp_trace_setevent @TraceID, 114, 51, @on
exec sp_trace_setevent @TraceID, 114, 59, @on
exec sp_trace_setevent @TraceID, 114, 4, @on
exec sp_trace_setevent @TraceID, 114, 12, @on
exec sp_trace_setevent @TraceID, 114, 28, @on
exec sp_trace_setevent @TraceID, 114, 44, @on
exec sp_trace_setevent @TraceID, 114, 60, @on
exec sp_trace_setevent @TraceID, 114, 5, @on
exec sp_trace_setevent @TraceID, 114, 21, @on
exec sp_trace_setevent @TraceID, 114, 29, @on
exec sp_trace_setevent @TraceID, 114, 37, @on
exec sp_trace_setevent @TraceID, 114, 6, @on
exec sp_trace_setevent @TraceID, 114, 14, @on
exec sp_trace_setevent @TraceID, 103, 7, @on
exec sp_trace_setevent @TraceID, 103, 23, @on
exec sp_trace_setevent @TraceID, 103, 39, @on
exec sp_trace_setevent @TraceID, 103, 8, @on
exec sp_trace_setevent @TraceID, 103, 40, @on
exec sp_trace_setevent @TraceID, 103, 64, @on
exec sp_trace_setevent @TraceID, 103, 1, @on
exec sp_trace_setevent @TraceID, 103, 9, @on
exec sp_trace_setevent @TraceID, 103, 41, @on
exec sp_trace_setevent @TraceID, 103, 49, @on
exec sp_trace_setevent @TraceID, 103, 10, @on
exec sp_trace_setevent @TraceID, 103, 26, @on
exec sp_trace_setevent @TraceID, 103, 34, @on
exec sp_trace_setevent @TraceID, 103, 42, @on
exec sp_trace_setevent @TraceID, 103, 50, @on
exec sp_trace_setevent @TraceID, 103, 3, @on
exec sp_trace_setevent @TraceID, 103, 11, @on
exec sp_trace_setevent @TraceID, 103, 19, @on
exec sp_trace_setevent @TraceID, 103, 35, @on
exec sp_trace_setevent @TraceID, 103, 43, @on
exec sp_trace_setevent @TraceID, 103, 51, @on
exec sp_trace_setevent @TraceID, 103, 59, @on
exec sp_trace_setevent @TraceID, 103, 4, @on
exec sp_trace_setevent @TraceID, 103, 12, @on
exec sp_trace_setevent @TraceID, 103, 28, @on
exec sp_trace_setevent @TraceID, 103, 44, @on
exec sp_trace_setevent @TraceID, 103, 60, @on
exec sp_trace_setevent @TraceID, 103, 5, @on
exec sp_trace_setevent @TraceID, 103, 21, @on
exec sp_trace_setevent @TraceID, 103, 29, @on
exec sp_trace_setevent @TraceID, 103, 37, @on
exec sp_trace_setevent @TraceID, 103, 6, @on
exec sp_trace_setevent @TraceID, 103, 14, @on
exec sp_trace_setevent @TraceID, 131, 7, @on
exec sp_trace_setevent @TraceID, 131, 23, @on
exec sp_trace_setevent @TraceID, 131, 8, @on
exec sp_trace_setevent @TraceID, 131, 40, @on
exec sp_trace_setevent @TraceID, 131, 64, @on
exec sp_trace_setevent @TraceID, 131, 1, @on
exec sp_trace_setevent @TraceID, 131, 41, @on
exec sp_trace_setevent @TraceID, 131, 49, @on
exec sp_trace_setevent @TraceID, 131, 6, @on
exec sp_trace_setevent @TraceID, 131, 10, @on
exec sp_trace_setevent @TraceID, 131, 14, @on
exec sp_trace_setevent @TraceID, 131, 26, @on
exec sp_trace_setevent @TraceID, 131, 34, @on
exec sp_trace_setevent @TraceID, 131, 50, @on
exec sp_trace_setevent @TraceID, 131, 3, @on
exec sp_trace_setevent @TraceID, 131, 11, @on
exec sp_trace_setevent @TraceID, 131, 35, @on
exec sp_trace_setevent @TraceID, 131, 51, @on
exec sp_trace_setevent @TraceID, 131, 59, @on
exec sp_trace_setevent @TraceID, 131, 4, @on
exec sp_trace_setevent @TraceID, 131, 12, @on
exec sp_trace_setevent @TraceID, 131, 28, @on
exec sp_trace_setevent @TraceID, 131, 60, @on
exec sp_trace_setevent @TraceID, 131, 21, @on
exec sp_trace_setevent @TraceID, 131, 29, @on
exec sp_trace_setevent @TraceID, 131, 37, @on
exec sp_trace_setevent @TraceID, 153, 7, @on
exec sp_trace_setevent @TraceID, 153, 23, @on
exec sp_trace_setevent @TraceID, 153, 39, @on
exec sp_trace_setevent @TraceID, 153, 8, @on
exec sp_trace_setevent @TraceID, 153, 40, @on
exec sp_trace_setevent @TraceID, 153, 64, @on
exec sp_trace_setevent @TraceID, 153, 1, @on
exec sp_trace_setevent @TraceID, 153, 41, @on
exec sp_trace_setevent @TraceID, 153, 49, @on
exec sp_trace_setevent @TraceID, 153, 10, @on
exec sp_trace_setevent @TraceID, 153, 26, @on
exec sp_trace_setevent @TraceID, 153, 34, @on
exec sp_trace_setevent @TraceID, 153, 42, @on
exec sp_trace_setevent @TraceID, 153, 50, @on
exec sp_trace_setevent @TraceID, 153, 3, @on
exec sp_trace_setevent @TraceID, 153, 11, @on
exec sp_trace_setevent @TraceID, 153, 35, @on
exec sp_trace_setevent @TraceID, 153, 43, @on
exec sp_trace_setevent @TraceID, 153, 51, @on
exec sp_trace_setevent @TraceID, 153, 59, @on
exec sp_trace_setevent @TraceID, 153, 4, @on
exec sp_trace_setevent @TraceID, 153, 12, @on
exec sp_trace_setevent @TraceID, 153, 28, @on
exec sp_trace_setevent @TraceID, 153, 60, @on
exec sp_trace_setevent @TraceID, 153, 29, @on
exec sp_trace_setevent @TraceID, 153, 37, @on
exec sp_trace_setevent @TraceID, 153, 6, @on
exec sp_trace_setevent @TraceID, 153, 14, @on
exec sp_trace_setevent @TraceID, 175, 7, @on
exec sp_trace_setevent @TraceID, 175, 23, @on
exec sp_trace_setevent @TraceID, 175, 8, @on
exec sp_trace_setevent @TraceID, 175, 40, @on
exec sp_trace_setevent @TraceID, 175, 64, @on
exec sp_trace_setevent @TraceID, 175, 1, @on
exec sp_trace_setevent @TraceID, 175, 41, @on
exec sp_trace_setevent @TraceID, 175, 49, @on
exec sp_trace_setevent @TraceID, 175, 6, @on
exec sp_trace_setevent @TraceID, 175, 10, @on
exec sp_trace_setevent @TraceID, 175, 14, @on
exec sp_trace_setevent @TraceID, 175, 26, @on
exec sp_trace_setevent @TraceID, 175, 34, @on
exec sp_trace_setevent @TraceID, 175, 50, @on
exec sp_trace_setevent @TraceID, 175, 3, @on
exec sp_trace_setevent @TraceID, 175, 11, @on
exec sp_trace_setevent @TraceID, 175, 35, @on
exec sp_trace_setevent @TraceID, 175, 51, @on
exec sp_trace_setevent @TraceID, 175, 4, @on
exec sp_trace_setevent @TraceID, 175, 12, @on
exec sp_trace_setevent @TraceID, 175, 28, @on
exec sp_trace_setevent @TraceID, 175, 60, @on
exec sp_trace_setevent @TraceID, 175, 29, @on
exec sp_trace_setevent @TraceID, 175, 37, @on
exec sp_trace_setevent @TraceID, 171, 7, @on
exec sp_trace_setevent @TraceID, 171, 23, @on
exec sp_trace_setevent @TraceID, 171, 8, @on
exec sp_trace_setevent @TraceID, 171, 40, @on
exec sp_trace_setevent @TraceID, 171, 64, @on
exec sp_trace_setevent @TraceID, 171, 1, @on
exec sp_trace_setevent @TraceID, 171, 9, @on
exec sp_trace_setevent @TraceID, 171, 41, @on
exec sp_trace_setevent @TraceID, 171, 49, @on
exec sp_trace_setevent @TraceID, 171, 10, @on
exec sp_trace_setevent @TraceID, 171, 26, @on
exec sp_trace_setevent @TraceID, 171, 34, @on
exec sp_trace_setevent @TraceID, 171, 42, @on
exec sp_trace_setevent @TraceID, 171, 50, @on
exec sp_trace_setevent @TraceID, 171, 3, @on
exec sp_trace_setevent @TraceID, 171, 11, @on
exec sp_trace_setevent @TraceID, 171, 19, @on
exec sp_trace_setevent @TraceID, 171, 35, @on
exec sp_trace_setevent @TraceID, 171, 43, @on
exec sp_trace_setevent @TraceID, 171, 51, @on
exec sp_trace_setevent @TraceID, 171, 4, @on
exec sp_trace_setevent @TraceID, 171, 12, @on
exec sp_trace_setevent @TraceID, 171, 28, @on
exec sp_trace_setevent @TraceID, 171, 60, @on
exec sp_trace_setevent @TraceID, 171, 21, @on
exec sp_trace_setevent @TraceID, 171, 29, @on
exec sp_trace_setevent @TraceID, 171, 37, @on
exec sp_trace_setevent @TraceID, 171, 6, @on
exec sp_trace_setevent @TraceID, 171, 14, @on
exec sp_trace_setevent @TraceID, 176, 7, @on
exec sp_trace_setevent @TraceID, 176, 23, @on
exec sp_trace_setevent @TraceID, 176, 8, @on
exec sp_trace_setevent @TraceID, 176, 40, @on
exec sp_trace_setevent @TraceID, 176, 64, @on
exec sp_trace_setevent @TraceID, 176, 1, @on
exec sp_trace_setevent @TraceID, 176, 9, @on
exec sp_trace_setevent @TraceID, 176, 41, @on
exec sp_trace_setevent @TraceID, 176, 49, @on
exec sp_trace_setevent @TraceID, 176, 10, @on
exec sp_trace_setevent @TraceID, 176, 26, @on
exec sp_trace_setevent @TraceID, 176, 34, @on
exec sp_trace_setevent @TraceID, 176, 50, @on
exec sp_trace_setevent @TraceID, 176, 3, @on
exec sp_trace_setevent @TraceID, 176, 11, @on
exec sp_trace_setevent @TraceID, 176, 35, @on
exec sp_trace_setevent @TraceID, 176, 51, @on
exec sp_trace_setevent @TraceID, 176, 4, @on
exec sp_trace_setevent @TraceID, 176, 12, @on
exec sp_trace_setevent @TraceID, 176, 28, @on
exec sp_trace_setevent @TraceID, 176, 60, @on
exec sp_trace_setevent @TraceID, 176, 21, @on
exec sp_trace_setevent @TraceID, 176, 29, @on
exec sp_trace_setevent @TraceID, 176, 37, @on
exec sp_trace_setevent @TraceID, 176, 45, @on
exec sp_trace_setevent @TraceID, 176, 6, @on
exec sp_trace_setevent @TraceID, 176, 14, @on
exec sp_trace_setevent @TraceID, 176, 46, @on
exec sp_trace_setevent @TraceID, 134, 7, @on
exec sp_trace_setevent @TraceID, 134, 23, @on
exec sp_trace_setevent @TraceID, 134, 39, @on
exec sp_trace_setevent @TraceID, 134, 8, @on
exec sp_trace_setevent @TraceID, 134, 40, @on
exec sp_trace_setevent @TraceID, 134, 64, @on
exec sp_trace_setevent @TraceID, 134, 1, @on
exec sp_trace_setevent @TraceID, 134, 41, @on
exec sp_trace_setevent @TraceID, 134, 49, @on
exec sp_trace_setevent @TraceID, 134, 6, @on
exec sp_trace_setevent @TraceID, 134, 10, @on
exec sp_trace_setevent @TraceID, 134, 14, @on
exec sp_trace_setevent @TraceID, 134, 26, @on
exec sp_trace_setevent @TraceID, 134, 34, @on
exec sp_trace_setevent @TraceID, 134, 42, @on
exec sp_trace_setevent @TraceID, 134, 50, @on
exec sp_trace_setevent @TraceID, 134, 3, @on
exec sp_trace_setevent @TraceID, 134, 11, @on
exec sp_trace_setevent @TraceID, 134, 35, @on
exec sp_trace_setevent @TraceID, 134, 43, @on
exec sp_trace_setevent @TraceID, 134, 51, @on
exec sp_trace_setevent @TraceID, 134, 4, @on
exec sp_trace_setevent @TraceID, 134, 12, @on
exec sp_trace_setevent @TraceID, 134, 28, @on
exec sp_trace_setevent @TraceID, 134, 60, @on
exec sp_trace_setevent @TraceID, 134, 29, @on
exec sp_trace_setevent @TraceID, 134, 37, @on
exec sp_trace_setevent @TraceID, 173, 7, @on
exec sp_trace_setevent @TraceID, 173, 23, @on
exec sp_trace_setevent @TraceID, 173, 8, @on
exec sp_trace_setevent @TraceID, 173, 40, @on
exec sp_trace_setevent @TraceID, 173, 64, @on
exec sp_trace_setevent @TraceID, 173, 1, @on
exec sp_trace_setevent @TraceID, 173, 41, @on
exec sp_trace_setevent @TraceID, 173, 49, @on
exec sp_trace_setevent @TraceID, 173, 6, @on
exec sp_trace_setevent @TraceID, 173, 10, @on
exec sp_trace_setevent @TraceID, 173, 14, @on
exec sp_trace_setevent @TraceID, 173, 26, @on
exec sp_trace_setevent @TraceID, 173, 34, @on
exec sp_trace_setevent @TraceID, 173, 50, @on
exec sp_trace_setevent @TraceID, 173, 3, @on
exec sp_trace_setevent @TraceID, 173, 11, @on
exec sp_trace_setevent @TraceID, 173, 35, @on
exec sp_trace_setevent @TraceID, 173, 51, @on
exec sp_trace_setevent @TraceID, 173, 4, @on
exec sp_trace_setevent @TraceID, 173, 12, @on
exec sp_trace_setevent @TraceID, 173, 28, @on
exec sp_trace_setevent @TraceID, 173, 60, @on
exec sp_trace_setevent @TraceID, 173, 21, @on
exec sp_trace_setevent @TraceID, 173, 29, @on
exec sp_trace_setevent @TraceID, 173, 37, @on
exec sp_trace_setevent @TraceID, 132, 7, @on
exec sp_trace_setevent @TraceID, 132, 23, @on
exec sp_trace_setevent @TraceID, 132, 8, @on
exec sp_trace_setevent @TraceID, 132, 40, @on
exec sp_trace_setevent @TraceID, 132, 64, @on
exec sp_trace_setevent @TraceID, 132, 1, @on
exec sp_trace_setevent @TraceID, 132, 41, @on
exec sp_trace_setevent @TraceID, 132, 49, @on
exec sp_trace_setevent @TraceID, 132, 6, @on
exec sp_trace_setevent @TraceID, 132, 10, @on
exec sp_trace_setevent @TraceID, 132, 14, @on
exec sp_trace_setevent @TraceID, 132, 26, @on
exec sp_trace_setevent @TraceID, 132, 34, @on
exec sp_trace_setevent @TraceID, 132, 50, @on
exec sp_trace_setevent @TraceID, 132, 3, @on
exec sp_trace_setevent @TraceID, 132, 11, @on
exec sp_trace_setevent @TraceID, 132, 19, @on
exec sp_trace_setevent @TraceID, 132, 35, @on
exec sp_trace_setevent @TraceID, 132, 51, @on
exec sp_trace_setevent @TraceID, 132, 4, @on
exec sp_trace_setevent @TraceID, 132, 12, @on
exec sp_trace_setevent @TraceID, 132, 28, @on
exec sp_trace_setevent @TraceID, 132, 60, @on
exec sp_trace_setevent @TraceID, 132, 21, @on
exec sp_trace_setevent @TraceID, 132, 29, @on
exec sp_trace_setevent @TraceID, 132, 37, @on
exec sp_trace_setevent @TraceID, 177, 7, @on
exec sp_trace_setevent @TraceID, 177, 23, @on
exec sp_trace_setevent @TraceID, 177, 39, @on
exec sp_trace_setevent @TraceID, 177, 8, @on
exec sp_trace_setevent @TraceID, 177, 40, @on
exec sp_trace_setevent @TraceID, 177, 64, @on
exec sp_trace_setevent @TraceID, 177, 1, @on
exec sp_trace_setevent @TraceID, 177, 9, @on
exec sp_trace_setevent @TraceID, 177, 41, @on
exec sp_trace_setevent @TraceID, 177, 49, @on
exec sp_trace_setevent @TraceID, 177, 10, @on
exec sp_trace_setevent @TraceID, 177, 26, @on
exec sp_trace_setevent @TraceID, 177, 34, @on
exec sp_trace_setevent @TraceID, 177, 42, @on
exec sp_trace_setevent @TraceID, 177, 50, @on
exec sp_trace_setevent @TraceID, 177, 3, @on
exec sp_trace_setevent @TraceID, 177, 11, @on
exec sp_trace_setevent @TraceID, 177, 35, @on
exec sp_trace_setevent @TraceID, 177, 43, @on
exec sp_trace_setevent @TraceID, 177, 51, @on
exec sp_trace_setevent @TraceID, 177, 4, @on
exec sp_trace_setevent @TraceID, 177, 12, @on
exec sp_trace_setevent @TraceID, 177, 28, @on
exec sp_trace_setevent @TraceID, 177, 60, @on
exec sp_trace_setevent @TraceID, 177, 5, @on
exec sp_trace_setevent @TraceID, 177, 21, @on
exec sp_trace_setevent @TraceID, 177, 29, @on
exec sp_trace_setevent @TraceID, 177, 37, @on
exec sp_trace_setevent @TraceID, 177, 45, @on
exec sp_trace_setevent @TraceID, 177, 6, @on
exec sp_trace_setevent @TraceID, 177, 14, @on
exec sp_trace_setevent @TraceID, 170, 7, @on
exec sp_trace_setevent @TraceID, 170, 23, @on
exec sp_trace_setevent @TraceID, 170, 8, @on
exec sp_trace_setevent @TraceID, 170, 40, @on
exec sp_trace_setevent @TraceID, 170, 64, @on
exec sp_trace_setevent @TraceID, 170, 1, @on
exec sp_trace_setevent @TraceID, 170, 9, @on
exec sp_trace_setevent @TraceID, 170, 41, @on
exec sp_trace_setevent @TraceID, 170, 49, @on
exec sp_trace_setevent @TraceID, 170, 10, @on
exec sp_trace_setevent @TraceID, 170, 26, @on
exec sp_trace_setevent @TraceID, 170, 34, @on
exec sp_trace_setevent @TraceID, 170, 42, @on
exec sp_trace_setevent @TraceID, 170, 50, @on
exec sp_trace_setevent @TraceID, 170, 3, @on
exec sp_trace_setevent @TraceID, 170, 11, @on
exec sp_trace_setevent @TraceID, 170, 19, @on
exec sp_trace_setevent @TraceID, 170, 35, @on
exec sp_trace_setevent @TraceID, 170, 43, @on
exec sp_trace_setevent @TraceID, 170, 51, @on
exec sp_trace_setevent @TraceID, 170, 4, @on
exec sp_trace_setevent @TraceID, 170, 12, @on
exec sp_trace_setevent @TraceID, 170, 28, @on
exec sp_trace_setevent @TraceID, 170, 60, @on
exec sp_trace_setevent @TraceID, 170, 21, @on
exec sp_trace_setevent @TraceID, 170, 29, @on
exec sp_trace_setevent @TraceID, 170, 37, @on
exec sp_trace_setevent @TraceID, 170, 6, @on
exec sp_trace_setevent @TraceID, 170, 14, @on
exec sp_trace_setevent @TraceID, 18, 7, @on
exec sp_trace_setevent @TraceID, 18, 23, @on
exec sp_trace_setevent @TraceID, 18, 8, @on
exec sp_trace_setevent @TraceID, 18, 12, @on
exec sp_trace_setevent @TraceID, 18, 60, @on
exec sp_trace_setevent @TraceID, 18, 64, @on
exec sp_trace_setevent @TraceID, 18, 9, @on
exec sp_trace_setevent @TraceID, 18, 21, @on
exec sp_trace_setevent @TraceID, 18, 41, @on
exec sp_trace_setevent @TraceID, 18, 49, @on
exec sp_trace_setevent @TraceID, 18, 6, @on
exec sp_trace_setevent @TraceID, 18, 10, @on
exec sp_trace_setevent @TraceID, 18, 14, @on
exec sp_trace_setevent @TraceID, 18, 26, @on
exec sp_trace_setevent @TraceID, 18, 11, @on
exec sp_trace_setevent @TraceID, 18, 51, @on
exec sp_trace_setevent @TraceID, 113, 7, @on
exec sp_trace_setevent @TraceID, 113, 23, @on
exec sp_trace_setevent @TraceID, 113, 8, @on
exec sp_trace_setevent @TraceID, 113, 40, @on
exec sp_trace_setevent @TraceID, 113, 64, @on
exec sp_trace_setevent @TraceID, 113, 1, @on
exec sp_trace_setevent @TraceID, 113, 9, @on
exec sp_trace_setevent @TraceID, 113, 41, @on
exec sp_trace_setevent @TraceID, 113, 49, @on
exec sp_trace_setevent @TraceID, 113, 6, @on
exec sp_trace_setevent @TraceID, 113, 10, @on
exec sp_trace_setevent @TraceID, 113, 14, @on
exec sp_trace_setevent @TraceID, 113, 26, @on
exec sp_trace_setevent @TraceID, 113, 50, @on
exec sp_trace_setevent @TraceID, 113, 3, @on
exec sp_trace_setevent @TraceID, 113, 11, @on
exec sp_trace_setevent @TraceID, 113, 19, @on
exec sp_trace_setevent @TraceID, 113, 35, @on
exec sp_trace_setevent @TraceID, 113, 51, @on
exec sp_trace_setevent @TraceID, 113, 4, @on
exec sp_trace_setevent @TraceID, 113, 12, @on
exec sp_trace_setevent @TraceID, 113, 28, @on
exec sp_trace_setevent @TraceID, 113, 60, @on
exec sp_trace_setevent @TraceID, 113, 5, @on
exec sp_trace_setevent @TraceID, 113, 21, @on
exec sp_trace_setevent @TraceID, 113, 29, @on
exec sp_trace_setevent @TraceID, 17, 7, @on
exec sp_trace_setevent @TraceID, 17, 55, @on
exec sp_trace_setevent @TraceID, 17, 8, @on
exec sp_trace_setevent @TraceID, 17, 64, @on
exec sp_trace_setevent @TraceID, 17, 1, @on
exec sp_trace_setevent @TraceID, 17, 9, @on
exec sp_trace_setevent @TraceID, 17, 25, @on
exec sp_trace_setevent @TraceID, 17, 41, @on
exec sp_trace_setevent @TraceID, 17, 49, @on
exec sp_trace_setevent @TraceID, 17, 2, @on
exec sp_trace_setevent @TraceID, 17, 6, @on
exec sp_trace_setevent @TraceID, 17, 10, @on
exec sp_trace_setevent @TraceID, 17, 14, @on
exec sp_trace_setevent @TraceID, 17, 26, @on
exec sp_trace_setevent @TraceID, 17, 66, @on
exec sp_trace_setevent @TraceID, 17, 3, @on
exec sp_trace_setevent @TraceID, 17, 11, @on
exec sp_trace_setevent @TraceID, 17, 35, @on
exec sp_trace_setevent @TraceID, 17, 51, @on
exec sp_trace_setevent @TraceID, 17, 12, @on
exec sp_trace_setevent @TraceID, 17, 60, @on


-- Set the Filters
declare @intfilter int
declare @bigintfilter bigint

exec sp_trace_setfilter @TraceID, 1, 0, 1, NULL
exec sp_trace_setfilter @TraceID, 2, 0, 1, NULL
set @intfilter = NULL
exec sp_trace_setfilter @TraceID, 3, 0, 1, @intfilter

set @bigintfilter = NULL
exec sp_trace_setfilter @TraceID, 4, 0, 1, @bigintfilter

set @intfilter = NULL
exec sp_trace_setfilter @TraceID, 5, 0, 1, @intfilter

exec sp_trace_setfilter @TraceID, 6, 0, 1, NULL
exec sp_trace_setfilter @TraceID, 7, 0, 1, NULL
exec sp_trace_setfilter @TraceID, 8, 0, 1, NULL
set @intfilter = NULL
exec sp_trace_setfilter @TraceID, 9, 0, 1, @intfilter

exec sp_trace_setfilter @TraceID, 10, 0, 1, NULL
exec sp_trace_setfilter @TraceID, 10, 0, 7, N'SQL Server Profiler - 741bcb15-00a8-4f78-b358-bddda447cfe8'
exec sp_trace_setfilter @TraceID, 11, 0, 1, NULL
set @intfilter = NULL
exec sp_trace_setfilter @TraceID, 12, 0, 1, @intfilter

set @bigintfilter = NULL
exec sp_trace_setfilter @TraceID, 13, 0, 1, @bigintfilter

declare @DateTime datetime

set @DateTime = NULL
exec sp_trace_setfilter @TraceID, 14, 0, 1, @DateTime

set @DateTime = NULL
exec sp_trace_setfilter @TraceID, 15, 0, 1, @DateTime

set @bigintfilter = NULL
exec sp_trace_setfilter @TraceID, 16, 0, 1, @bigintfilter

set @bigintfilter = NULL
exec sp_trace_setfilter @TraceID, 17, 0, 1, @bigintfilter

set @bigintfilter = NULL
exec sp_trace_setfilter @TraceID, 19, 0, 1, @bigintfilter

set @intfilter = NULL
exec sp_trace_setfilter @TraceID, 21, 0, 1, @intfilter

set @intfilter = NULL
exec sp_trace_setfilter @TraceID, 22, 0, 1, @intfilter

set @intfilter = NULL
exec sp_trace_setfilter @TraceID, 23, 0, 1, @intfilter

set @intfilter = NULL
exec sp_trace_setfilter @TraceID, 24, 0, 1, @intfilter

set @intfilter = NULL
exec sp_trace_setfilter @TraceID, 25, 0, 1, @intfilter

set @intfilter = NULL
exec sp_trace_setfilter @TraceID, 28, 0, 1, @intfilter

set @intfilter = NULL
exec sp_trace_setfilter @TraceID, 29, 0, 1, @intfilter

set @intfilter = NULL
exec sp_trace_setfilter @TraceID, 30, 0, 1, @intfilter

set @intfilter = NULL
exec sp_trace_setfilter @TraceID, 31, 0, 1, @intfilter

exec sp_trace_setfilter @TraceID, 34, 0, 1, NULL
exec sp_trace_setfilter @TraceID, 35, 0, 1, NULL
exec sp_trace_setfilter @TraceID, 36, 0, 1, NULL
exec sp_trace_setfilter @TraceID, 37, 0, 1, NULL
exec sp_trace_setfilter @TraceID, 38, 0, 1, NULL
exec sp_trace_setfilter @TraceID, 39, 0, 1, NULL
exec sp_trace_setfilter @TraceID, 40, 0, 1, NULL
exec sp_trace_setfilter @TraceID, 41, 0, 1, NULL
exec sp_trace_setfilter @TraceID, 42, 0, 1, NULL
exec sp_trace_setfilter @TraceID, 43, 0, 1, NULL
set @intfilter = NULL
exec sp_trace_setfilter @TraceID, 44, 0, 1, @intfilter

exec sp_trace_setfilter @TraceID, 45, 0, 1, NULL
exec sp_trace_setfilter @TraceID, 46, 0, 1, NULL
set @intfilter = NULL
exec sp_trace_setfilter @TraceID, 49, 0, 1, @intfilter

set @bigintfilter = NULL
exec sp_trace_setfilter @TraceID, 50, 0, 1, @bigintfilter

set @bigintfilter = NULL
exec sp_trace_setfilter @TraceID, 52, 0, 1, @bigintfilter

set @intfilter = NULL
exec sp_trace_setfilter @TraceID, 55, 0, 1, @intfilter

set @bigintfilter = NULL
exec sp_trace_setfilter @TraceID, 56, 0, 1, @bigintfilter

set @intfilter = NULL
exec sp_trace_setfilter @TraceID, 57, 0, 1, @intfilter

exec sp_trace_setfilter @TraceID, 59, 0, 1, NULL
set @intfilter = NULL
exec sp_trace_setfilter @TraceID, 60, 0, 1, @intfilter

exec sp_trace_setfilter @TraceID, 64, 0, 1, NULL
set @intfilter = NULL
exec sp_trace_setfilter @TraceID, 66, 0, 1, @intfilter

-- Set the trace status to start
exec sp_trace_setstatus @TraceID, 1

-- display trace id for future references
select TraceID=@TraceID
goto finish


finish:
go





USE master
CREATE PROCEDURE usp_secaudit AS
BEGIN
... put code here
END;

EXEC sp_procoption N’usp_secaudit, ’startup’, ’on’
Lynn Pettis
Lynn Pettis
SSC Guru
SSC Guru (89K reputation)SSC Guru (89K reputation)SSC Guru (89K reputation)SSC Guru (89K reputation)SSC Guru (89K reputation)SSC Guru (89K reputation)SSC Guru (89K reputation)SSC Guru (89K reputation)

Group: General Forum Members
Points: 89738 Visits: 38935
Lot of data, no information. What error are you getting?

Cool
Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Elisabeth Rédei
Elisabeth Rédei
SSC Eights!
SSC Eights! (851 reputation)SSC Eights! (851 reputation)SSC Eights! (851 reputation)SSC Eights! (851 reputation)SSC Eights! (851 reputation)SSC Eights! (851 reputation)SSC Eights! (851 reputation)SSC Eights! (851 reputation)

Group: General Forum Members
Points: 851 Visits: 788
That's odd, it works for me. So what error message do you get?

/Elisabeth

elisabeth@sqlserverland.com
MCITP | MCT
http://sqlblog.com/blogs/elisabeth_redei/
http://linkedin.com/in/elisabethredei
ian howard
ian howard
Valued Member
Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)

Group: General Forum Members
Points: 58 Visits: 5
Thank you for the assistance

my query window shows
Msg 102, Level 15, State 1, Line 9
Incorrect syntax near '’'.
Msg 102, Level 15, State 1, Line 11
Incorrect syntax near '’'.

and completed with errors at the bottom
ian howard
ian howard
Valued Member
Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)

Group: General Forum Members
Points: 58 Visits: 5
The code is my mish mash of exporting the TSQL of a template I created and then trying to add the instance name and file rollover etc. Is the filter for SQL profiler machine specific and do I leave what looks like a GUID off to be able to port it to other SQL servers?
Elisabeth Rédei
Elisabeth Rédei
SSC Eights!
SSC Eights! (851 reputation)SSC Eights! (851 reputation)SSC Eights! (851 reputation)SSC Eights! (851 reputation)SSC Eights! (851 reputation)SSC Eights! (851 reputation)SSC Eights! (851 reputation)SSC Eights! (851 reputation)

Group: General Forum Members
Points: 851 Visits: 788
Hi Ian,

Then it is probably your quotifyers; I did change them (to ') but thought they got wrong because I C/Ped the code from the browser and wasn't really paying attention how the source looked like.

HTH!

/Elisabeth

elisabeth@sqlserverland.com
MCITP | MCT
http://sqlblog.com/blogs/elisabeth_redei/
http://linkedin.com/in/elisabethredei
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search