USE MASTER GO SP_CONFIGURE 'ALLOW UPDATES',1GORECONFIGURE WITH OVERRIDE GO UPDATE SYSDATABASES SET STATUS =32768 WHERE NAME='GameLog' Go sp_dboption 'GameLog','single user','true' Go DBCC CHECKDB('GameLog') Go update sysdatabases set status=28 where name='GameLog' Go sp_configure 'allow updates',0GOreconfigure with override Go sp_dboption 'GameLog', 'single user','false' Go
USE MASTER GO SP_CONFIGURE 'ALLOW UPDATES',1GORECONFIGURE WITH OVERRIDE GO UPDATE SYSDATABASES SET STATUS =32768 WHERE NAME='GameLog' Go sp_dboption 'GameLog','single user','true' Go DBCC CHECKDB('GameLog') Go update sysdatabases set status=28 where name='GameLog' Go sp_configure 'allow updates',0GOreconfigure with override Go sp_dboption 'GameLog', 'single user','false' Go