How do I report information about current users and processes?
To report information about current users and processes, you can use
the sp_who and sp_who2 system stored procedures. The sp_who system
stored procedure described in SQL Server Books Online, the sp_who2
is unducumented stored procedure. sp_who2 provides more detailed
information about current users and processes than sp_who.
The sp_who2 syntax is equal to sp_who.
sp_who2 [[@login_name =] 'login']
[@login_name =] 'login'
Is a user login name on SQL Server. login is sysname, with a default of NULL.
If no name is specified, the procedure reports all active users of SQL Server.
See also these links:
SQL Server 7.0 Useful undocumented stored procedures
SQL Server 2000 Useful undocumented stored procedures