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.

Thanks, Patricia.

-- Anonymous, June 01, 1999

Answers

Patricia,

The stored procedure sp_lock reports on the locks, the stored procedure sp_who reports on the users and activity.

Hope this helps,

Eric

-- Anonymous, June 04, 1999


Moderation questions? read the FAQ