It looks like they are just adding the bit values for each option/condition
together to get a single status value. Try running sp_helpdb and
sp_dboption to verify your settings.

Status
1073741840 = 1073741824 (cleanly shutdown) + 16 (torn page detection
enabled)

Status2
1090519040 = 1073741824 (Auto Update Statistics) + 16777216 (auto create
statistics)

Kevin Martin
Database Engineer
Multimedia Games, Inc.




-----Original Message-----
From: Chip Smith [mailto:[Email Address Removed] Wednesday, September 03, 2003 12: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?)

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 8/19/2003


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 8/19/2003

MS Sql Server LazyDBA home page