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′