Determining what a SQL Server connection is doing
Quick note here describing how to find out what a connection to a Microsoft SQL Server is doing. First you need to find the connection.
Display current connections
Use the sp_who2 stored procedure to find the current connections. Use the following information to determine the connection of interest.
SPID - The ID of the connection. You will need [...]

