Use Undocumented SP_WHO2 Procedure Instead of SP_WHO for SQL Server 7.0
The sp_who internal procedure allows users to view current activity on the database. This command provides a view into several system tables (e.g., syslocks, sysprocesses, etc.). The sp_who command returns