|
 |
About Us | |
|
SSWUG Articles | |
 |
Articles | |
|
FAQ |
 |
Administration | |
|
Backup/Restore | |
|
Connectivity | |
|
Development | |
|
General | |
|
Installation | |
|
OLAP | |
|
Replication | |
|
Transfer/move | |
|
Trouble | |
|
SQL 6.5 |
|
Scripts | |
|
Tips | |
|
Test Exams | |
|
Advertise | |
|
Download | |
|
History | |
|
Search | |
|
Traffic | |
|
Related Links | |
|
||
|
|
||
 How do I report information about current users and processes? Answer: 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. Syntax sp_who2 [[@login_name =] 'login'] Arguments [@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 |