Long Running Query

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 1

SSC-Forever

Points: 42493

November 9, 2011 at 5:34 am

Stop it with SSMS, if it's in SSMS.

geetha@in Ten Centuries Points: 1175 More actions · Answer 2

Ten Centuries

Points: 1175

November 9, 2011 at 5:41 am

without stoping SSMS is there any other way ?

viiki.seth Ten Centuries Points: 1127 More actions · Answer 3

find the spid of the long running query and kill it

kill spid

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 4

without stoping SSMS is there any other way ?

Are you running it with some other client utility? or other connections (say ODBC) from application? Then find the session & kill it.

KILL (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms173730.aspx

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 5

Also sys.dm_exec_sessions (Transact-SQL)