USE [IRECORDER]
GO
/****** Object:  StoredProcedure [dbo].[dba_Trc_eTrust_Audit]    Script Date: 07/15/2008 16:52:56 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER PROCEDURE [dbo].[dba_Trc_eTrust_Audit]
    @FileBase nvarchar(1000)
  , @Sec int
  , @TraceID int OUTPUT -- Return the TraceID to the caller.
  WITH RECOMPILE
/*
* Creates a trace 
***********************************************************************/
AS 
-- Create a Queue
declare @rc int
declare @dbaTraceID int
declare @maxfilesize bigint
declare @DateTime datetime
declare @TraceCount int
DECLARE @FileName nvarchar(1000) 
      , @StartDT  datetime -- When the trace started

SELECT @StartDT = getdate()

set @TraceCount = (SELECT COUNT(*) FROM dbo.dbaTrace WHERE FileLoadedDT is NULL)
if (@TraceCount >= 10) 
BEGIN
	PRINT 'More Trace Files'
	goto finish
END

set @maxfilesize = 50 

SELECT @FileName = @FileBase
	+ convert(varchar, @StartDT, 12)
	+ replace(convert(varchar, GetDate(), 8), ':', '')

     , @DateTime = DATEADD (s, @Sec, @StartDT)
     
set @maxfilesize = 50
exec @rc = sp_trace_create @TraceID output, 2, @FileName, @maxfilesize, @DateTime

if (@rc != 0) goto error

-- Client side File and Table cannot be scripted

-- Set the events
declare @on bit
set @on = 1
exec sp_trace_setevent @TraceID, x, y, @on
exec sp_trace_setevent @TraceID, x, 19, @on
exec sp_trace_setevent @TraceID, x, y, @on
exec sp_trace_setevent @TraceID, x, 34, @on
exec sp_trace_setevent @TraceID, x, 35, @on
exec sp_trace_setevent @TraceID, x, y, @on



-- Set up the trace filters

exec sp_trace_setfilter @TraceID, 19, 0, 1, N'1'
exec sp_trace_setfilter @TraceID, 34, 0, 7, N'SEOSDATA'
exec sp_trace_setfilter @TraceID, 34, 0, 7, N'dbaTrace'
exec sp_trace_setfilter @TraceID, 34, 0, 7, N'dbaTraceDetail'
exec sp_trace_setfilter @TraceID, 34, 0, 7, N'dbaTraceMissing'
exec sp_trace_setfilter @TraceID, 34, 0, 7, N'sp_trace_create'
exec sp_trace_setfilter @TraceID, 34, 0, 7, N'sp_trace_setstatus'
exec sp_trace_setfilter @TraceID, 34, 0, 7, N'sp_trace_setfilter'
exec sp_trace_setfilter @TraceID, 34, 0, 7, N'db_Trc_Load'
exec sp_trace_setfilter @TraceID, 34, 0, 7, N'db_Trc_LoadFile'
exec sp_trace_setfilter @TraceID, 34, 0, 7, N'db_Trc_eTrust_Audit'
exec sp_trace_setfilter @TraceID, 35, 0, 7, N'IRECORDER'
exec sp_trace_setfilter @TraceID, 35, 0, 7, N'tempdb'
exec sp_trace_setfilter @TraceID, 35, 0, 7, N'msdb'
exec sp_trace_setfilter @TraceID, 35, 0, 7, N'master'
exec sp_trace_setfilter @TraceID, 35, 0, 7, N'mssqlsystemresource'
exec sp_trace_setfilter @TraceID, 35, 0, 7, N'ReportServer'
exec sp_trace_setfilter @TraceID, 35, 0, 7, N'ReportServerTempDB'



-- Set the trace status to start
exec sp_trace_setstatus @TraceID, 1

-- display trace id for future references

EXEC @rc = dba_Trc_Record @FileName, @StartDT, @Sec
                , 'Scripted Trace for etrust Audit'
                , @TraceID, @dbaTraceID OUTPUT

PRINT 'Recording Started.  SQL Trace ID=' 
                          + CONVERT(varchar(9), @TraceID)
PRINT 'dbaTrace.dbaTraceID = ' 
                          + CONVERT(varchar(9), @dbaTraceID)
goto finish

error: 
select ErrorCode=@rc

finish:

quote:

---

[ @value = ] value
Specifies the value on which to filter. The data type of value must match the data type of the column to be filtered. For example, if the filter is set on an Object ID column that is an int data type, value must be int. If value is nvarchar or varbinary, it can have a maximum length of 8000.

---

quote:

---

Originally posted by tkizer

Have you tried passing it as a number rather than a string?
exec sp_trace_setfilter @TraceID, 19, 0, 1, 1

---

declare @bigintfilter bigint

set @bigintfilter = 1
exec sp_trace_setfilter @TraceID, 19, 0, 1, @bigintfilter

declare @bigintfilter bigint
set @bigintfilter = 1 
exec sp_trace_setfilter @TraceID, 19, 0, 4, @bigintfilter