Thought I´d inform about a nice little procedure I found today.

I failed to remove a database since there were still users connected. Obviously, I was the one keeping a connection but that doesn’t mean I know where I´m keeping that open connection 🙂

Just run this little nicety:

EXEC sp_who

And you´ll have a neat list of all users, state and databases currently connected.

Why not join the newsletter?

Why not join the newsletter?

If you're not a fan of facebook or twitter, sign up to the newsletter and I'll send you a quick update every so often with what's going on and new posts coming out.

You have Successfully Subscribed!