How to apply "System ID" filter in SQL Server 2005 Profiler

• Data Sheet

  SSC-Addicted

  Points: 445

  More actions

  April 26, 2007 at 2:40 pm

  #370622

  In SQL Server 2000 Profiler we can check "Exclude System ID" to not to add any system data in trace file, but where is this option in SQL Server 2005 Profiler?

  I am running trace but getting bunch of background system related data which I donot need it.

   

  Thanks for any clue.

   

  Data Sheet

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  April 27, 2007 at 5:43 am

  #702879

  The checkbox is gone, but you can add a column filter which excludes al SPID's below 50.

  Markus

  [font="Verdana"]Markus Bohse[/font]