USE MASTER
GO SP_CONFIGURE 'ALLOW UPDATES',1 RECONFIGURE WITH OVERRIDE
GO ALTER DATABASE DataValidation SET EMERGENCY
GO sp_dboption DataValidation 'single user', 'true'
GO DBCC CHECKDB(' DataValidation ','REPAIR_ALLOW_DATA_LOSS')
GO ALTER DATABASE DataValidation SET ONLINE
GO sp_configure 'allow updates', 0 reconfigure with override
GO sp_dboption ' DataValidation ', 'single user', 'false'
GO
GO SP_CONFIGURE 'ALLOW UPDATES',1 RECONFIGURE WITH OVERRIDE
GO ALTER DATABASE DataValidation SET EMERGENCY
GO sp_dboption DataValidation 'single user', 'true'
GO DBCC CHECKDB(' DataValidation ','REPAIR_ALLOW_DATA_LOSS')
GO ALTER DATABASE DataValidation SET ONLINE
GO sp_configure 'allow updates', 0 reconfigure with override
GO sp_dboption ' DataValidation ', 'single user', 'false'
GO