EXEC sp_resetstatus ‘yourDatabasename’; 
ALTER DATABASE yourDatabasename SET EMERGENCY 
DBCC checkdb(’yourDatabasename’) 
ALTER DATABASE yourDatabasename SET SINGLE_USER WITH ROLLBACK IMMEDIATE 
DBCC CheckDB (’yourDatabasename’, REPAIR_ALLOW_DATA_LOSS) 
ALTER DATABASE yourDatabasename SET MULTI_USER