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