USE Master
EXEC sp_resetstatus [DBNAME];
ALTER DATABASE [DBNAME] SET EMERGENCY
DBCC checkdb([DBNAME])
ALTER DATABASE [DBNAME] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ([DBNAME], REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE [DBNAME] SET MULTI_USER
