Howto see active sessions in a mssql.

Its pretty easy just make a new query, and run sp_who or sp_who2.

sp_who shows whitch active sessions there are, and sp_who2 shows more information about the users.