<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 Steve Jones
»
System Databases
38 posts, Page 1 of 4
1
2
3
4
»
»»
System Databases
Rate Topic
Display Mode
Topic Options
Author
Message
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Thursday, January 08, 2009 11:17 PM
SSC-Dedicated
Group: Administrators
Last Login: Yesterday @ 1:47 PM
Points: 31,406,
Visits: 13,722
Comments posted to this topic are about the item
System Databases
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #633104
Scott Herbert-214404
Scott Herbert-214404
Posted Friday, January 09, 2009 12:11 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Sunday, April 21, 2013 11:30 PM
Points: 177,
Visits: 237
there's a slight grammatical problem in this question.. "at"
Post #633120
ChiragNS
ChiragNS
Posted Friday, January 09, 2009 1:10 AM
SSCrazy
Group: General Forum Members
Last Login: Wednesday, April 24, 2013 5:02 AM
Points: 2,365,
Visits: 1,825
Question not clear.
"Keep Trying"
Post #633152
jameslester78-958147
jameslester78-958147
Posted Friday, January 09, 2009 1:59 AM
Grasshopper
Group: General Forum Members
Last Login: Friday, June 29, 2012 7:22 AM
Points: 24,
Visits: 161
i got it wrong, missed mssqlsystemresource, mainly because im a 2005 user.
Post #633168
Adi Cohn-120898
Adi Cohn-120898
Posted Friday, January 09, 2009 2:06 AM
SSCrazy
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 10:07 PM
Points: 2,018,
Visits: 4,911
jameslester78 (1/9/2009)
i got it wrong, missed mssqlsystemresource, mainly because im a 2005 user.
Actually the mssqlsystemresource was introduced at SQL Server 2005
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #633171
D.Oc
D.Oc
Posted Friday, January 09, 2009 2:19 AM
Ten Centuries
Group: General Forum Members
Last Login: Monday, May 06, 2013 4:10 PM
Points: 1,053,
Visits: 6,426
I'm not sure why I thought Resource Database is not a part of System DB???
-------------------------------------------------------------
"It takes 15 minutes to learn the game and a lifetime to master"
"Share your knowledge. It's a way to achieve immortality."
Post #633174
Dugi
Dugi
Posted Friday, January 09, 2009 2:26 AM
Ten Centuries
Group: General Forum Members
Last Login: Tuesday, April 02, 2013 1:48 AM
Points: 1,252,
Visits: 3,367
Adi Cohn (1/9/2009)
jameslester78 (1/9/2009)
i got it wrong, missed mssqlsystemresource, mainly because im a 2005 user.
Actually the mssqlsystemresource was introduced at SQL Server 2005
Adi
Yes the system databases in SQL Server 2005 are
master
msdb
model
tempdb
Resource Database = mssqlsystemresource!
So the user just see the information about Resource Database, not also that this resource db name is "mssqlsystemresource"
Anyway the Resource Database is a read-only database that contains system objects that are included with SQL Server. System objects are physically persisted in the Resource database, but they logically appear in the sys schema of every database.
============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #633178
Ben Leighton
Ben Leighton
Posted Friday, January 09, 2009 2:57 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Tuesday, July 05, 2011 8:18 AM
Points: 582,
Visits: 359
hmmm... just going slightly off piste here but that mssqlsystemresource db has been a constant source of irritation for me... especially where the log and mdb have been installed on different drives to their default sql server location... In 2005 for some reason whenever a service pack is installed it bugs right up... I wonder whether the same will happen with 2008?
Post #633201
jameslester78-958147
jameslester78-958147
Posted Friday, January 09, 2009 4:42 AM
Grasshopper
Group: General Forum Members
Last Login: Friday, June 29, 2012 7:22 AM
Points: 24,
Visits: 161
Adi Cohn (1/9/2009)
jameslester78 (1/9/2009)
i got it wrong, missed mssqlsystemresource, mainly because im a 2005 user.
Actually the mssqlsystemresource was introduced at SQL Server 2005
Adi
oh, when i look in my system databases folder all I see are master, model, msdb and tempdb
Post #633251
Dugi
Dugi
Posted Friday, January 09, 2009 5:35 AM
Ten Centuries
Group: General Forum Members
Last Login: Tuesday, April 02, 2013 1:48 AM
Points: 1,252,
Visits: 3,367
jameslester78 (1/9/2009)
Adi Cohn (1/9/2009)
jameslester78 (1/9/2009)
i got it wrong, missed mssqlsystemresource, mainly because im a 2005 user.
Actually the mssqlsystemresource was introduced at SQL Server 2005
Adi
oh, when i look in my system databases folder all I see are master, model, msdb and tempdb
In SQL Server 2005
+1
Resource Database see BOL for more infos!...
============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #633264
« Prev Topic
|
Next Topic »
38 posts, Page 1 of 4
1
2
3
4
»
»»
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.
