Suspect Question

I am created a new data. I writing a query as

"select status from sysdatabases where name= 'db_name'"

I am receiving the following result.

"665526"

But, this result must be is "1077936153".

sp_configure 'allow updates',1

Reco开发者_Python百科nfigure WITH OVERRIDE

After writing ;

update sysdatabases set status = 32768 where name='db_name' 

it's not updating.What's the problem here?

thanks in advance.

Updating sysdatabases was a way of setting the database in emergency mode in SQL 6.5 and 7.0. If you're running a newer version of the server, use sp_resetstatus and ALTER DATABASE SET EMERGENCY to achieve this. You can then investigate what caused the suspect state, and try to repair the database.