USE MASTER
GOSP_CONFIGURE 'ALLOW UPDATES',1
RECONFIGURE WITH OVERRIDE
GOUPDATE SYSDATABASES SET STATUS =32768 WHERE NAME='ABCD'
Gosp_dboption 'ABCD', 'single user', 'true'
GoDBCC CHECKDB('ABCD')
Goupdate sysdatabases set status =28 where name='ABCD'
Gosp_configure 'allow updates', 0 reconfigure with override
Go sp_dboption 'ABCD', 'single user', 'false'
Go
GOSP_CONFIGURE 'ALLOW UPDATES',1
RECONFIGURE WITH OVERRIDE
GOUPDATE SYSDATABASES SET STATUS =32768 WHERE NAME='ABCD'
Gosp_dboption 'ABCD', 'single user', 'true'
GoDBCC CHECKDB('ABCD')
Goupdate sysdatabases set status =28 where name='ABCD'
Gosp_configure 'allow updates', 0 reconfigure with override
Go sp_dboption 'ABCD', 'single user', 'false'
Go
重启sql服务后, 再到企业管理器中, 看看数据库是否设置为只读属性, 如果是, 则去掉它.