MSSQL Emergency Mode

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 =''
go

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.