Model.mdb

  • Comments posted to this topic are about the item Model.mdb

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • Thanks Ron. Excellent Question.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Am I missing something? I can actually set the database to read-only:

    ALTER DATABASE MODEL SET READ_ONLY WITH NO_WAIT

    Command(s) completed successfully.

    Microsoft SQL Server 2005 - 9.00.4053.00 (Intel X86) May 26 2009 14:24:20

    Best Regards,

    Chris Büttner

  • Yes, I can set model to read only on 2008 10.0.2531

  • Agreed, I can set model to read-only on 2005 and 2008.

    Good question though, I was unaware these limitations existed.

    -----
    JL

  • An interesting and informative question. Thanks

  • James Lean (4/15/2010)


    Agreed, I can set model to read-only on 2005 and 2008.

    Good question though, I was unaware these limitations existed.

    Ditto. According to BOL the model database cannot be set to READ_ONLY, but in reality it can on both 2005 and 2008. I tried it on 2000 as well. All three versions allow it.

  • According to http://technet.microsoft.com/en-us/library/ms186388.aspx it can NOT be set as read_only:

    The following operations cannot be performed on the model database:

    Setting the database or primary filegroup to READ_ONLY.

    Oh wait... according to the same document, it CAN be set as read_only:

    Database option Default value Can be modified

    ----------------------------- -------------- ----------------

    Database Availability Options READ_WRITE YES

    So talk about confusion:)

    Best Regards,

    Chris Büttner

  • Chris, I'm sure you know by now not to trust everything you read in BOL! 😉

    -----
    JL

  • As already noted, the model database can be set to read-only. Before posting a question, how about actually trying it out?

  • James Lean (4/15/2010)


    Chris, I'm sure you know by now not to trust everything you read in BOL! 😉

    True, true, but I even don't trust my own stuff occasionally:D

    Best Regards,

    Chris Büttner

  • croberts 36762 (4/15/2010)


    As already noted, the model database can be set to read-only. Before posting a question, how about actually trying it out?

    lol and if it didn't work, you'd be complaining that the answer was wrong because BOL also says it CAN. I think this was a fair question, and informative.

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • I wasn't sure of the answers so I looked it up. That makes it a good QotD even though 1 of the answers is suspect.

    Thanks,

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers
  • I like the Will Rogers qoute in your signature line, Tom. It is appropriate to the discussion.

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

  • croberts 36762 (4/15/2010)


    As already noted, the model database can be set to read-only. Before posting a question, how about actually trying it out?

    Interesting thought...It just occurred to me that more points probably end up getting awarded for suspect questions than more obvious questions because of the number of people post in the discussion complaining about them and get their points that way...

    The Redneck DBA

Viewing 15 posts - 1 through 15 (of 35 total)

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