Using PROFILER tool in 2005

[katgirl]

Is there a way to filter a trace by DATABASE??

Thanks

 

[vbkris]

hi, dont konw bout 2005. but you have it in 2000. so my guess would be that it is there in 2005...

Known is handfull, Unknown is worldfull

 

[mrdenny]

Yes, get the database id from the sys.databases view. You can then filter off of the database.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[katgirl]

yeah, i finally got it to work on 2005 - amazing

thanks