Is there a way to list the queries that are currently running on MS SQL Server (either through the Enterprise Manager or SQL) and/or who’s connected?
I think I’ve got a very long running query is being execute on one of my database servers and I’d like to track it down and stop it (or the person who keeps starting it).