SQLServer Object
Lists the locks held by a SQL Server process. List is returned in a QueryResults object.
QueryResults = SQLServer.EnumLocks ( [[WhoByID :=] lProcess] )
HRESULT pSQLServer->EnumLocks (
LPSQLOLEQUERYRESULTS* ppQueryResults,
long lProcess = -1 );
| Element | Type | Description |
|---|
| QueryResults | QueryResults | Returned QueryResults object |
| lProcess | Long | Process |
| ColumnName | ColumnType |
|---|
| spid | SQLOLE_DTypeInt2 |
| locktype | SQLOLE_DTypeChar |
| tablename | SQLOLE_DTypeChar |
| page | SQLOLE_DTypeInt4 |
| dbname | SQLOLE_DTypeChar |
sp_lock