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
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 "profiler" how do i activate it ?

Author  Topic 

pssheba
Yak Posting Veteran

95 Posts

Posted - 2008-01-28 : 05:24:22
Hi everyone,
In order to trace queries commited by all users, i need to use "profiler" but i dont know where it is to be found and how to activate it.
I'll be grateful for any assistance.
Thanks

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-01-28 : 05:33:33
Programs-->Microsoft SQL Server 2005-->Performance Tools-->SQL Server Profiler

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2008-01-28 : 18:51:40
It is possible to trigger traces programatically and avoid starting Profiler.Check traces in BOL

Jack Vamvas
--------------------
Search IT jobs from multiple sources- http://www.ITjobfeed.com
Go to Top of Page
   

- Advertisement -