|
Home > Archive > MS SQL Server > October 2006 > what queries has a process executed
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
what queries has a process executed
|
|
| nadabadan 2006-10-24, 6:33 pm |
| Hi,
Is there a way to get the last couple oof queries an active process
has run. When I run DBCC inputbuffer( spid ), it returns the last query
run. This is not what I am looking for. I would like to know the last
couple of queries that a process ran. Thanks.
Nada
| |
| Paul Ibison 2006-10-24, 6:33 pm |
| Nada,
you'll need to run a Profiler Trace to get this info. Alternatively, if you
must get the queries retrospectively, and you have a copy of Lumigent's Log
Explorer (or equivalent) you could examine the log to get the info.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|
|
|
|
|