June 3, 2008 at 7:06 am
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,
June 3, 2008 at 7:38 am
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.
June 3, 2008 at 7:41 am
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply