Mastering SQL Trace Using Profiler - Microsoft SQL Server 2012 Performance Tuning - page 33

LOG ON
(
NAME = N'SampeDBForTrace_log'
,FILENAME = N'C:\MyTraces\SampeDBForTrace_log.ldf'
,SIZE = 1024KB , FILEGROWTH = 1024KB
)
GO

USE SampeDBForTrace
GO

--Creating and Inserting one million records tbl_SampleData table.
SELECT TOP 1000000 C1.*
INTO tbl_SampleData
FROM sys.columns AS C1
CROSS JOIN sys.columns AS C2
CROSS JOIN sys.columns AS C3
GO

5. After executing the previous script, execute the following T-SQL script to stop and

close the trace:
DECLARE @TraceID INT
DECLARE @TraceFile NVARCHAR(245) = 'C:\MyTraces\MyTestTrace.trc'

--Get the TraceID for our trace.
SELECT @TraceID = id FROM sys.traces
WHERE path = @TraceFile

IF @TraceID IS NOT NULL
BEGIN
--Stop the trace. Status 0 corroponds to STOP.
EXECUTE sp_trace_setstatus
@traceid = @TraceID
,@status = 0
--Closes the trace. Status 2 corroponds to CLOSE.
EXECUTE sp_trace_setstatus
@traceid = @TraceID
,@status = 2
END
GO