Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Sysdatabases Status Expand / Collapse
Author
Message
Posted Thursday, January 8, 2009 3:39 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, September 8, 2014 11:34 AM
Points: 218, Visits: 712
HI,

I have 2 databases with the following status in sysdatabases (4194320, 4194328). Where I can find the definition of these status?

Thanks,

Post #632939
Posted Thursday, January 8, 2009 4:14 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 9:14 AM
Points: 9,294, Visits: 9,483
The BOL article on sysdatabases.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #632961
Posted Thursday, January 8, 2009 5:04 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 1:11 PM
Points: 12,905, Visits: 32,161
see the thread here:http://www.sqlservercentral.com/Forums/Topic326235-5-2.aspxit's got a complete explanation on the flags., as well as a code snippet to plug in your status and get the results.


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #632979
Posted Thursday, January 8, 2009 11:43 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
In BOL; I do not found status value like 4194320, 4194328.

What is the status of the database?


---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #633111
Posted Friday, January 9, 2009 12:13 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, October 3, 2013 4:22 AM
Points: 241, Visits: 263
It goes like this..

4194320 = 4194304 + 16

4194304 = autoshrink
16 = torn page detection

4194328 = 4194304 + 16 + 8

4194304 = autoshrink
16 = torn page detection
8 = trunc. log on chkpt
Post #633122
Posted Monday, August 20, 2012 12:44 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, August 18, 2013 10:04 PM
Points: 21, Visits: 48
I use the bitwise and operator (&) to pull the status column apart for inspection.

For example:

SELECT 
name
FROM
master..sysdatabases
WHERE
name NOT IN ('tempdb')
AND
status & 512 <> 512

512 means the database is offline. This query returns a list of database names where the database is online.
Post #1347005
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse