sp_configure 'allow updates',1 go reconfigure with override go use master update sysdatabases set status =-32768 where name='数据库名' go sp_configure 'allow updates',0 go reconfigure with overrideselect * from sysdatabasessp_configure 'allow updates',1 go reconfigure with override go use master update sysdatabases set status =0 where name='数据库名' go sp_configure 'allow updates',0 go reconfigure with overrideselect * from sysdatabases
go
reconfigure with override
go
use master
update sysdatabases set status =-32768 where name='数据库名'
go
sp_configure 'allow updates',0
go
reconfigure with overrideselect * from sysdatabasessp_configure 'allow updates',1
go
reconfigure with override
go
use master
update sysdatabases set status =0 where name='数据库名'
go
sp_configure 'allow updates',0
go
reconfigure with overrideselect * from sysdatabases