USE master GO ALTER DATABASE DEMO SET SINGLE_USER GO ALTER DATABASE DEMO SET EMERGENCY GO DBCC CHECKDB(DEMO,REPAIR_ALLOW_DATA_LOSS) GO ALTER DATABASE DEMO SET ONLINE GO ALTER DATABASE DEMO SET MULTI_USER GO
USE master GO ALTER DATABASE DEMO SET SINGLE_USER GO ALTER DATABASE DEMO SET EMERGENCY GO DBCC CHECKDB(DEMO,REPAIR_ALLOW_DATA_LOSS) GO ALTER DATABASE DEMO SET ONLINE GO ALTER DATABASE DEMO SET MULTI_USER GO