run a trace using profiler on a database

• koonpark

  Valued Member

  Points: 72

  More actions

  March 18, 2002 at 5:34 pm

  #357501

  Does anyone know how to run a trace just against one database instead against a server?? This is SQL server 7/2000 that we are talking about. Thanks in advance.

  regards,

  Park

• Antares686

  SSC Guru

  Points: 125444

  More actions

  March 18, 2002 at 7:44 pm

  #425606

  On the last tab you can specify parameters, for include and exclude on the trace properties dialog. You can set a specific DBID (which you can get by "SELECT [id], [name] FROM master.dbo.sysdatabases WHERE [name] = 'DBNAMEHERE'"), you will still pick up some stray things but most will be from the DB entered.

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

• koonpark

  Valued Member

  Points: 72

  More actions

  March 18, 2002 at 8:28 pm

  #425607

  thanks pal, I got it.