Home Forums SQL Server 2008 SQL Server Newbies trying to KILL a SPID, getting 'Cannot use KILL to kill your own process.' RE: trying to KILL a SPID, getting 'Cannot use KILL to kill your own process.'

  • OK, coincidence that my last query should have been a SELECT INTO.

    Yes, Bhuvnesh, I think restarting SQL Server should have reset the numbers for SPID 54. Besides, I wasn't repeatedly running sp_who2 like a maniac, or anything.

    Clearly, there is some spid hanging and the only one in the sp_who2 report for Sandbox is SPID 54. All the other SPIDS are for the other databases in my instance, like master, msdb, and others.

    I just tried to delete Sandbox db, BUT, SQL Server won't let me.

    Something, and if it isn't SPID 54 I don't know how to find out what is, is preventing me from *even deleting* the db. I get error:

    "Cannot drop database "Sandbox" because it is currently in use."

    What to do. I am now ready to delete the db and I thought that was pretty broad stroke to fix problem. Perhaps tossing the laptop wouldn't be a solution either:w00t:. Any other suggestions pl-easse?

    --Quote me