Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SQL Profiler Question

Author  Topic 

jeffdavid
Starting Member

8 Posts

Posted - 2008-06-30 : 08:09:50
Is there a way to run a trace on a specific Database?

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2008-06-30 : 08:36:13
Yes, use the DatabaseId or DatabaseName token. You can get the databaseid by running:

select * from sys.databases
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-30 : 09:44:02
You can use filter column in profiler for Specific DBname
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2008-06-30 : 09:45:23
quote:
Originally posted by sodeep

You can use filter column in profiler for Specific DBname


Err, thats what I said..
Go to Top of Page

jeffdavid
Starting Member

8 Posts

Posted - 2008-06-30 : 09:52:37
thanks!
Go to Top of Page
   

- Advertisement -