Repair Database (DB)

use master
DBCC CHECKDB (DBNAME) WITH NO_INFOMSGS, ALL_ERRORMSGS
ALTER DATABASE DBNAME SET EMERGENCY
ALTER DATABASE DBNAME SET SINGLE_USER
DBCC CHECKDB (DBNAME, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS;
DBCC CHECKDB (DBNAME, repair_fast)
DBCC CHECKDB (DBNAME, repair_rebuild)
DBCC CHECKDB (DBNAME, repair_allow_data_loss)
DBCC CHECKDB WITH NO_INFOMSGS;
ALTER DATABASE DBNAME SET MULTI_USER