select * from tableName
它花了很长时间,有些时间没有结果.
目前它只有1排.搜索后我知道它已被锁定所以请帮助解锁或丢弃它？
我解雇下面的查询
SELECT OBJECT_NAME(P.object_id) AS TableName,Resource_type,request_session_id FROM sys.dm_tran_locks L JOIN sys.partitions P ON L.resource_associated_entity_id = p.hobt_id WHERE OBJECT_NAME(P.object_id) = 'P1Chronolog_IncidentActivityUpdates'
并杀死了各自的会议
Kill session_ID
