November 7, 2008 at 2:47 pm
: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’
November 7, 2008 at 2:57 pm
Lot of data, no information. What error are you getting?
November 7, 2008 at 3:09 pm
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
November 7, 2008 at 3:18 pm
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
November 7, 2008 at 3:27 pm
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?
November 8, 2008 at 6:48 am
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy