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