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