<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by ginni.ashok
»
SQL Server 2005
51 posts, Page 1 of 6
1
2
3
4
5
»
»»
SQL Server 2005
Rate Topic
Display Mode
Topic Options
Author
Message
ginni.sinha
ginni.sinha
Posted Wednesday, May 07, 2008 9:19 PM
SSC Veteran
Group: General Forum Members
Last Login: Thursday, February 21, 2013 2:41 AM
Points: 271,
Visits: 97
Comments posted to this topic are about the item
SQL Server 2005
Post #496827
brewmanz
brewmanz
Posted Wednesday, May 07, 2008 9:40 PM
SSC-Addicted
Group: General Forum Members
Last Login: Tuesday, December 04, 2012 11:16 AM
Points: 477,
Visits: 389
There seems to be a conflict in the documentation about what constitutes a "database". Seems that Resource is a *special* system database. Whether it's truly a system database is debatable ...
So I reckon Resource is *not* a system database using following logic:
* SQL Server 2005 BOL ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/60a93880-62f1-4eda-a886-f046706ba90c.htm states for sys.sysdatabases
"Contains one row for each database in an instance of Microsoft SQL Server 2005. When SQL Server is first installed, sysdatabases contains entries for the master, model, msdb, and tempdb databases."
No Resource there.
* Also, trying the following in studio
use msdb
use tempdb
use Resource
use master
it failed with:
"Could not locate entry in sysdatabases for database 'Resource'. No entry found with that name. Make sure that the name is entered correctly."
----
So if it doesn't look like a duck and can't quack like a duck, I reckon it's not a duck.
Post #496834
Lynn Pettis
Lynn Pettis
Posted Wednesday, May 07, 2008 11:19 PM
SSC-Insane
Group: General Forum Members
Last Login: Yesterday @ 9:17 PM
Points: 21,832,
Visits: 27,855
True, the Resource database is not listed in sys.databases; however, the documentation does refer to it as a special, read-only database that must be located in the same directory as the master database and that the objects contained are viewed thru the sys schema.
It is a system database.
Lynn Pettis
For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here
or
when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here
and
here
Managing Transaction Logs
SQL Musings from the Desert
Fountain Valley SQL
(My Mirror Blog)
Post #496861
stevehindmarsh
stevehindmarsh
Posted Thursday, May 08, 2008 1:23 AM
SSC Eights!
Group: General Forum Members
Last Login: Friday, June 14, 2013 2:35 AM
Points: 852,
Visits: 525
From a SQL Server Errorlog during startup :-
Starting up database 'mssqlsystemresource'.
The question is wrong - 'mssqlsystemresource' could be referred to as a system database, and I think there are arguments for and against that...
But there's no such database as 'resource'.
The question is misleading\incorrect.
Post #496906
abhijeetv
abhijeetv
Posted Thursday, May 08, 2008 1:30 AM
SSC-Addicted
Group: General Forum Members
Last Login: Friday, May 25, 2012 8:08 AM
Points: 496,
Visits: 508
Resourse database is not system database available directly so the answer is wrong. Correct answer should be master,model,msdb and tempdb only!
Post #496910
Christian Buettner-167247
Christian Buettner-167247
Posted Thursday, May 08, 2008 2:01 AM
SSCrazy
Group: General Forum Members
Last Login: Today @ 12:36 AM
Points: 2,547,
Visits: 3,648
The question is correct.
And the provided link should be evidence enough.
Best Regards,
Chris Büttner
Post #496926
brewmanz
brewmanz
Posted Thursday, May 08, 2008 2:27 AM
SSC-Addicted
Group: General Forum Members
Last Login: Tuesday, December 04, 2012 11:16 AM
Points: 477,
Visits: 389
Christian Buettner (5/8/2008)
...
And the provided link should be evidence enough.
To take the first bit of evidence presented and then dismiss all other evidence that disagrees is a bit one-eyed. If I had submitted the Q and excluded Resource as system database with the evidence of my BOL link, would that link then be "evidence enough" to say that it isn't one?
The provided link is
prima facie
evidence, but conflicting evidence is now being presented.
The discussion seems to centring around "what makes a system database, and what name would it called by?"
The BOL has contradictory statements in it (surprise!). I have provided BOL and empirical evidence that it fails to be a system database. Others also have submitted info both for and against the Q's stance. Weigh up the evidence, yes; argue against it even. But please, don't dismiss it just because it disagrees with someone's viewpoint; you have to have a better reason than that.
Post #496938
humbleDBA
humbleDBA
Posted Thursday, May 08, 2008 2:28 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, November 28, 2012 4:08 AM
Points: 160,
Visits: 1,006
And also the following link http://msdn.microsoft.com/en-us/library/ms190940.aspx
Plus, Henderson K (2007),
SQL Server 2005 Practical Troubleshooting The Database Engine
, pp51-52.
Post #496939
Prasad Bhogadi
Prasad Bhogadi
Posted Thursday, May 08, 2008 2:29 AM
SSC Eights!
Group: General Forum Members
Last Login: Thursday, May 02, 2013 5:00 AM
Points: 967,
Visits: 447
I am not sure if resource is a system database. From the article in the question it does not cement the answer that resource is a system database.
Prasad Bhogadi
Post #496940
Christian Buettner-167247
Christian Buettner-167247
Posted Thursday, May 08, 2008 2:52 AM
SSCrazy
Group: General Forum Members
Last Login: Today @ 12:36 AM
Points: 2,547,
Visits: 3,648
brewmanz.sqlservercentral (5/8/2008)
Christian Buettner (5/8/2008)
...
And the provided link should be evidence enough.
To take the first bit of evidence presented and then dismiss all other evidence that disagrees is a bit one-eyed. If I had submitted the Q and excluded Resource as system database with the evidence of my BOL link, would that link then be "evidence enough" to say that it isn't one?
The provided link is
prima facie
evidence, but conflicting evidence is now being presented.
The discussion seems to centring around "what makes a system database, and what name would it called by?"
The BOL has contradictory statements in it (surprise!). I have provided BOL and empirical evidence that it fails to be a system database. Others also have submitted info both for and against the Q's stance. Weigh up the evidence, yes; argue against it even. But please, don't dismiss it just because it disagrees with someone's viewpoint; you have to have a better reason than that.
Hello brewmanz,
I agree, that the missing info about the resource database can be misleading in the link you provided.
But be honest: The article provided by the QOTD explicitly defines system databases. Your link does NOT explicitly define system databases. It only explains the compatibility view.
Therefore to me it is pretty clear that the resource database IS a system database.
Best Regards,
Chris Büttner
Post #496948
« Prev Topic
|
Next Topic »
51 posts, Page 1 of 6
1
2
3
4
5
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
