List the users connected to a MS Sql server

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...