I am trying to run a server side trace based on duration that will exclude rows that are null for that field.
If I add this as a filter it does not work.
declare @bigintfilter bigint
set @bigintfilter = null
exec sp_trace_setfilter @TraceID, 13, 0, 1, @bigintfilter
I also tried
set @bigintfilter = 0
exec sp_trace_setfilter @TraceID, 13, 0, 1, @bigintfilter
I get lots of nulls. Yes, I have the @traceid prior:)
Any thoughts? or can this not be done
Michael
Sr. DBA - MCDBA
See my Reader 2 Reader articles in Jan and August 2008 issues of SQL Server Magazine:)
