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.

Author:

2 thoughts on “MSSQL Emergency Mode”

Leave a Reply

Your email address will not be published. Required fields are marked *

Notify me of followup comments via e-mail. You can also subscribe without commenting.