Who is in SQL?


Who is in SQL? 

SQL Server Management Studio >> New Query >> exec sp_who2

This will list the users logged into specific databases, especially useful if you need to force kill the sessions.

New Query >> Kill ‘spid’

eg. Kill 11




The following two tabs change content below.

Andy, Software Engineer

Andy is Software Engineer at Metaphorix