September 15, 2009 at 4:59 pm
how to find out the query which is excuted by perticular spid.
September 15, 2009 at 8:00 pm
Off top of my head SQL Profiler would be a good start. However I am sure there is a system table that has the information as well. However the SPID will change each time the query runs. I came across this article that may point you in the right direction:
Get Last Running Query Based on SPID[/url]
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
September 16, 2009 at 7:39 am
charipg (9/15/2009)
how to find out the query which is excuted by perticular spid.
1. DBCC INPUTBUFFER()
2. You can use profiler to capture all queries by that spid
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply