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 «««1234

System Databases Expand / Collapse
Author
Message
Posted Thursday, September 16, 2010 5:14 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Monday, August 25, 2014 6:32 PM
Points: 11,194, Visits: 11,140
TravisDBA (9/9/2010)
da-zero (9/9/2010)
TravisDBA (9/9/2010)
free_mascot (9/9/2010)
Yes, me too worng....

The correct answer is none. As though resource database is readonly we can move it along with master.

http://msdn.microsoft.com/en-us/library/ms345408.aspx


In SQL Server 2008, the Resource database cannot be moved, Your provided link clearly states that.

Unfortunately, your question didn't

Reading is fundamental. I already stated in a previous post in this thread that I had omitted the version, and that was my bad, but the answer is correct for SQL 2008.

da-zero was simply pointing out the obvious irony. There's no need to be a dick about it ""




Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #987118
Posted Thursday, September 16, 2010 12:47 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, March 6, 2014 1:05 PM
Points: 1,334, Visits: 3,068
That was way out of line Paul. I was not being any such thing at all. I just said that I had already stated that previously and for the person to simply read it. Who is really being the d*** here?

"Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ..."
Post #987598
Posted Thursday, September 16, 2010 12:55 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 11:16 PM
Points: 13,616, Visits: 10,505
To conclude: I really was pointing out the obvious irony



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 #987602
Posted Thursday, September 16, 2010 1:06 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Monday, August 25, 2014 6:32 PM
Points: 11,194, Visits: 11,140
TravisDBA (9/16/2010)
That was way out of line Paul. I was not being any such thing at all. I just said that I had already stated that previously and for the person to simply read it. Who is really being the d*** here?

Out of line?
http://meta.wikimedia.org/wiki/Don't_be_a_dick




Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #987612
Posted Thursday, September 16, 2010 1:17 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 4:00 AM
Points: 21,397, Visits: 9,612
Ok guys, don't make me call your mother on this!
Post #987623
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse