declare @rc int
declare @TraceID int

declare @maxfilesize bigint
set @maxfilesize = 100

exec @rc = sp_trace_create @TraceID output, 0, N'c:\Elsif', @maxfilesize, NULL 

-- Set the events
declare @on bit
set @on = 1
----------------------@TraceID,Evento,Coluna,@on (0 ou 1)
exec sp_trace_setevent @TraceID, 12, 1, @on
exec sp_trace_setevent @TraceID, 12, 9, @on
exec sp_trace_setevent @TraceID, 12, 11, @on
exec sp_trace_setevent @TraceID, 12, 6, @on
exec sp_trace_setevent @TraceID, 12, 8, @on
exec sp_trace_setevent @TraceID, 12, 10, @on
exec sp_trace_setevent @TraceID, 12, 12, @on
exec sp_trace_setevent @TraceID, 12, 13, @on
exec sp_trace_setevent @TraceID, 12, 14, @on
exec sp_trace_setevent @TraceID, 12, 15, @on
exec sp_trace_setevent @TraceID, 12, 16, @on
exec sp_trace_setevent @TraceID, 12, 17, @on
exec sp_trace_setevent @TraceID, 12, 18, @on
exec sp_trace_setevent @TraceID, 12, 35, @on
exec sp_trace_setevent @TraceID, 13, 1, @on
exec sp_trace_setevent @TraceID, 13, 9, @on
exec sp_trace_setevent @TraceID, 13, 11, @on
exec sp_trace_setevent @TraceID, 13, 6, @on
exec sp_trace_setevent @TraceID, 13, 8, @on
exec sp_trace_setevent @TraceID, 13, 10, @on
exec sp_trace_setevent @TraceID, 13, 12, @on
exec sp_trace_setevent @TraceID, 13, 14, @on
exec sp_trace_setevent @TraceID, 13, 35, @on


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

exec sp_trace_setfilter @TraceID, 10, 0, 7, N'SQL Server Profiler - 7ef8a808-6879-4eaf-bcb2-244fcc12be88'
exec sp_trace_setfilter @TraceID, 35, 0, 6, N'EuroGest9006'

-- Set the trace status to start
exec sp_trace_setstatus @TraceID, 1  --0->Stops  1->Starts  2->STOP E CLOSE

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


------------------
--consultas
--SELECT * FROM sys.traces
--SELECT * FROM sys.fn_trace_getinfo(2)
--SELECT * FROM sys.fn_trace_getFilterinfo(5) --5=TraceId

--Passar o conteudo do trc para uma tabela
--Drop Databse ElsifTemp
--drop table ElsifTemp.._trc

--create database ElsifTemp
--SELECT * INTO ElsifTemp.._trc  FROM fn_trace_gettable('c:\Elsif.trc', default);  

--select * from ElsifTemp.._trc
--Drop Databse ElsifTemp