There are a few undocumented things about the MSSQL Server 2000 missing in the knowledgebase of Microsoft. That’s a way to get a database marked as suspect into emergency mode:
use[master] go execute sp_configure 'allow updates',1 reconfigure with override go update sysdatabases set status =32768 where name ='
Restart the database server and you’re done. For reverting stuff, that’s the way to do it:
use[master] go update sysdatabases set status = 0 where name ='
' go execute sp_configure 'allow updates',0 reconfigure with override
Restarting is also needed here.