Specify @traceid in ActivityTrace.ini @filter value

• Express12

  SSCoach

  Points: 18514

  More actions

  May 15, 2006 at 11:00 am

  #113439

  I'm using trace_build stored proc to activate TRACE on SQL Server 2000.  My Trace_Build sproc points to ActivityTrace.ini file containing:

  @performancecheck  = yes

  @blockingcheck     = yes

  @tracefile         = \\MySQLServer\trace\SQL_TRACE

  @maxfilesize       = 25

  @options           = 2

  @events            = 10,11,12,13,16,17,19,21,22,25,27,33,42,43,45,55,59,61,67,69,80,82,83

  @columns           = 1,2,3,6,9,10,11,12,13,14,15,16,17,18,25,35

  @filter1           = 22, 10, 0, 7, N'SQL Profiler'

  @filter2           = 1, 3, 0, 6, N'MY_DBname%'

  @filter3           = 2, 3, 0, 6, N'MY_DBName%'

  Basically, I want to narrow the TRACE to a single Database called "My_DBname" w/ a DB ID =  6

  BOL mentions to specify [@traceid =] trace_id Is the ID of the trace to which the filter is set. trace_id is int, with no default. The user employs this trace_id value to identify, modify, and control the trace.

  Question:

  1) in the @filterX lines above, how do I know what to use as my @traceid?   (I've added 1 and 2 arbitrarily)

   

   

  BT

• Express12

  SSCoach

  Points: 18514

  More actions

  May 15, 2006 at 12:45 pm

  #637967

  Turns out, the DBA before me incorrectly setup the @filter statements..  They should only contain 4 parameters.  Problem Resolved.

  BT