Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

The Model Database Expand / Collapse
Author
Message
Posted Monday, February 17, 2014 8:12 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 5:33 AM
Points: 2,794, Visits: 2,216
Comments posted to this topic are about the item The Model Database

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1542334
Posted Monday, February 17, 2014 8:21 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 2:55 PM
Points: 19,580, Visits: 17,831
Thanks for the question.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1542337
Posted Monday, February 17, 2014 11:58 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 2:07 PM
Points: 15,016, Visits: 12,988

The following operations cannot be performed on the model database:
...
Setting the primary filegroup to READ_ONLY.


Damn you MSDN!




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1542387
Posted Tuesday, February 18, 2014 12:46 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 2:03 PM
Points: 1,890, Visits: 6,981
Koen Verbeeck (2/17/2014)

The following operations cannot be performed on the model database:
...
Setting the primary filegroup to READ_ONLY.


Damn you MSDN!


+1!!!!!!



On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher

How to post a question to get the most help
Post #1542399
Posted Tuesday, February 18, 2014 1:16 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 3:38 AM
Points: 1,177, Visits: 1,775
I also got it wrong after reading MSDN .
Post #1542404
Posted Tuesday, February 18, 2014 1:20 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, February 3, 2016 10:58 PM
Points: 2,356, Visits: 1,063
Koen Verbeeck (2/17/2014)

The following operations cannot be performed on the model database:
...
Setting the primary filegroup to READ_ONLY.


Damn you MSDN!

+ 1
Post #1542405
Posted Tuesday, February 18, 2014 1:24 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, February 3, 2016 10:58 PM
Points: 2,356, Visits: 1,063
Just a simple & basic info to share: "if you changed the model database to Read-Only mode; then any newly created database will be in Read-Only mode by default".
Post #1542406
Posted Tuesday, February 18, 2014 1:28 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 2:07 PM
Points: 15,016, Visits: 12,988
Hany Helmy (2/18/2014)
Just a simple & basic info to share: "if you changed the model database to Read-Only mode; then any newly created database will be in Read-Only mode by default".


That must be useful. Empty databases on read-only mode.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1542407
Posted Tuesday, February 18, 2014 1:53 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 3:22 AM
Points: 4,897, Visits: 6,584
Hany Helmy (2/18/2014)
Just a simple & basic info to share: "if you changed the model database to Read-Only mode; then any newly created database will be in Read-Only mode by default".


really useful....


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1542415
Posted Tuesday, February 18, 2014 3:36 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 11:18 AM
Points: 9,108, Visits: 11,016
Koen Verbeeck (2/18/2014)
Hany Helmy (2/18/2014)
Just a simple & basic info to share: "if you changed the model database to Read-Only mode; then any newly created database will be in Read-Only mode by default".


That must be useful. Empty databases on read-only mode.

Very useful - a database guaranteed to contain no corrupt data as long as no-one with enough privileges changes its state.


Tom
Post #1542446
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse