sql2000 fix
标签：set data merge 软件 span name rri false where
sql2000 fix
master
go
sp_configure ‘allow updates‘,1
go
reconfigure with override
update sysdatabases set status=32768 where dbid=DB_ID(‘ypsxyy20160527‘)
dbcc rebuild_log
(‘ypsxyy20160527‘,‘D:\亚讯医药软件20160526\YpsxYY.ldf‘)
exec sp_dboption ‘ypsxyy20160527‘, ‘single user‘, ‘false‘
update sysdatabases set status =28 where name=‘ypsxyy20160527‘
ALTER DATABASE ypsxyy20160527 SET SINGLE_USER ----???????????
DBCC CheckDB (ypsxyy20160527,REPAIR_ALLOW_DATA_LOSS) ----?????
DBCC CheckDB (ypsxyy20160527),REPAIR_REBUILD) ----??
ALTER DATABASE ypsxyy20160527 SET MULTI_USER ----?????
alter database ypsxyy20160527 set EMERGENCY
alter database ypsxyy20160527 set online