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