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