db Suspect
ALTER DATABAS DB SET EMERGENCY
ALTER DATABAS DB SET SINGLE_USER
DBCC CHECKDB (emergencydemo, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS
ALTER DATABASE DB SET EMERGENCY
ALTER DATABASE DB SET SINGLE_USER
DBCC CHECKDB (emergencydemo, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS
use master
go
sp_configure ‘allow updates’,1
go
reconfigure with override
go
update sysdatabases
set status=status|-32768
where name=’ProdCentar_2005′