Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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, March 28, 2016 2:42 PM
Points: 227, Visits: 745
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: Yesterday @ 7:23 AM
Points: 9,297, Visits: 9,508
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: Today @ 8:15 AM
Points: 14,326, Visits: 37,418
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

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Post #632979
Posted Thursday, January 8, 2009 11:43 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, March 17, 2016 5:13 AM
Points: 2,796, Visits: 2,232
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: Tuesday, January 5, 2016 3:06 AM
Points: 241, Visits: 264
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