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.
精彩评论