.png)
EnumLocks Method
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The EnumLocks method returns a QueryResults object that enumerates the resource locks held by an instance of Microsoft SQL Server.
A QueryResults object that contains one result set defined by these columns.
Column | Data type | Description |
|---|---|---|
dbname | nvarchar(129) | Name of the database in which the locked resource is defined. |
indexname | nvarchar(129) | If applicable, the name of the index against which the lock is applied. |
locktype | nvarchar(36) | A text description of a locking mode. For more information about interpreting values, see the description of the system table syslockinfo column req_mode. |
req_spid | integer | Process ID of the process requesting the lock. |
status | tinyint | An integer indicating lock application status. For more information about interpreting values, see the description of the system table syslockinfo column req_status. |
tablename | nvarchar(129) | If applicable, the name of the table against which the lock is applied. |
