unable to kill sleeping spid

• Sanaullah

  SSC Eights!

  Points: 892

  More actions

  June 3, 2008 at 7:06 am

  #121784

  Hi all,

  I want to resore the database but some online user is logged in and is in sleeping mode, when i run sp_who 'user name' its gives this message

  72 0 sleeping username 89711- 0 IntranetsNew AWAITING COMMAND

  spid=72

  i am unable to kill this id,

  Its urgent..........

  Sanaullah,

• Animal Magic

  SSChampion

  Points: 13964

  More actions

  June 3, 2008 at 7:38 am

  #823606

  why are you unable to kill the spid? is there an error message saying you cant?

  if you have issues a kill statement issue it again using with statusonly (kill 72 with statusonly) and see how long that says it will take to rollback.

• skyline666

  Ten Centuries

  Points: 1209

  More actions

  June 3, 2008 at 7:41 am

  #823608

  EDIT*

  To save some time, I would give this a read first:

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

  I haven't done anything to do with this, but took a look around anyway and find this so far:

  http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=101200

  Seems that you use KILL. I took a quick look for KILL spid and found this which may also be useful:

  http://weblogs.sqlteam.com/tarad/archive/2007/02/08/60083.aspx