How to repair your database when you get DBCC errors.
Put the database in single user mode.
ALTER DATABASE YourDBName SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
Go;
Then run the following code:DBCC CHECKDB(N'YourDBName', REPAIR_ALLOW_DATA_LOSS);
Then put the database back in multi-user mode.
ALTER DATABASE [YourDBName] SET MULTI_USER;
Go;