摘要:MSSQL_查出TABLE LOCK的名稱&ID
SELECT request_session_ID as ID,OBJECT_NAME(RESOURCE_ASSOCIATED_ENTITY_ID) AS TABLENAME
FROM SYS.DM_TRAN_LOCKS WHERE RESOURCE_TYPE='OBJECT'
2012-05-10
MSSQL_查出TABLE LOCK的名稱&ID
- 3058
- 0