InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 05:26:09 GMT20http://www.sqlservercentral.com/Forums/Topic632939-146-1.aspxI use the bitwise and operator (&) to pull the status column apart for inspection.For example:[code="sql"]SELECT nameFROM master..sysdatabasesWHERE name NOT IN ('tempdb')AND status & 512 <> 512[/code]512 means the database is offline. This query returns a list of database names where the database is online.Mon, 20 Aug 2012 00:44:40 GMTMark Harrison-282986http://www.sqlservercentral.com/Forums/Topic632939-146-1.aspxIt goes like this..4194320 = 4194304 + 164194304 = autoshrink16 = torn page detection4194328 = 4194304 + 16 + 84194304 = autoshrink16 = torn page detection8 = trunc. log on chkptFri, 09 Jan 2009 00:13:17 GMTArun Jebakumarhttp://www.sqlservercentral.com/Forums/Topic632939-146-1.aspxIn BOL; I do not found status value like 4194320, 4194328.What is the status of the database?Thu, 08 Jan 2009 23:43:27 GMTfree_mascothttp://www.sqlservercentral.com/Forums/Topic632939-146-1.aspxsee the thread here:[b][url=http://www.sqlservercentral.com/Forums/Topic326235-5-2.aspx]http://www.sqlservercentral.com/Forums/Topic326235-5-2.aspx[/url][/b]it's got a complete explanation on the flags., as well as a code snippet to plug in your status and get the results.Thu, 08 Jan 2009 17:04:42 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic632939-146-1.aspxThe BOL article on sysdatabases.Thu, 08 Jan 2009 16:14:54 GMTRBarryYounghttp://www.sqlservercentral.com/Forums/Topic632939-146-1.aspxHI,I have 2 databases with the following status in sysdatabases (4194320, 4194328). Where I can find the definition of these status?Thanks,Thu, 08 Jan 2009 15:39:58 GMTRem70Rem