Post reply

status = 1077936144 of database in sysdatabases

  • April 19, 2010 at 1:01 am

    #99133

    my database sql2000 shows suspect and shows no items.

    when i checked the status in sysdatabases , the status is 1077936144.

    what does this mean?

  • April 19, 2010 at 11:28 am

    #1154028

    select name, state_desc from sysdatabases

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • April 19, 2010 at 11:41 am

    #1154040

    see this thread:

    http://www.sqlservercentral.com/Forums/Topic326235-5-1.aspx it's got a complete explanation on the flags., as well as a code snippet to plug in your status and get the results on page two: http://www.sqlservercentral.com/Forums/Topic326235-5-2.aspx

    the thread is a few years old, but the answer is the same.

    in your case, these are the flas that are ON:

    TORN_PAGE_DETECTION

    AUTOSHRINK_(ALTER_DATABASE)

    CLEANLY_SHUTDOWN

    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!

  • April 19, 2010 at 10:48 pm

    #1154293

    Hi Lowell,

    thank x for your help.

Viewing 4 posts - 1 through 4 (of 4 total)

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