• Got a Tipila, google, windows live or facebook account ?

Use this to fix the above error in SQL server

ALTER DATABASE dbname SET EMERGENCY;
GO
ALTER DATABASE dbname SET SINGLE_USER;
GO
DBCC CHECKDB (dbname , REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS;
GO
use dbname 
go
DBCC CHECKDB
ALTER DATABASE dbname SET MULTI_USER;
GO   

Note DO NOT do this to a production db as it might cause a data loss

0
votes
Login to Tipila