Post reply

Status in master.sysdatabases

  • May 12, 2006 at 9:22 am

    #113435

    Hi

    The status field shows some values for the databases which have no mention in the BOL. Like for a few databases I see the value as 24,28,1073741840 which is nowhere mentioned in BOL.

    So how do u interprete these staus values??I'm a bit confused with this..

  • May 12, 2006 at 10:37 am

    #637631

    The statuses shown in BOL are bit patterns.  So a db with status 24 is one with Torn Page (16) and Trunc Log (8).

    The use of bit patterns in status columns applies in some other system tables as well.

  • May 12, 2006 at 1:02 pm

    #637676

    You can run sp_helpdb to get all the options that are enabled and interpret what the values mean.

    HTH,

    Mark

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply