Export (0) Print
Expand All
Expand Minimize

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft