Thursday, May 22, 2014

SP_WHO in SQL Server

Provides information about current users, sessions, and processes in an instance of the Microsoft SQL Server Database Engine. The information can be filtered to return only those processes that are not idle, that belong to a specific user, or that belong to a specific session.

SP_WHO

OR

SP_WHO2

OR

SP_WHO3

OR

SP_WHOISACTIVE