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»»

Administration Expand / Collapse
Author
Message
Posted Friday, May 15, 2009 8:30 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 4:38 PM
Points: 31,018, Visits: 15,453
I always here it referred to as the Resource database, so I think it's getting straightened out.








Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #717964
Posted Friday, May 15, 2009 8:49 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 12:58 PM
Points: 2,561, Visits: 3,842
Wow. 1% didn't choose Master. Interesting.
Post #717979
Posted Friday, May 15, 2009 8:52 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 7:59 AM
Points: 1,510, Visits: 2,696
Steve Jones - Editor (5/15/2009)
I always here it referred to as the Resource database, so I think it's getting straightened out.


and the name of msdb is actually msdbdata.mdf just to add another $0.02 worth.

Steve, can you find the link to that previous QOD?
Post #717984
Posted Friday, May 15, 2009 8:52 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 28, 2010 12:21 PM
Points: 125, Visits: 118
awesome, learned something new. keep the questions coming.

Being "normal" is not necessarily a virtue; it rather denotes a lack of courage.
-Practical Magic
Post #717985
Posted Friday, May 15, 2009 9:06 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 4:38 PM
Points: 31,018, Visits: 15,453
This one?

http://www.sqlservercentral.com/Questions/Tags/System+databases








Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #718002
Posted Friday, May 15, 2009 9:19 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, January 22, 2014 2:58 PM
Points: 531, Visits: 965
same thing here.. was not expecting that.. this is the type of the question that normally show up in exams..
you got me..


Cheers,
John Esraelo
Post #718020
Posted Friday, May 15, 2009 9:56 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 7:59 AM
Points: 1,510, Visits: 2,696

Thanks for the search tip, here it is:

http://www.sqlservercentral.com/links/158289/42671

QOD was posted May 8, 2008 - lots of replies
Post #718063
Posted Friday, May 15, 2009 11:15 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Monday, December 27, 2010 6:55 AM
Points: 636, Visits: 67
While resource and mssqlsystemresource are both "resource" databases they are not the same if you referencing them in code for whatever reason - they are two distinct and different entities. Bad question.
Post #718128
Posted Friday, May 15, 2009 11:47 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 12:48 PM
Points: 9,923, Visits: 11,169
Stuart,

My psychic powers allow me to detect that you answered incorrectly - as I did.

I am interested to know when you would reference it in code though?

Paul




Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #718149
Posted Friday, May 15, 2009 5:15 PM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Saturday, January 22, 2011 12:01 PM
Points: 702, Visits: 174
I have just install SQl 2008 and I do not see a resource database in system database? Do we need to install it?


Kindest Regards,

Amit Lohia
Post #718390
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse