数据库置疑.sql

来自「SQL语言常用的一些命令各代码」· SQL 代码 · 共 39 行

--数据库置疑状态脚本
USE MASTER
GO
SP_CONFIGURE 'ALLOW UPDATES',1 RECONFIGURE WITH OVERRIDE
GO
UPDATE SYSDATABASES SET STATUS =32768 WHERE NAME='sccdpoitest'
Go
sp_dboption 'sccdpoitest', 'single user', 'true'
Go
DBCC CHECKDB('sccdpoitest') 
Go
update sysdatabases set status =28 where name='sccdpoitest'
Go
sp_configure 'allow updates', 0 reconfigure with override
Go 
sp_dboption 'sccdpoitest', 'single user', 'false'
Go


--简易版
declare @dbname varchar(100)
set @dbname='testdb'
USE MASTER

exec('SP_CONFIGURE ''ALLOW UPDATES'',1 RECONFIGURE WITH OVERRIDE')

exec('UPDATE SYSDATABASES SET STATUS =32768 WHERE NAME='''+@dbname+'''')

exec('sp_dboption '+@dbname+',''single user'', ''true''')

exec('DBCC CHECKDB('''+@dbname+''') ')

exec('update sysdatabases set status =28 where name='''+@dbname+'''')

exec('sp_configure ''allow updates'', 0 reconfigure with override')

exec('sp_dboption '''+@dbname+''', ''single user'', ''false''')