Create simple trace
declare @RC int, @TraceID int, @ON bit
SET @ON = 1
exec @RC = sp_trace_create @TraceID OUTPUT, 0, N'C:\TraceSELECT'
select 'RC'= @RC, 'TraceID'= @TraceID
-- Batch Completed Event, Start Time column
exec @RC = sp_trace_setevent @TraceID, 12, 14, @ON
-- Batch Completed Event, Database ID Column
exec @RC = sp_trace_setevent @TraceID, 12, 3, @ON
-- Batch Completed Event, Text Column
exec @RC = sp_trace_setevent @TraceID, 12, 1, @ON
-- Login event, Start Column
exec @RC = sp_trace_setevent @TraceID, 14, 14, @ON
-- set filter for Column 1 (text), data = 'select'
exec @RC = sp_trace_setfilter @TraceID, 1, 0, 0, N'select'
-- Start Trace (status 1 = start)
exec @RC = sp_trace_setstatus @TraceID, 1
GO
SELECT * FROM :: fn_trace_getinfo(default)
GO
