Monday, 20 July 2015

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
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)