jpage01 (5/30/2010)
Msg 7909, Level 20, State 1, Line 1The emergency-mode repair failed.You must restore from backup.DBNAME
That says it all. Emergency mode is the very last resort, if it fails, there's nothing else that can be done. I hope you have a backup somewhere. If not, why the hell not if the DB is so critical?
p.s. You shouldn't even be considering modifying the system tables. It's a near guarantee of further further damage, especially on SQL 2005+ where 'tables' like systables aren't tables but views and the system tables are hidden, completely undocumented and reasonably complex
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