mobile (11/18/2008)
- hacer new query en master.- alter database dbname set emergency
- ALTER DATABASE DBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
- dbcc checkdb ('dbname', repair_allow_data_loss)
- alter database dbname set multi_user
saludos
If you decide to repair_ALLOW_DATA_LOSS be warned that you may not like the results.
My advice is to check first if the problem is in NC indexes pages which you can drop/recreate
If that is not the case you should try to use backups to get the data back.
If you just don't care about the data then doing as posted above may be OK.
In any instance check your hardware !!!
* Noel