Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
How to view the current locks (Enterprise Manager)
Collapse the table of content
Expand the table of content

How to view the current locks (Enterprise Manager)

SQL Server 2000

How to view the current locks (Enterprise Manager)

To view the current locks

  1. Expand a server group, and then expand a server.

  2. Expand Management, and then expand Current Activity.

  3. Do one of the following:
    • Expand Locks / Process ID to view the current locks for each connection.

    • Expand Locks / Object to view the current locks for each object.
  4. In the console tree, click the connection (SPID) or object to view.

    The current locks for the connection or object are displayed in the details pane.

See Also

Displaying Locking Information

Monitoring with SQL Server Enterprise Manager

Monitoring with Transact-SQL Statements

Understanding Locking in SQL Server

Show:
© 2015 Microsoft