USE MASTER
GO

SP_CONFIGURE 'ALLOW UPDATES',1 RECONFIGURE WITH OVERRIDE
GO

UPDATE SYSDATABASES SET STATUS =32768 WHERE NAME='BOOKSTORE'
Go

sp_dboption 'BOOKSTORE', 'single user', 'true'
Go

ALTER DATABASE [BOOKSTORE] SET SINGLE_USER


DBCC CHECKDB('BOOKSTORE',REPAIR_ALLOW_DATA_LOSS) 
Go

dbcc rebuild_log('BOOKSTORE','d:\BOOKSTORE_log.ldf') 

update sysdatabases set status =28 where name='BOOKSTORE'
Go

sp_configure 'allow updates', 0 reconfigure with override
Go 

sp_dboption 'BOOKSTORE', 'single user', 'false'
Go


DBCC   CHECKTABLE   ( 'book',REPAIR_ALLOW_DATA_LOSS) 


DBCC CHECKTABLE (sysobjects,REPAIR_REBUILD)
DBCC CHECKTABLE (sysindexes,REPAIR_REBUILD)
DBCC CHECKTABLE (syscolumns,REPAIR_REBUILD )
DBCC CHECKTABLE (systypes,REPAIR_REBUILD)

dbcc CHECKTABLE (sysindexes, repair_allow_data_loss)
DBCC CHECKTABLE (syscolumns, repair_allow_data_loss)

select * from sysobjects

select top 10 * from book