select request_session_id spid,OBJECT_NAME(resource_associated_entity_id) tableName
from sys.dm_tran_locks where resource_type='OBJECT'
杀死进程:
kill spid
SQL server查看表中已存在的索引:
exec sp_helpindex 表名
select request_session_id spid,OBJECT_NAME(resource_associated_entity_id) tableName
from sys.dm_tran_locks where resource_type='OBJECT'
杀死进程:
kill spid
SQL server查看表中已存在的索引:
exec sp_helpindex 表名