SQL Server marked as "suspect" #How to solve

If your SQL Server marked as "suspect" #How to solve it ?

First you must make sure your data file and log file still OK.
Then you use this command , run in ISQLW

update sysdatabases
set status = status & ~256
where name = 'XXXdatabase'

And then if your SQL response this message > Ad hoc updates to system catalogs are not enabled. The system administrator must reconfigure SQL Server to allow this.

You need to run this command

sp_configure 'allow updates',1
go
reconfigure with override





or



exec sp_configure 'allow updates',1
go
reconfigure with override