关闭数据库未关闭的事务
declare @did int
select @did=request_session_id from sys.dm_tran_locks where resource_type = 'OBJECT' and resource_database_id =DB_ID('数据库名')
kill @did
declare @did int
select @did=request_session_id from sys.dm_tran_locks where resource_type = 'OBJECT' and resource_database_id =DB_ID('数据库名')
kill @did