--查找那个表里还有数据如果差全部表那就把as tt where tt.datacount>1 去掉
select* from(
select b.name as tablename ,
c.row_count as datacount
from sys.indexes a ,
sys.objects b ,
sys.dm_db_partition_stats c
where a.[object_id] = b.[object_id]
AND b.[object_id] = c.[object_id]
AND a.index_id = c.index_id
AND a.index_id < 2 and b.type='U') as tt where tt.datacount>1
对SQL SERVER数据库进行脱机操作,提示“”无法在数据库上放置锁“”报错,脱机失败,解决办法如下:
通过命令查询得到当前DB的session,然后将对应的SPID KILL掉,重新脱机操作即可,命令如下:
EXEC sp_who2
KILL SPID
注:SPID就是执行"EXEC sp_who2 "查询得到的相应的数据库的SPID一列的值,可能会有多个,都要kill掉