Model.mdb

Question

Model.mdb

Viewing 5 posts - 31 through 34 (of 34 total)

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

m--S3qU3L Hall of Fame Points: 3706 More actions · Answer 1

Lost my points too because of the READ_ONLY option.

But I found experiments on MODEL regarding the collation - http://sqlmusings.wordpress.com/2008/10/11/fixing-collation-the-experiments/

John

Paul White SSC Guru Points: 150467 More actions · Answer 2

A bit unfortunate about the read only option. An interesting QotD might have been "True or False: The model database can be set to READ_ONLY" ... that would have caught a lot of people out, I think.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Paul White SSC Guru Points: 150467 More actions · Answer 3

I've just noticed that this question's title is Model.mdb...ok so *.mdf is not enforced, but why mdb - does Access have a model database too? 😉 😛

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

sharath.chalamgari SSCertifiable Points: 5680 More actions · Answer 4

sharath.chalamgari

SSCertifiable

Points: 5680

April 30, 2010 at 12:15 am

#1160210

More info, we can refer to this URL:

Imran Ashraf-452633 SSCommitted Points: 1969 More actions · Answer 5

As per the numerous people that have quoted you can set the DB to READ ONLY for model.

The others are not allowed as it is a system DB.

So in short I want my points

😀