detect suspect

Question

How To detect the suspect database in SQL server2000 With Script Or Program ?

Answer 1

the status column in master.dbo.sysdatabases will have the suspect bit set which is 256 for the database. in which case this will return a result:

select  * from sysdatabases where status&256 = 256