CREATE   PROCEDURE [dbo].[stp_start_profiler]

AS

DECLARE @rc INT
DECLARE @TraceID INT
DECLARE @maxFileSize bigint
DECLARE @fileName NVARCHAR(128)
DECLARE @on bit

-- Set values
SET @maxFileSize = 5
SET @fileName = 'c:\trace' + CONVERT(varchar(4),YEAR(GETDATE())) + CONVERT(varchar(4),MONTH(GETDATE())) + CONVERT(varchar(4),DAY(GETDATE()))
--SET @fileName = N'C:\TestTrace1'
SET @on = 1

-- Create trace
EXEC @rc = sp_trace_create @TraceID output, 2, @fileName, @maxFileSize, NULL 

-- If error end process
IF (@rc != 0) GOTO error

-- Set the events and data to collect
EXEC sp_trace_setevent @TraceID, 45,  1, @on
EXEC sp_trace_setevent @TraceID, 45, 12, @on
EXEC sp_trace_setevent @TraceID, 45, 13, @on
EXEC sp_trace_setevent @TraceID, 45, 14, @on
EXEC sp_trace_setevent @TraceID, 45, 15, @on
EXEC sp_trace_setevent @TraceID, 45, 16, @on
EXEC sp_trace_setevent @TraceID, 45, 17, @on

-- Set Filters
-- filter1 include databaseId = 6
EXEC sp_trace_setfilter @TraceID, 3, 1, 0, 6
-- filter2 exclude application SQL Profiler
EXEC sp_trace_setfilter @TraceID, 10, 0, 7, N'SQL Profiler'

-- Start the trace
EXEC sp_trace_setstatus @TraceID, 1
 
-- display trace id for future references 
SELECT TraceID=@TraceID 
INSERT INTO Traces (TraceID, Starttijd, Eindtijd, bestandsnaam)
VALUES (@TraceID, getdate(), NULL, @fileName)
GOTO finish 

-- error trap
error: 
SELECT ErrorCode=@rc 

-- exit
finish: 

GO