Can anyone assist in troubleshooting one issue at my end.
Using dbcc inputbuffer (spid) will give the current command that the process is executing.
My question is how exactly we can find the exact query that the user has submitted to the sql server.
The reason i was looking at it was because of some heavy blockings on the server, i used sp_who2 and found an spid which is causing huge blocking on the server. But when i used dbcc inputbuffer it is showing as an Insert command (Might be an inserts into the
tempDB) and it is not the exact Insert command because the application where user's use to connect has no insert function on it.
Is there any way to find the exact t-sql that the user has issued.
View Complete Post