Posted by SQL on 09/26/05 17:17

Yes you can clear it
run spWho2 find your login and spID
run DBCC INPUTBUFFER (spID) to verify that it is the correct SQL
statement (if you have multiple sessions open)
run the following command KILL spID
The spID will be greater than 50, everything below 50 is used by SQL
Server

http://sqlservercode.blogspot.com/

[Back to original message]