How to kill this process? help m

• p1naga

  SSC Veteran

  Points: 296

  More actions

  December 13, 2007 at 8:31 am

  #69475

  Hi

  I killed a spid 2 days back. Still i can see it in current activity console.

  In the command column in current activity console it shows " killed\rollback".

  Is it still in rollback process?

  If not how to kill this?

  Thanks in advance

• cy-dba

  SSCarpal Tunnel

  Points: 4179

  More actions

  December 14, 2007 at 7:11 am

  #760228

  Try stopping/re-starting SQL Server.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736270

  More actions

  December 14, 2007 at 7:57 am

  #760251

  This has happened at times in 2000, and as mentioned above, the only thing to do is stop and restart SQL Server.