Current Activity.greenspun.com : LUSENET : SQL Server Database Administration : One Thread
Eric, I want to see an activity in the server (SQL Server 6.5) but I can't. The locks, users and activity aren't there. But some days ago, I saw them. What do think might have happened?
Your help would be appreciated.
-- Anonymous, June 01, 1999
The stored procedure sp_lock reports on the locks, the stored procedure sp_who reports on the users and activity.
Hope this helps,
-- Anonymous, June 04, 1999