Reply To: How to Resolve MS SQL Error 824?

Try this:

ALTER DATABASE corrupted_db SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC ChECKDB ('corrupted_db', REPAIR_ALLOW_DATA_LOSS) 
ALTER DATABASE corrupted_db SET MULTI_USER

but there is very high chance of data loss