/****************************************************/

            /* Created by: SQL Profiler                 */

            /* Date: 2004/06/19 16:50:05       */

            /****************************************************/

            -- 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, 0, N’c:＼test’, @maxfilesize, NULL 

            if (@rc != 0) goto error

            

            -- Client side File and Table cannot be scripted

            -- Writing to a table is not supported through the SP’s

            -- Set the events

            declare @on bit

            set @on = 1

            exec sp_trace_setevent @TraceID, 12, 1, @on

            exec sp_trace_setevent @TraceID, 12, 12, @on

            exec sp_trace_setevent @TraceID, 12, 14, @on

            

            -- Set the Filters

            declare @intfilter int

            declare @bigintfilter bigint

            exec sp_trace_setfilter @TraceID, 10, 0, 7, N’SQL Profiler’

            set @intfilter = 100

            exec sp_trace_setfilter @TraceID, 22, 0, 4, @intfilter

            set @intfilter = 1

            exec sp_trace_setfilter @TraceID, 23, 1, 0, @intfilter

            exec sp_trace_setfilter @TraceID, 35, 1, 6, N’pubs’

            

            -- 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)

EXEC sp_trace_setstatus 

            @traceid = 1 ,   -- 跟踪的id

            @status = 0     -- 停止, 这样以后还可能指定此项为来启用

            EXEC sp_trace_setstatus 

            @traceid = 1 , 

            @status = 2     -- 关闭, 完全释放