22,209
社区成员
发帖
与我相关
我的任务
分享
use master
go
exec sp_configure 'allow updates',1
go
reconfigure with override
go
update sysdatabases set status=-32768 where dbid=DB_ID('MHDYF2005')
dbcc rebuild_log
('MHDYF2005','C:\Program Files\Microsoft
SQL Server\MSSQL\Data\MHDYF2005_log.ldf')
dbcc checkdb ('MHDYF2005')
sp_dboption 'MHDYF2005','dbo use only','false'
sp_configure 'allow updates',0
go
reconfigure with override
go