I was looking for a way to know who was running a trace and if it was still active or not. I came across this post and it gave me...

I enhanced a script to tell you who's in a database you are trying to use. It also includes fixing orphaned SQL logins that my need to be sync'd with...

I am having a similar problem where someone managed to put a databse into single user mode. Running sp_who and sp_who2 tell me the database is already open and can...