ALTER DATABASE dbname SET EMERGENCY;

ALTER DATABASE dbname SET SINGLE_USER

DBCC CHECKDB (dbname, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS;