Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: Friday, March 20, 2015 5:52 AM
Points: 2,643, Visits: 2,070
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: Today @ 2:38 PM
Points: 18,396, Visits: 16,560
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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:06 PM
Points: 14,172, Visits: 12,150

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

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

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Today @ 8:00 AM
Points: 1,450, Visits: 4,911
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
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 5:15 AM
Points: 948, Visits: 1,563
I also got it wrong after reading MSDN .
Post #1542404
Posted Tuesday, February 18, 2014 1:20 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 5:57 AM
Points: 1,881, Visits: 798
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


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 5:57 AM
Points: 1,881, Visits: 798
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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:06 PM
Points: 14,172, Visits: 12,150
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 LessThanDot.

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: Today @ 1:26 PM
Points: 4,331, Visits: 5,695
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:47 AM
Points: 8,230, Visits: 9,932
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