EXEC sp_resetstatus [database];


ALTER DATABASE [database] SET EMERGENCY


DBCC checkdb([database])


ALTER DATABASE [database] SET SINGLE_USER WITH ROLLBACK IMMEDIATE

DBCC CheckDB ([database], REPAIR_ALLOW_DATA_LOSS)


ALTER DATABASE [database] SET MULTI_USER