sql2000 fix
时间：2021-07-01 10:21:17
帮助过：4人阅读
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
sql2000 fix
标签：set data merge 软件 span name rri false where
