river1 (7/1/2010)
If a database is suspect what will be is state_desc?
SUSPECT
If a database is in read_only what will be is state_desc?
Probably ONLINE. The is_read_only column (also in sys.databases) will have a value of 1.
I suggest you read the entry on sys.databases in Books Online. It details the possible values for many of the columns.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability