EnumLocks Method
Questa funzionalità verrà rimossa in una delle prossime versioni di Microsoft SQL Server. Evitare di utilizzare questa funzionalità in un nuovo progetto di sviluppo e prevedere interventi di modifica nelle applicazioni in cui è attualmente implementata.
The EnumLocks method returns a QueryResults object that enumerates the resource locks held by an instance of Microsoft SQL Server.
Sintassi
object
.EnumLocks( [ Who ] )as QueryResults
Parts
- object
Expression that evaluates to an object in the Applies To list.
- Who
Optionally restricts output by process identifier.
Prototype (C/C++)
HRESULT EnumLocks(
LPSQLDMOQUERYRESULTS* ppResults,
long Who = -1);
Returns
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. |
Osservazioni
When restricting the QueryResults object content using the Who argument, use the process ID that identifies the login or other process targeted. The EnumProcesses method can help identify a target process.
Applies To:
Vedere anche
Riferimento
Altre risorse
sys.syslockinfo (Transact-SQL)