EnumLocks Method
TOC
Collapse the table of content
Expand the table of content

Server.EnumLocks Method

Enumerates a list of current locks held on the instance of SQL Server.

This member is overloaded. For complete information about this member, including syntax, usage, and examples, click a name in the overload list.

  NameDescription
Public method EnumLocks() Enumerates a list of current locks held on the instance of SQL Server.
Public method EnumLocks(Int32) Enumerates a list of current locks held by the specified process on the instance of SQL Server.
Top

Use this method to determine the locks that are currently held on the instance of SQL Server. The information that is returned can help you identify locking problems that might affect performance.

Community Additions

ADD
Show:
© 2016 Microsoft