kill user

Question

Viewing 9 posts - 1 through 8 (of 8 total)

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

Prakash Sawant SSCrazy Points: 2173 More actions · Answer 1

Try killing it from EM.

------------
Prakash Sawant

http://psawant.blogspot.com

SQLRep SSCrazy Points: 2052 More actions · Answer 2

SSCrazy

Points: 2052

June 2, 2006 at 7:01 am

I tried but did not work!!

Maverick100877 SSCertifiable Points: 5240 More actions · Answer 3

Hi

Can u please tell what is the error or problem u r facing while using kill @spid

SQLRep SSCrazy Points: 2052 More actions · Answer 4

There is no error while running kill @spid

i get this

it returns this

SPID 124: transaction rollback in progress. Estimated rollback completion: 100%. Estimated time remaining: 0 seconds.

But the process is still running and did not finished at all!!

Balmukund SSCertifiable Points: 6648 More actions · Answer 5

what is the output of

dbcc inputbuffer(<SPID&gt

Restarting should solve this

sivaprasad SSCertifiable Points: 6183 More actions · Answer 6

Try

KILL {spid} [WITH STATUSONLY]

Statusonly : displays the current progress report.

Also on SP_Who2 output check the staus of the SPID. If it is "Killed/ Rollback" you have restart the SQLServices.

Sivaprasad S - [ SIVA ][/url]http://sivasql.blogspot.com/[/url]

Christian Benvenuto-248082 SSC Enthusiast Points: 163 More actions · Answer 7

You have an orphaned transaction, the only way I know how to get rid of these spids is to stop and start SQL.

Maverick100877 SSCertifiable Points: 5240 More actions · Answer 8

Hi

Yes restarting the server should solve the problem.