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.
| Author |
Topic |
|
akashenk
Posting Yak Master
111 Posts |
 Posted - 2007-06-28 : 13:31:08
|
| Is there a log or some other tool available in SQL Server 2005 that allows you to see the queries that are being run against the server real-time? |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-06-28 : 13:53:06
|
yes, it's called Profiler.
elsasoft.org |
 |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-06-28 : 14:05:11
|
| It will be a "catch the mouse" game with sp_who2 and DBCC INPUTBUFFER. Read up books online if you need more info about the commands.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
akashenk
Posting Yak Master
111 Posts |
Posted - 2007-06-28 : 14:22:59
|
quote:
Originally posted by jezemine
yes, it's called Profiler.
elsasoft.org
Thanks Jesemine. I am taking a look at profiler, but it seems to be logging many events I don't care about. All I'm interested in is Queries made against the server. I went to the Events tab and unchecked the security events, but I am still getting quite a few entries. Is there a reference that might show me which events I need to select in order to only see queries? |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-06-28 : 14:40:56
|
yes, it's called BOL. 
elsasoft.org |
|
|
|
akashenk
Posting Yak Master
111 Posts |
Posted - 2007-06-28 : 14:43:33
|
| Thanks for your help |
|
|
|
|
|
|
Query Viewer