The value shown is the sum of the applicable codes as shown in BOL

e.g. 1073741840 seems to be

1073741824 = cleanly shutdown
+ 32 = loading
+ 16 = torn page detection, set with sp_dboption
+ 8 = trunc. log on chkpt; set with sp_dboption

> -----Original Message-----
> From: Chip Smith [SMTP:[Email Address Removed] Sent: Wednesday, September 03, 2003 6:56 PM
> To: LazyDBA.com Discussion
> Subject: SQL SERVER-SYSDATABASES Question
>
> Can anyone interpret the sysdatabases status columns?
> STATUS STATUS2
> 1073741840 1090519040
> And if so, how?
> BOL Makes no sense! (so what else is old?)
MS Sql Server LazyDBA home page