Paul Randal (2/26/2008)
faheemlatif (2/26/2008)
Hi,Please visit this :
http://www.simple-talk.com/sql/backup-and-recovery/pop-rivett-and-the-suspect-database/
That would be a bit useful if they were on SS2000, but they're not. Please check which forum you're in before posting inappropriate links - thanks!
Ouch, harsh ... if you scroll down, there is a link to the msdn BOL of ALTER database, which provides the syntax for putting the database into emergency mode (ALTER DATABASE mydb SET EMERGENCY). So the link is somewhat appropriate.
Also, great explanation of the problem though!