Monday, April 12, 2010

TimeTable schools_2006 _server_side_trace_file

SQL Server 2005 generates trace events in various event categories

http://publib.boulder.ibm.com/infocenter/tivihelp/v2r1/index.jsp?topic=/com.ibm.itcim.doc/tcim85_install407.html


/****************************************************/
/* Created by: SQL Server Profiler 2005 */
/* Date: 04/12/2010 02:09:55 PM */
/****************************************************/


-- Create a Queue
declare @rc int
declare @TraceID int
declare @maxfilesize bigint
set @maxfilesize = 5

-- Please replace the text InsertFileNameHere, with an appropriate
-- filename prefixed by a path, e.g., c:\MyFolder\MyTrace. 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 @rc = sp_trace_create @TraceID output, 2, N'd:\temp\timetableUWS_schools2006', @maxfilesize, NULL
if (@rc != 0) goto error

-- Client side File and Table cannot be scripted

-- Set the events
declare @on bit
set @on = 1
exec sp_trace_setevent @TraceID, 14, 1, @on
exec sp_trace_setevent @TraceID, 14, 9, @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, 11, @on
exec sp_trace_setevent @TraceID, 14, 12, @on
exec sp_trace_setevent @TraceID, 15, 15, @on
exec sp_trace_setevent @TraceID, 15, 16, @on
exec sp_trace_setevent @TraceID, 15, 9, @on
exec sp_trace_setevent @TraceID, 15, 13, @on
exec sp_trace_setevent @TraceID, 15, 17, @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, 18, @on
exec sp_trace_setevent @TraceID, 15, 11, @on
exec sp_trace_setevent @TraceID, 15, 12, @on
exec sp_trace_setevent @TraceID, 17, 12, @on
exec sp_trace_setevent @TraceID, 17, 1, @on
exec sp_trace_setevent @TraceID, 17, 9, @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, 11, @on
exec sp_trace_setevent @TraceID, 39, 12, @on
exec sp_trace_setevent @TraceID, 39, 64, @on
exec sp_trace_setevent @TraceID, 100, 7, @on
exec sp_trace_setevent @TraceID, 100, 8, @on
exec sp_trace_setevent @TraceID, 100, 64, @on
exec sp_trace_setevent @TraceID, 100, 1, @on
exec sp_trace_setevent @TraceID, 100, 9, @on
exec sp_trace_setevent @TraceID, 100, 41, @on
exec sp_trace_setevent @TraceID, 100, 49, @on
exec sp_trace_setevent @TraceID, 100, 6, @on
exec sp_trace_setevent @TraceID, 100, 10, @on
exec sp_trace_setevent @TraceID, 100, 14, @on
exec sp_trace_setevent @TraceID, 100, 26, @on
exec sp_trace_setevent @TraceID, 100, 34, @on
exec sp_trace_setevent @TraceID, 100, 50, @on
exec sp_trace_setevent @TraceID, 100, 3, @on
exec sp_trace_setevent @TraceID, 100, 11, @on
exec sp_trace_setevent @TraceID, 100, 35, @on
exec sp_trace_setevent @TraceID, 100, 51, @on
exec sp_trace_setevent @TraceID, 100, 4, @on
exec sp_trace_setevent @TraceID, 100, 12, @on
exec sp_trace_setevent @TraceID, 100, 60, @on
exec sp_trace_setevent @TraceID, 10, 15, @on
exec sp_trace_setevent @TraceID, 10, 16, @on
exec sp_trace_setevent @TraceID, 10, 9, @on
exec sp_trace_setevent @TraceID, 10, 17, @on
exec sp_trace_setevent @TraceID, 10, 2, @on
exec sp_trace_setevent @TraceID, 10, 10, @on
exec sp_trace_setevent @TraceID, 10, 18, @on
exec sp_trace_setevent @TraceID, 10, 11, @on
exec sp_trace_setevent @TraceID, 10, 12, @on
exec sp_trace_setevent @TraceID, 10, 13, @on
exec sp_trace_setevent @TraceID, 10, 6, @on
exec sp_trace_setevent @TraceID, 10, 14, @on
exec sp_trace_setevent @TraceID, 11, 7, @on
exec sp_trace_setevent @TraceID, 11, 8, @on
exec sp_trace_setevent @TraceID, 11, 64, @on
exec sp_trace_setevent @TraceID, 11, 1, @on
exec sp_trace_setevent @TraceID, 11, 9, @on
exec sp_trace_setevent @TraceID, 11, 41, @on
exec sp_trace_setevent @TraceID, 11, 49, @on
exec sp_trace_setevent @TraceID, 11, 2, @on
exec sp_trace_setevent @TraceID, 11, 6, @on
exec sp_trace_setevent @TraceID, 11, 10, @on
exec sp_trace_setevent @TraceID, 11, 14, @on
exec sp_trace_setevent @TraceID, 11, 26, @on
exec sp_trace_setevent @TraceID, 11, 34, @on
exec sp_trace_setevent @TraceID, 11, 50, @on
exec sp_trace_setevent @TraceID, 11, 3, @on
exec sp_trace_setevent @TraceID, 11, 11, @on
exec sp_trace_setevent @TraceID, 11, 35, @on
exec sp_trace_setevent @TraceID, 11, 51, @on
exec sp_trace_setevent @TraceID, 11, 4, @on
exec sp_trace_setevent @TraceID, 11, 12, @on
exec sp_trace_setevent @TraceID, 11, 60, @on
exec sp_trace_setevent @TraceID, 38, 7, @on
exec sp_trace_setevent @TraceID, 38, 8, @on
exec sp_trace_setevent @TraceID, 38, 64, @on
exec sp_trace_setevent @TraceID, 38, 1, @on
exec sp_trace_setevent @TraceID, 38, 9, @on
exec sp_trace_setevent @TraceID, 38, 21, @on
exec sp_trace_setevent @TraceID, 38, 41, @on
exec sp_trace_setevent @TraceID, 38, 49, @on
exec sp_trace_setevent @TraceID, 38, 6, @on
exec sp_trace_setevent @TraceID, 38, 10, @on
exec sp_trace_setevent @TraceID, 38, 14, @on
exec sp_trace_setevent @TraceID, 38, 22, @on
exec sp_trace_setevent @TraceID, 38, 26, @on
exec sp_trace_setevent @TraceID, 38, 34, @on
exec sp_trace_setevent @TraceID, 38, 50, @on
exec sp_trace_setevent @TraceID, 38, 3, @on
exec sp_trace_setevent @TraceID, 38, 11, @on
exec sp_trace_setevent @TraceID, 38, 35, @on
exec sp_trace_setevent @TraceID, 38, 51, @on
exec sp_trace_setevent @TraceID, 38, 4, @on
exec sp_trace_setevent @TraceID, 38, 12, @on
exec sp_trace_setevent @TraceID, 38, 28, @on
exec sp_trace_setevent @TraceID, 38, 60, @on
exec sp_trace_setevent @TraceID, 35, 7, @on
exec sp_trace_setevent @TraceID, 35, 8, @on
exec sp_trace_setevent @TraceID, 35, 64, @on
exec sp_trace_setevent @TraceID, 35, 1, @on
exec sp_trace_setevent @TraceID, 35, 9, @on
exec sp_trace_setevent @TraceID, 35, 41, @on
exec sp_trace_setevent @TraceID, 35, 49, @on
exec sp_trace_setevent @TraceID, 35, 6, @on
exec sp_trace_setevent @TraceID, 35, 10, @on
exec sp_trace_setevent @TraceID, 35, 14, @on
exec sp_trace_setevent @TraceID, 35, 22, @on
exec sp_trace_setevent @TraceID, 35, 26, @on
exec sp_trace_setevent @TraceID, 35, 50, @on
exec sp_trace_setevent @TraceID, 35, 3, @on
exec sp_trace_setevent @TraceID, 35, 11, @on
exec sp_trace_setevent @TraceID, 35, 35, @on
exec sp_trace_setevent @TraceID, 35, 51, @on
exec sp_trace_setevent @TraceID, 35, 4, @on
exec sp_trace_setevent @TraceID, 35, 12, @on
exec sp_trace_setevent @TraceID, 35, 28, @on
exec sp_trace_setevent @TraceID, 35, 60, @on
exec sp_trace_setevent @TraceID, 34, 7, @on
exec sp_trace_setevent @TraceID, 34, 8, @on
exec sp_trace_setevent @TraceID, 34, 64, @on
exec sp_trace_setevent @TraceID, 34, 1, @on
exec sp_trace_setevent @TraceID, 34, 9, @on
exec sp_trace_setevent @TraceID, 34, 41, @on
exec sp_trace_setevent @TraceID, 34, 49, @on
exec sp_trace_setevent @TraceID, 34, 6, @on
exec sp_trace_setevent @TraceID, 34, 10, @on
exec sp_trace_setevent @TraceID, 34, 14, @on
exec sp_trace_setevent @TraceID, 34, 22, @on
exec sp_trace_setevent @TraceID, 34, 26, @on
exec sp_trace_setevent @TraceID, 34, 34, @on
exec sp_trace_setevent @TraceID, 34, 50, @on
exec sp_trace_setevent @TraceID, 34, 3, @on
exec sp_trace_setevent @TraceID, 34, 11, @on
exec sp_trace_setevent @TraceID, 34, 51, @on
exec sp_trace_setevent @TraceID, 34, 4, @on
exec sp_trace_setevent @TraceID, 34, 12, @on
exec sp_trace_setevent @TraceID, 34, 28, @on
exec sp_trace_setevent @TraceID, 34, 60, @on
exec sp_trace_setevent @TraceID, 36, 7, @on
exec sp_trace_setevent @TraceID, 36, 8, @on
exec sp_trace_setevent @TraceID, 36, 64, @on
exec sp_trace_setevent @TraceID, 36, 1, @on
exec sp_trace_setevent @TraceID, 36, 9, @on
exec sp_trace_setevent @TraceID, 36, 21, @on
exec sp_trace_setevent @TraceID, 36, 41, @on
exec sp_trace_setevent @TraceID, 36, 49, @on
exec sp_trace_setevent @TraceID, 36, 6, @on
exec sp_trace_setevent @TraceID, 36, 10, @on
exec sp_trace_setevent @TraceID, 36, 14, @on
exec sp_trace_setevent @TraceID, 36, 22, @on
exec sp_trace_setevent @TraceID, 36, 26, @on
exec sp_trace_setevent @TraceID, 36, 50, @on
exec sp_trace_setevent @TraceID, 36, 3, @on
exec sp_trace_setevent @TraceID, 36, 11, @on
exec sp_trace_setevent @TraceID, 36, 35, @on
exec sp_trace_setevent @TraceID, 36, 51, @on
exec sp_trace_setevent @TraceID, 36, 4, @on
exec sp_trace_setevent @TraceID, 36, 12, @on
exec sp_trace_setevent @TraceID, 36, 28, @on
exec sp_trace_setevent @TraceID, 36, 60, @on
exec sp_trace_setevent @TraceID, 43, 7, @on
exec sp_trace_setevent @TraceID, 43, 15, @on
exec sp_trace_setevent @TraceID, 43, 8, @on
exec sp_trace_setevent @TraceID, 43, 48, @on
exec sp_trace_setevent @TraceID, 43, 64, @on
exec sp_trace_setevent @TraceID, 43, 1, @on
exec sp_trace_setevent @TraceID, 43, 9, @on
exec sp_trace_setevent @TraceID, 43, 41, @on
exec sp_trace_setevent @TraceID, 43, 49, @on
exec sp_trace_setevent @TraceID, 43, 2, @on
exec sp_trace_setevent @TraceID, 43, 10, @on
exec sp_trace_setevent @TraceID, 43, 26, @on
exec sp_trace_setevent @TraceID, 43, 34, @on
exec sp_trace_setevent @TraceID, 43, 50, @on
exec sp_trace_setevent @TraceID, 43, 3, @on
exec sp_trace_setevent @TraceID, 43, 11, @on
exec sp_trace_setevent @TraceID, 43, 35, @on
exec sp_trace_setevent @TraceID, 43, 51, @on
exec sp_trace_setevent @TraceID, 43, 4, @on
exec sp_trace_setevent @TraceID, 43, 12, @on
exec sp_trace_setevent @TraceID, 43, 28, @on
exec sp_trace_setevent @TraceID, 43, 60, @on
exec sp_trace_setevent @TraceID, 43, 5, @on
exec sp_trace_setevent @TraceID, 43, 13, @on
exec sp_trace_setevent @TraceID, 43, 29, @on
exec sp_trace_setevent @TraceID, 43, 6, @on
exec sp_trace_setevent @TraceID, 43, 14, @on
exec sp_trace_setevent @TraceID, 43, 22, @on
exec sp_trace_setevent @TraceID, 43, 62, @on
exec sp_trace_setevent @TraceID, 37, 7, @on
exec sp_trace_setevent @TraceID, 37, 55, @on
exec sp_trace_setevent @TraceID, 37, 63, @on
exec sp_trace_setevent @TraceID, 37, 8, @on
exec sp_trace_setevent @TraceID, 37, 64, @on
exec sp_trace_setevent @TraceID, 37, 1, @on
exec sp_trace_setevent @TraceID, 37, 9, @on
exec sp_trace_setevent @TraceID, 37, 41, @on
exec sp_trace_setevent @TraceID, 37, 49, @on
exec sp_trace_setevent @TraceID, 37, 10, @on
exec sp_trace_setevent @TraceID, 37, 26, @on
exec sp_trace_setevent @TraceID, 37, 34, @on
exec sp_trace_setevent @TraceID, 37, 50, @on
exec sp_trace_setevent @TraceID, 37, 3, @on
exec sp_trace_setevent @TraceID, 37, 11, @on
exec sp_trace_setevent @TraceID, 37, 35, @on
exec sp_trace_setevent @TraceID, 37, 51, @on
exec sp_trace_setevent @TraceID, 37, 4, @on
exec sp_trace_setevent @TraceID, 37, 12, @on
exec sp_trace_setevent @TraceID, 37, 28, @on
exec sp_trace_setevent @TraceID, 37, 60, @on
exec sp_trace_setevent @TraceID, 37, 5, @on
exec sp_trace_setevent @TraceID, 37, 21, @on
exec sp_trace_setevent @TraceID, 37, 29, @on
exec sp_trace_setevent @TraceID, 37, 61, @on
exec sp_trace_setevent @TraceID, 37, 6, @on
exec sp_trace_setevent @TraceID, 37, 14, @on
exec sp_trace_setevent @TraceID, 37, 22, @on
exec sp_trace_setevent @TraceID, 42, 7, @on
exec sp_trace_setevent @TraceID, 42, 8, @on
exec sp_trace_setevent @TraceID, 42, 64, @on
exec sp_trace_setevent @TraceID, 42, 1, @on
exec sp_trace_setevent @TraceID, 42, 9, @on
exec sp_trace_setevent @TraceID, 42, 41, @on
exec sp_trace_setevent @TraceID, 42, 49, @on
exec sp_trace_setevent @TraceID, 42, 2, @on
exec sp_trace_setevent @TraceID, 42, 6, @on
exec sp_trace_setevent @TraceID, 42, 10, @on
exec sp_trace_setevent @TraceID, 42, 14, @on
exec sp_trace_setevent @TraceID, 42, 22, @on
exec sp_trace_setevent @TraceID, 42, 26, @on
exec sp_trace_setevent @TraceID, 42, 34, @on
exec sp_trace_setevent @TraceID, 42, 50, @on
exec sp_trace_setevent @TraceID, 42, 62, @on
exec sp_trace_setevent @TraceID, 42, 3, @on
exec sp_trace_setevent @TraceID, 42, 11, @on
exec sp_trace_setevent @TraceID, 42, 35, @on
exec sp_trace_setevent @TraceID, 42, 51, @on
exec sp_trace_setevent @TraceID, 42, 4, @on
exec sp_trace_setevent @TraceID, 42, 12, @on
exec sp_trace_setevent @TraceID, 42, 28, @on
exec sp_trace_setevent @TraceID, 42, 60, @on
exec sp_trace_setevent @TraceID, 42, 5, @on
exec sp_trace_setevent @TraceID, 42, 29, @on
exec sp_trace_setevent @TraceID, 45, 7, @on
exec sp_trace_setevent @TraceID, 45, 55, @on
exec sp_trace_setevent @TraceID, 45, 8, @on
exec sp_trace_setevent @TraceID, 45, 16, @on
exec sp_trace_setevent @TraceID, 45, 48, @on
exec sp_trace_setevent @TraceID, 45, 64, @on
exec sp_trace_setevent @TraceID, 45, 1, @on
exec sp_trace_setevent @TraceID, 45, 9, @on
exec sp_trace_setevent @TraceID, 45, 17, @on
exec sp_trace_setevent @TraceID, 45, 25, @on
exec sp_trace_setevent @TraceID, 45, 41, @on
exec sp_trace_setevent @TraceID, 45, 49, @on
exec sp_trace_setevent @TraceID, 45, 10, @on
exec sp_trace_setevent @TraceID, 45, 18, @on
exec sp_trace_setevent @TraceID, 45, 26, @on
exec sp_trace_setevent @TraceID, 45, 34, @on
exec sp_trace_setevent @TraceID, 45, 50, @on
exec sp_trace_setevent @TraceID, 45, 3, @on
exec sp_trace_setevent @TraceID, 45, 11, @on
exec sp_trace_setevent @TraceID, 45, 35, @on
exec sp_trace_setevent @TraceID, 45, 51, @on
exec sp_trace_setevent @TraceID, 45, 4, @on
exec sp_trace_setevent @TraceID, 45, 12, @on
exec sp_trace_setevent @TraceID, 45, 28, @on
exec sp_trace_setevent @TraceID, 45, 60, @on
exec sp_trace_setevent @TraceID, 45, 5, @on
exec sp_trace_setevent @TraceID, 45, 13, @on
exec sp_trace_setevent @TraceID, 45, 29, @on
exec sp_trace_setevent @TraceID, 45, 61, @on
exec sp_trace_setevent @TraceID, 45, 6, @on
exec sp_trace_setevent @TraceID, 45, 14, @on
exec sp_trace_setevent @TraceID, 45, 22, @on
exec sp_trace_setevent @TraceID, 45, 62, @on
exec sp_trace_setevent @TraceID, 45, 15, @on
exec sp_trace_setevent @TraceID, 44, 7, @on
exec sp_trace_setevent @TraceID, 44, 55, @on
exec sp_trace_setevent @TraceID, 44, 8, @on
exec sp_trace_setevent @TraceID, 44, 64, @on
exec sp_trace_setevent @TraceID, 44, 1, @on
exec sp_trace_setevent @TraceID, 44, 9, @on
exec sp_trace_setevent @TraceID, 44, 41, @on
exec sp_trace_setevent @TraceID, 44, 49, @on
exec sp_trace_setevent @TraceID, 44, 10, @on
exec sp_trace_setevent @TraceID, 44, 26, @on
exec sp_trace_setevent @TraceID, 44, 34, @on
exec sp_trace_setevent @TraceID, 44, 50, @on
exec sp_trace_setevent @TraceID, 44, 3, @on
exec sp_trace_setevent @TraceID, 44, 11, @on
exec sp_trace_setevent @TraceID, 44, 35, @on
exec sp_trace_setevent @TraceID, 44, 51, @on
exec sp_trace_setevent @TraceID, 44, 4, @on
exec sp_trace_setevent @TraceID, 44, 12, @on
exec sp_trace_setevent @TraceID, 44, 28, @on
exec sp_trace_setevent @TraceID, 44, 60, @on
exec sp_trace_setevent @TraceID, 44, 5, @on
exec sp_trace_setevent @TraceID, 44, 29, @on
exec sp_trace_setevent @TraceID, 44, 61, @on
exec sp_trace_setevent @TraceID, 44, 6, @on
exec sp_trace_setevent @TraceID, 44, 14, @on
exec sp_trace_setevent @TraceID, 44, 22, @on
exec sp_trace_setevent @TraceID, 44, 30, @on
exec sp_trace_setevent @TraceID, 44, 62, @on
exec sp_trace_setevent @TraceID, 72, 7, @on
exec sp_trace_setevent @TraceID, 72, 4, @on
exec sp_trace_setevent @TraceID, 72, 8, @on
exec sp_trace_setevent @TraceID, 72, 12, @on
exec sp_trace_setevent @TraceID, 72, 60, @on
exec sp_trace_setevent @TraceID, 72, 64, @on
exec sp_trace_setevent @TraceID, 72, 9, @on
exec sp_trace_setevent @TraceID, 72, 33, @on
exec sp_trace_setevent @TraceID, 72, 41, @on
exec sp_trace_setevent @TraceID, 72, 49, @on
exec sp_trace_setevent @TraceID, 72, 6, @on
exec sp_trace_setevent @TraceID, 72, 10, @on
exec sp_trace_setevent @TraceID, 72, 14, @on
exec sp_trace_setevent @TraceID, 72, 26, @on
exec sp_trace_setevent @TraceID, 72, 50, @on
exec sp_trace_setevent @TraceID, 72, 3, @on
exec sp_trace_setevent @TraceID, 72, 11, @on
exec sp_trace_setevent @TraceID, 72, 35, @on
exec sp_trace_setevent @TraceID, 72, 51, @on
exec sp_trace_setevent @TraceID, 71, 7, @on
exec sp_trace_setevent @TraceID, 71, 4, @on
exec sp_trace_setevent @TraceID, 71, 8, @on
exec sp_trace_setevent @TraceID, 71, 12, @on
exec sp_trace_setevent @TraceID, 71, 60, @on
exec sp_trace_setevent @TraceID, 71, 64, @on
exec sp_trace_setevent @TraceID, 71, 9, @on
exec sp_trace_setevent @TraceID, 71, 33, @on
exec sp_trace_setevent @TraceID, 71, 41, @on
exec sp_trace_setevent @TraceID, 71, 49, @on
exec sp_trace_setevent @TraceID, 71, 6, @on
exec sp_trace_setevent @TraceID, 71, 10, @on
exec sp_trace_setevent @TraceID, 71, 14, @on
exec sp_trace_setevent @TraceID, 71, 26, @on
exec sp_trace_setevent @TraceID, 71, 50, @on
exec sp_trace_setevent @TraceID, 71, 3, @on
exec sp_trace_setevent @TraceID, 71, 11, @on
exec sp_trace_setevent @TraceID, 71, 35, @on
exec sp_trace_setevent @TraceID, 71, 51, @on
exec sp_trace_setevent @TraceID, 12, 15, @on
exec sp_trace_setevent @TraceID, 12, 16, @on
exec sp_trace_setevent @TraceID, 12, 1, @on
exec sp_trace_setevent @TraceID, 12, 9, @on
exec sp_trace_setevent @TraceID, 12, 17, @on
exec sp_trace_setevent @TraceID, 12, 6, @on
exec sp_trace_setevent @TraceID, 12, 10, @on
exec sp_trace_setevent @TraceID, 12, 14, @on
exec sp_trace_setevent @TraceID, 12, 18, @on
exec sp_trace_setevent @TraceID, 12, 11, @on
exec sp_trace_setevent @TraceID, 12, 12, @on
exec sp_trace_setevent @TraceID, 12, 13, @on
exec sp_trace_setevent @TraceID, 13, 12, @on
exec sp_trace_setevent @TraceID, 13, 1, @on
exec sp_trace_setevent @TraceID, 13, 9, @on
exec sp_trace_setevent @TraceID, 13, 6, @on
exec sp_trace_setevent @TraceID, 13, 10, @on
exec sp_trace_setevent @TraceID, 13, 14, @on
exec sp_trace_setevent @TraceID, 13, 11, @on
exec sp_trace_setevent @TraceID, 41, 7, @on
exec sp_trace_setevent @TraceID, 41, 15, @on
exec sp_trace_setevent @TraceID, 41, 55, @on
exec sp_trace_setevent @TraceID, 41, 8, @on
exec sp_trace_setevent @TraceID, 41, 16, @on
exec sp_trace_setevent @TraceID, 41, 48, @on
exec sp_trace_setevent @TraceID, 41, 64, @on
exec sp_trace_setevent @TraceID, 41, 1, @on
exec sp_trace_setevent @TraceID, 41, 9, @on
exec sp_trace_setevent @TraceID, 41, 17, @on
exec sp_trace_setevent @TraceID, 41, 25, @on
exec sp_trace_setevent @TraceID, 41, 41, @on
exec sp_trace_setevent @TraceID, 41, 49, @on
exec sp_trace_setevent @TraceID, 41, 10, @on
exec sp_trace_setevent @TraceID, 41, 18, @on
exec sp_trace_setevent @TraceID, 41, 26, @on
exec sp_trace_setevent @TraceID, 41, 50, @on
exec sp_trace_setevent @TraceID, 41, 3, @on
exec sp_trace_setevent @TraceID, 41, 11, @on
exec sp_trace_setevent @TraceID, 41, 35, @on
exec sp_trace_setevent @TraceID, 41, 51, @on
exec sp_trace_setevent @TraceID, 41, 4, @on
exec sp_trace_setevent @TraceID, 41, 12, @on
exec sp_trace_setevent @TraceID, 41, 60, @on
exec sp_trace_setevent @TraceID, 41, 5, @on
exec sp_trace_setevent @TraceID, 41, 13, @on
exec sp_trace_setevent @TraceID, 41, 29, @on
exec sp_trace_setevent @TraceID, 41, 61, @on
exec sp_trace_setevent @TraceID, 41, 6, @on
exec sp_trace_setevent @TraceID, 41, 14, @on
exec sp_trace_setevent @TraceID, 166, 7, @on
exec sp_trace_setevent @TraceID, 166, 55, @on
exec sp_trace_setevent @TraceID, 166, 63, @on
exec sp_trace_setevent @TraceID, 166, 8, @on
exec sp_trace_setevent @TraceID, 166, 64, @on
exec sp_trace_setevent @TraceID, 166, 1, @on
exec sp_trace_setevent @TraceID, 166, 9, @on
exec sp_trace_setevent @TraceID, 166, 41, @on
exec sp_trace_setevent @TraceID, 166, 49, @on
exec sp_trace_setevent @TraceID, 166, 10, @on
exec sp_trace_setevent @TraceID, 166, 26, @on
exec sp_trace_setevent @TraceID, 166, 34, @on
exec sp_trace_setevent @TraceID, 166, 50, @on
exec sp_trace_setevent @TraceID, 166, 3, @on
exec sp_trace_setevent @TraceID, 166, 11, @on
exec sp_trace_setevent @TraceID, 166, 35, @on
exec sp_trace_setevent @TraceID, 166, 51, @on
exec sp_trace_setevent @TraceID, 166, 4, @on
exec sp_trace_setevent @TraceID, 166, 12, @on
exec sp_trace_setevent @TraceID, 166, 28, @on
exec sp_trace_setevent @TraceID, 166, 60, @on
exec sp_trace_setevent @TraceID, 166, 5, @on
exec sp_trace_setevent @TraceID, 166, 21, @on
exec sp_trace_setevent @TraceID, 166, 29, @on
exec sp_trace_setevent @TraceID, 166, 61, @on
exec sp_trace_setevent @TraceID, 166, 6, @on
exec sp_trace_setevent @TraceID, 166, 14, @on
exec sp_trace_setevent @TraceID, 166, 22, @on
exec sp_trace_setevent @TraceID, 40, 7, @on
exec sp_trace_setevent @TraceID, 40, 55, @on
exec sp_trace_setevent @TraceID, 40, 8, @on
exec sp_trace_setevent @TraceID, 40, 64, @on
exec sp_trace_setevent @TraceID, 40, 1, @on
exec sp_trace_setevent @TraceID, 40, 9, @on
exec sp_trace_setevent @TraceID, 40, 41, @on
exec sp_trace_setevent @TraceID, 40, 49, @on
exec sp_trace_setevent @TraceID, 40, 6, @on
exec sp_trace_setevent @TraceID, 40, 10, @on
exec sp_trace_setevent @TraceID, 40, 14, @on
exec sp_trace_setevent @TraceID, 40, 26, @on
exec sp_trace_setevent @TraceID, 40, 30, @on
exec sp_trace_setevent @TraceID, 40, 50, @on
exec sp_trace_setevent @TraceID, 40, 3, @on
exec sp_trace_setevent @TraceID, 40, 11, @on
exec sp_trace_setevent @TraceID, 40, 35, @on
exec sp_trace_setevent @TraceID, 40, 51, @on
exec sp_trace_setevent @TraceID, 40, 4, @on
exec sp_trace_setevent @TraceID, 40, 12, @on
exec sp_trace_setevent @TraceID, 40, 60, @on
exec sp_trace_setevent @TraceID, 40, 5, @on
exec sp_trace_setevent @TraceID, 40, 29, @on
exec sp_trace_setevent @TraceID, 40, 61, @on
exec sp_trace_setevent @TraceID, 73, 7, @on
exec sp_trace_setevent @TraceID, 73, 4, @on
exec sp_trace_setevent @TraceID, 73, 8, @on
exec sp_trace_setevent @TraceID, 73, 12, @on
exec sp_trace_setevent @TraceID, 73, 60, @on
exec sp_trace_setevent @TraceID, 73, 64, @on
exec sp_trace_setevent @TraceID, 73, 9, @on
exec sp_trace_setevent @TraceID, 73, 33, @on
exec sp_trace_setevent @TraceID, 73, 41, @on
exec sp_trace_setevent @TraceID, 73, 49, @on
exec sp_trace_setevent @TraceID, 73, 6, @on
exec sp_trace_setevent @TraceID, 73, 10, @on
exec sp_trace_setevent @TraceID, 73, 14, @on
exec sp_trace_setevent @TraceID, 73, 26, @on
exec sp_trace_setevent @TraceID, 73, 50, @on
exec sp_trace_setevent @TraceID, 73, 3, @on
exec sp_trace_setevent @TraceID, 73, 11, @on
exec sp_trace_setevent @TraceID, 73, 35, @on
exec sp_trace_setevent @TraceID, 73, 51, @on
exec sp_trace_setevent @TraceID, 198, 7, @on
exec sp_trace_setevent @TraceID, 198, 47, @on
exec sp_trace_setevent @TraceID, 198, 8, @on
exec sp_trace_setevent @TraceID, 198, 64, @on
exec sp_trace_setevent @TraceID, 198, 1, @on
exec sp_trace_setevent @TraceID, 198, 5, @on
exec sp_trace_setevent @TraceID, 198, 9, @on
exec sp_trace_setevent @TraceID, 198, 41, @on
exec sp_trace_setevent @TraceID, 198, 49, @on
exec sp_trace_setevent @TraceID, 198, 6, @on
exec sp_trace_setevent @TraceID, 198, 10, @on
exec sp_trace_setevent @TraceID, 198, 14, @on
exec sp_trace_setevent @TraceID, 198, 26, @on
exec sp_trace_setevent @TraceID, 198, 50, @on
exec sp_trace_setevent @TraceID, 198, 3, @on
exec sp_trace_setevent @TraceID, 198, 11, @on
exec sp_trace_setevent @TraceID, 198, 35, @on
exec sp_trace_setevent @TraceID, 198, 51, @on
exec sp_trace_setevent @TraceID, 198, 4, @on
exec sp_trace_setevent @TraceID, 198, 12, @on
exec sp_trace_setevent @TraceID, 198, 60, @on
exec sp_trace_setevent @TraceID, 19, 7, @on
exec sp_trace_setevent @TraceID, 19, 8, @on
exec sp_trace_setevent @TraceID, 19, 64, @on
exec sp_trace_setevent @TraceID, 19, 1, @on
exec sp_trace_setevent @TraceID, 19, 9, @on
exec sp_trace_setevent @TraceID, 19, 21, @on
exec sp_trace_setevent @TraceID, 19, 25, @on
exec sp_trace_setevent @TraceID, 19, 41, @on
exec sp_trace_setevent @TraceID, 19, 49, @on
exec sp_trace_setevent @TraceID, 19, 2, @on
exec sp_trace_setevent @TraceID, 19, 6, @on
exec sp_trace_setevent @TraceID, 19, 10, @on
exec sp_trace_setevent @TraceID, 19, 14, @on
exec sp_trace_setevent @TraceID, 19, 26, @on
exec sp_trace_setevent @TraceID, 19, 50, @on
exec sp_trace_setevent @TraceID, 19, 3, @on
exec sp_trace_setevent @TraceID, 19, 11, @on
exec sp_trace_setevent @TraceID, 19, 35, @on
exec sp_trace_setevent @TraceID, 19, 51, @on
exec sp_trace_setevent @TraceID, 19, 4, @on
exec sp_trace_setevent @TraceID, 19, 12, @on
exec sp_trace_setevent @TraceID, 19, 60, @on
exec sp_trace_setevent @TraceID, 50, 7, @on
exec sp_trace_setevent @TraceID, 50, 15, @on
exec sp_trace_setevent @TraceID, 50, 8, @on
exec sp_trace_setevent @TraceID, 50, 64, @on
exec sp_trace_setevent @TraceID, 50, 1, @on
exec sp_trace_setevent @TraceID, 50, 9, @on
exec sp_trace_setevent @TraceID, 50, 25, @on
exec sp_trace_setevent @TraceID, 50, 41, @on
exec sp_trace_setevent @TraceID, 50, 49, @on
exec sp_trace_setevent @TraceID, 50, 6, @on
exec sp_trace_setevent @TraceID, 50, 10, @on
exec sp_trace_setevent @TraceID, 50, 14, @on
exec sp_trace_setevent @TraceID, 50, 26, @on
exec sp_trace_setevent @TraceID, 50, 34, @on
exec sp_trace_setevent @TraceID, 50, 50, @on
exec sp_trace_setevent @TraceID, 50, 3, @on
exec sp_trace_setevent @TraceID, 50, 11, @on
exec sp_trace_setevent @TraceID, 50, 35, @on
exec sp_trace_setevent @TraceID, 50, 51, @on
exec sp_trace_setevent @TraceID, 50, 4, @on
exec sp_trace_setevent @TraceID, 50, 12, @on
exec sp_trace_setevent @TraceID, 50, 60, @on
exec sp_trace_setevent @TraceID, 50, 13, @on
exec sp_trace_setevent @TraceID, 50, 21, @on
exec sp_trace_setevent @TraceID, 182, 7, @on
exec sp_trace_setevent @TraceID, 182, 23, @on
exec sp_trace_setevent @TraceID, 182, 31, @on
exec sp_trace_setevent @TraceID, 182, 8, @on
exec sp_trace_setevent @TraceID, 182, 64, @on
exec sp_trace_setevent @TraceID, 182, 1, @on
exec sp_trace_setevent @TraceID, 182, 9, @on
exec sp_trace_setevent @TraceID, 182, 41, @on
exec sp_trace_setevent @TraceID, 182, 49, @on
exec sp_trace_setevent @TraceID, 182, 6, @on
exec sp_trace_setevent @TraceID, 182, 10, @on
exec sp_trace_setevent @TraceID, 182, 14, @on
exec sp_trace_setevent @TraceID, 182, 26, @on
exec sp_trace_setevent @TraceID, 182, 50, @on
exec sp_trace_setevent @TraceID, 182, 3, @on
exec sp_trace_setevent @TraceID, 182, 11, @on
exec sp_trace_setevent @TraceID, 182, 35, @on
exec sp_trace_setevent @TraceID, 182, 51, @on
exec sp_trace_setevent @TraceID, 182, 4, @on
exec sp_trace_setevent @TraceID, 182, 12, @on
exec sp_trace_setevent @TraceID, 182, 60, @on
exec sp_trace_setevent @TraceID, 181, 7, @on
exec sp_trace_setevent @TraceID, 181, 4, @on
exec sp_trace_setevent @TraceID, 181, 8, @on
exec sp_trace_setevent @TraceID, 181, 12, @on
exec sp_trace_setevent @TraceID, 181, 60, @on
exec sp_trace_setevent @TraceID, 181, 64, @on
exec sp_trace_setevent @TraceID, 181, 1, @on
exec sp_trace_setevent @TraceID, 181, 9, @on
exec sp_trace_setevent @TraceID, 181, 41, @on
exec sp_trace_setevent @TraceID, 181, 49, @on
exec sp_trace_setevent @TraceID, 181, 6, @on
exec sp_trace_setevent @TraceID, 181, 10, @on
exec sp_trace_setevent @TraceID, 181, 14, @on
exec sp_trace_setevent @TraceID, 181, 26, @on
exec sp_trace_setevent @TraceID, 181, 50, @on
exec sp_trace_setevent @TraceID, 181, 3, @on
exec sp_trace_setevent @TraceID, 181, 11, @on
exec sp_trace_setevent @TraceID, 181, 35, @on
exec sp_trace_setevent @TraceID, 181, 51, @on
exec sp_trace_setevent @TraceID, 186, 7, @on
exec sp_trace_setevent @TraceID, 186, 23, @on
exec sp_trace_setevent @TraceID, 186, 31, @on
exec sp_trace_setevent @TraceID, 186, 8, @on
exec sp_trace_setevent @TraceID, 186, 64, @on
exec sp_trace_setevent @TraceID, 186, 1, @on
exec sp_trace_setevent @TraceID, 186, 9, @on
exec sp_trace_setevent @TraceID, 186, 21, @on
exec sp_trace_setevent @TraceID, 186, 41, @on
exec sp_trace_setevent @TraceID, 186, 49, @on
exec sp_trace_setevent @TraceID, 186, 6, @on
exec sp_trace_setevent @TraceID, 186, 10, @on
exec sp_trace_setevent @TraceID, 186, 14, @on
exec sp_trace_setevent @TraceID, 186, 26, @on
exec sp_trace_setevent @TraceID, 186, 50, @on
exec sp_trace_setevent @TraceID, 186, 3, @on
exec sp_trace_setevent @TraceID, 186, 11, @on
exec sp_trace_setevent @TraceID, 186, 35, @on
exec sp_trace_setevent @TraceID, 186, 51, @on
exec sp_trace_setevent @TraceID, 186, 4, @on
exec sp_trace_setevent @TraceID, 186, 12, @on
exec sp_trace_setevent @TraceID, 186, 60, @on
exec sp_trace_setevent @TraceID, 185, 7, @on
exec sp_trace_setevent @TraceID, 185, 8, @on
exec sp_trace_setevent @TraceID, 185, 64, @on
exec sp_trace_setevent @TraceID, 185, 1, @on
exec sp_trace_setevent @TraceID, 185, 9, @on
exec sp_trace_setevent @TraceID, 185, 21, @on
exec sp_trace_setevent @TraceID, 185, 41, @on
exec sp_trace_setevent @TraceID, 185, 49, @on
exec sp_trace_setevent @TraceID, 185, 6, @on
exec sp_trace_setevent @TraceID, 185, 10, @on
exec sp_trace_setevent @TraceID, 185, 14, @on
exec sp_trace_setevent @TraceID, 185, 26, @on
exec sp_trace_setevent @TraceID, 185, 50, @on
exec sp_trace_setevent @TraceID, 185, 3, @on
exec sp_trace_setevent @TraceID, 185, 11, @on
exec sp_trace_setevent @TraceID, 185, 35, @on
exec sp_trace_setevent @TraceID, 185, 51, @on
exec sp_trace_setevent @TraceID, 185, 4, @on
exec sp_trace_setevent @TraceID, 185, 12, @on
exec sp_trace_setevent @TraceID, 185, 60, @on
exec sp_trace_setevent @TraceID, 184, 7, @on
exec sp_trace_setevent @TraceID, 184, 23, @on
exec sp_trace_setevent @TraceID, 184, 31, @on
exec sp_trace_setevent @TraceID, 184, 8, @on
exec sp_trace_setevent @TraceID, 184, 64, @on
exec sp_trace_setevent @TraceID, 184, 9, @on
exec sp_trace_setevent @TraceID, 184, 41, @on
exec sp_trace_setevent @TraceID, 184, 49, @on
exec sp_trace_setevent @TraceID, 184, 2, @on
exec sp_trace_setevent @TraceID, 184, 6, @on
exec sp_trace_setevent @TraceID, 184, 10, @on
exec sp_trace_setevent @TraceID, 184, 14, @on
exec sp_trace_setevent @TraceID, 184, 26, @on
exec sp_trace_setevent @TraceID, 184, 50, @on
exec sp_trace_setevent @TraceID, 184, 3, @on
exec sp_trace_setevent @TraceID, 184, 11, @on
exec sp_trace_setevent @TraceID, 184, 35, @on
exec sp_trace_setevent @TraceID, 184, 51, @on
exec sp_trace_setevent @TraceID, 184, 4, @on
exec sp_trace_setevent @TraceID, 184, 12, @on
exec sp_trace_setevent @TraceID, 184, 60, @on
exec sp_trace_setevent @TraceID, 183, 7, @on
exec sp_trace_setevent @TraceID, 183, 4, @on
exec sp_trace_setevent @TraceID, 183, 8, @on
exec sp_trace_setevent @TraceID, 183, 12, @on
exec sp_trace_setevent @TraceID, 183, 60, @on
exec sp_trace_setevent @TraceID, 183, 64, @on
exec sp_trace_setevent @TraceID, 183, 9, @on
exec sp_trace_setevent @TraceID, 183, 41, @on
exec sp_trace_setevent @TraceID, 183, 49, @on
exec sp_trace_setevent @TraceID, 183, 6, @on
exec sp_trace_setevent @TraceID, 183, 10, @on
exec sp_trace_setevent @TraceID, 183, 14, @on
exec sp_trace_setevent @TraceID, 183, 26, @on
exec sp_trace_setevent @TraceID, 183, 50, @on
exec sp_trace_setevent @TraceID, 183, 3, @on
exec sp_trace_setevent @TraceID, 183, 11, @on
exec sp_trace_setevent @TraceID, 183, 35, @on
exec sp_trace_setevent @TraceID, 183, 51, @on
exec sp_trace_setevent @TraceID, 188, 7, @on
exec sp_trace_setevent @TraceID, 188, 23, @on
exec sp_trace_setevent @TraceID, 188, 31, @on
exec sp_trace_setevent @TraceID, 188, 8, @on
exec sp_trace_setevent @TraceID, 188, 64, @on
exec sp_trace_setevent @TraceID, 188, 1, @on
exec sp_trace_setevent @TraceID, 188, 9, @on
exec sp_trace_setevent @TraceID, 188, 21, @on
exec sp_trace_setevent @TraceID, 188, 41, @on
exec sp_trace_setevent @TraceID, 188, 49, @on
exec sp_trace_setevent @TraceID, 188, 6, @on
exec sp_trace_setevent @TraceID, 188, 10, @on
exec sp_trace_setevent @TraceID, 188, 14, @on
exec sp_trace_setevent @TraceID, 188, 26, @on
exec sp_trace_setevent @TraceID, 188, 50, @on
exec sp_trace_setevent @TraceID, 188, 3, @on
exec sp_trace_setevent @TraceID, 188, 11, @on
exec sp_trace_setevent @TraceID, 188, 35, @on
exec sp_trace_setevent @TraceID, 188, 51, @on
exec sp_trace_setevent @TraceID, 188, 4, @on
exec sp_trace_setevent @TraceID, 188, 12, @on
exec sp_trace_setevent @TraceID, 188, 60, @on
exec sp_trace_setevent @TraceID, 187, 7, @on
exec sp_trace_setevent @TraceID, 187, 8, @on
exec sp_trace_setevent @TraceID, 187, 64, @on
exec sp_trace_setevent @TraceID, 187, 1, @on
exec sp_trace_setevent @TraceID, 187, 9, @on
exec sp_trace_setevent @TraceID, 187, 21, @on
exec sp_trace_setevent @TraceID, 187, 41, @on
exec sp_trace_setevent @TraceID, 187, 49, @on
exec sp_trace_setevent @TraceID, 187, 6, @on
exec sp_trace_setevent @TraceID, 187, 10, @on
exec sp_trace_setevent @TraceID, 187, 14, @on
exec sp_trace_setevent @TraceID, 187, 26, @on
exec sp_trace_setevent @TraceID, 187, 50, @on
exec sp_trace_setevent @TraceID, 187, 3, @on
exec sp_trace_setevent @TraceID, 187, 11, @on
exec sp_trace_setevent @TraceID, 187, 35, @on
exec sp_trace_setevent @TraceID, 187, 51, @on
exec sp_trace_setevent @TraceID, 187, 4, @on
exec sp_trace_setevent @TraceID, 187, 12, @on
exec sp_trace_setevent @TraceID, 187, 60, @on
exec sp_trace_setevent @TraceID, 192, 7, @on
exec sp_trace_setevent @TraceID, 192, 23, @on
exec sp_trace_setevent @TraceID, 192, 31, @on
exec sp_trace_setevent @TraceID, 192, 8, @on
exec sp_trace_setevent @TraceID, 192, 64, @on
exec sp_trace_setevent @TraceID, 192, 1, @on
exec sp_trace_setevent @TraceID, 192, 9, @on
exec sp_trace_setevent @TraceID, 192, 41, @on
exec sp_trace_setevent @TraceID, 192, 49, @on
exec sp_trace_setevent @TraceID, 192, 6, @on
exec sp_trace_setevent @TraceID, 192, 10, @on
exec sp_trace_setevent @TraceID, 192, 14, @on
exec sp_trace_setevent @TraceID, 192, 26, @on
exec sp_trace_setevent @TraceID, 192, 50, @on
exec sp_trace_setevent @TraceID, 192, 54, @on
exec sp_trace_setevent @TraceID, 192, 3, @on
exec sp_trace_setevent @TraceID, 192, 11, @on
exec sp_trace_setevent @TraceID, 192, 35, @on
exec sp_trace_setevent @TraceID, 192, 51, @on
exec sp_trace_setevent @TraceID, 192, 4, @on
exec sp_trace_setevent @TraceID, 192, 12, @on
exec sp_trace_setevent @TraceID, 192, 60, @on
exec sp_trace_setevent @TraceID, 191, 7, @on
exec sp_trace_setevent @TraceID, 191, 4, @on
exec sp_trace_setevent @TraceID, 191, 8, @on
exec sp_trace_setevent @TraceID, 191, 12, @on
exec sp_trace_setevent @TraceID, 191, 60, @on
exec sp_trace_setevent @TraceID, 191, 64, @on
exec sp_trace_setevent @TraceID, 191, 1, @on
exec sp_trace_setevent @TraceID, 191, 9, @on
exec sp_trace_setevent @TraceID, 191, 41, @on
exec sp_trace_setevent @TraceID, 191, 49, @on
exec sp_trace_setevent @TraceID, 191, 6, @on
exec sp_trace_setevent @TraceID, 191, 10, @on
exec sp_trace_setevent @TraceID, 191, 14, @on
exec sp_trace_setevent @TraceID, 191, 26, @on
exec sp_trace_setevent @TraceID, 191, 50, @on
exec sp_trace_setevent @TraceID, 191, 3, @on
exec sp_trace_setevent @TraceID, 191, 11, @on
exec sp_trace_setevent @TraceID, 191, 35, @on
exec sp_trace_setevent @TraceID, 191, 51, @on
exec sp_trace_setevent @TraceID, 54, 7, @on
exec sp_trace_setevent @TraceID, 54, 8, @on
exec sp_trace_setevent @TraceID, 54, 24, @on
exec sp_trace_setevent @TraceID, 54, 64, @on
exec sp_trace_setevent @TraceID, 54, 9, @on
exec sp_trace_setevent @TraceID, 54, 21, @on
exec sp_trace_setevent @TraceID, 54, 25, @on
exec sp_trace_setevent @TraceID, 54, 41, @on
exec sp_trace_setevent @TraceID, 54, 49, @on
exec sp_trace_setevent @TraceID, 54, 2, @on
exec sp_trace_setevent @TraceID, 54, 6, @on
exec sp_trace_setevent @TraceID, 54, 10, @on
exec sp_trace_setevent @TraceID, 54, 14, @on
exec sp_trace_setevent @TraceID, 54, 22, @on
exec sp_trace_setevent @TraceID, 54, 26, @on
exec sp_trace_setevent @TraceID, 54, 3, @on
exec sp_trace_setevent @TraceID, 54, 11, @on
exec sp_trace_setevent @TraceID, 54, 35, @on
exec sp_trace_setevent @TraceID, 54, 51, @on
exec sp_trace_setevent @TraceID, 54, 4, @on
exec sp_trace_setevent @TraceID, 54, 12, @on
exec sp_trace_setevent @TraceID, 54, 60, @on


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

set @intfilter = 60
exec sp_trace_setfilter @TraceID, 3, 0, 0, @intfilter



exec sp_trace_setfilter @TraceID, 10, 0, 7, N'SQL Server Profiler - ed03094f-7bb0-491e-a9ed-38fa8cada1ab'
exec sp_trace_setfilter @TraceID, 64, 0, 7, N'sqldm'
set @intfilter = 782625831
exec sp_trace_setfilter @TraceID, 22, 0, 0, @intfilter


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

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

error:
select ErrorCode=@rc

finish:
go













SELECT * FROM ::fn_trace_getinfo (0)

Select * from fn_trace_geteventinfo(5)

select * from fn_trace_getfilterinfo(5)



select * from dbo.schools_2006

select * from dbo.campuscodes

select * from Teleform.Teleform.tfbatmem


exec sp_trace_setstatus 5,0

exec sp_trace_setstatus 5,2

1 comment: