GRE-452109 (1/15/2010)
I''ll send you to Paul Randal's blog post here...
In this case the database is not suspect or recovery_pending, hence there is no need to switch to emergency mode. That blog post deals with the case when the DB is suspect and cannot be opened, not the case of simple corruption.
A better link might be this: http://www.sqlservercentral.com/articles/65804/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability