Model.mdb

Question

Model.mdb

Ron McCullough

SSC Guru

Points: 63877
More actions
April 14, 2010 at 9:45 pm

#213807

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]

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

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

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

Christian Buettner-167247 SSChampion Points: 13729 More actions · Answer 2

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

Adrian Chapman Hall of Fame Points: 3162 More actions · Answer 3

Adrian Chapman

Hall of Fame

Points: 3162

April 15, 2010 at 2:29 am

#1151951

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

James Lean SSCertifiable Points: 5757 More actions · Answer 4

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

Good question though, I was unaware these limitations existed.

-----
JL

Chris Houghton SSCrazy Points: 2557 More actions · Answer 5

Chris Houghton

SSCrazy

Points: 2557

April 15, 2010 at 3:09 am

#1151964

An interesting and informative question. Thanks

craigpessano SSCertifiable Points: 5358 More actions · Answer 6

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.

Christian Buettner-167247 SSChampion Points: 13729 More actions · Answer 7

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

James Lean SSCertifiable Points: 5757 More actions · Answer 8

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

-----
JL

croberts 36762 SSC Eights! Points: 972 More actions · Answer 9

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

Christian Buettner-167247 SSChampion Points: 13729 More actions · Answer 10

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

jcrawf02 SSC-Insane Points: 24198 More actions · Answer 11

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."

Tom Garth SSCertifiable Points: 6193 More actions · Answer 12

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

croberts 36762 SSC Eights! Points: 972 More actions · Answer 13

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

TheRedneckDBA SSChampion Points: 14001 More actions · Answer 14

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