run a trace using profiler on a database

  • 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

  • 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)

  • thanks pal, I got it.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply