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

Andy

 

 

The following two tabs change content below.

Andy, Software Engineer

Andy is Software Engineer at Metaphorix