sp_trace_create TSQL Newbie

  • :crazy::crazy:Can 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’

  • Lot of data, no information. What error are you getting?

  • 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

  • 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

  • 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?

  • 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

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply