<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 Kenneth Fisher
»
Installing SQL Server 2005
49 posts, Page 1 of 5
1
2
3
4
5
»
»»
Installing SQL Server 2005
Rate Topic
Display Mode
Topic Options
Author
Message
Kenneth.Fisher
Kenneth.Fisher
Posted Thursday, July 28, 2011 9:40 PM
Hall of Fame
Group: General Forum Members
Last Login: 2 days ago @ 1:16 PM
Points: 3,367,
Visits: 1,567
Comments posted to this topic are about the item
Installing SQL Server 2005
Kenneth Fisher
I strive to live in a world where a chicken can cross the road without being questioned about its motives.
--------------------------------------------------------------------------------
For better, quicker answers on T-SQL questions, click on the following...
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/
Link to my Blog Post -->
www.SQLStudies.com
Post #1150652
murray-906152
murray-906152
Posted Thursday, July 28, 2011 9:44 PM
SSCommitted
Group: General Forum Members
Last Login: Thursday, March 28, 2013 12:06 AM
Points: 1,527,
Visits: 207
I think it would have been fairer to point out what SP version of SQL Server 2005 the question related to.
Given one tries to keep SQL Server updated are far as practical, just stating SQL Server 2005 does not imply there is a particular issue with an old SP version.
Regards, Murray.
Post #1150653
Shark Energy
Shark Energy
Posted Friday, July 29, 2011 2:27 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Friday, March 22, 2013 9:32 AM
Points: 547,
Visits: 995
Murray, surely that wouldn't make a difference to the question as it states you are doing the default install with default options - no SP.
I got it right but took a chance as I felt like it was a trick question as, as far as I know, a single processor install works fine and that is an odd number too.
Post #1150715
anthony.green
anthony.green
Posted Friday, July 29, 2011 2:35 AM
SSCertifiable
Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075,
Visits: 4,831
I would have to agree with Murray on this, it would have been nice to know which level of the product it relates to.
All the media I have been working with included SP2 as part of the disk so I have never encountered this issue.
Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1
&
Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger
Post #1150718
DugyC
DugyC
Posted Friday, July 29, 2011 3:15 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 3:25 AM
Points: 1,165,
Visits: 731
I don't mind so much getting this one wrong, as I have learnt a lot along the way, and had a very interesting time trying to find the answer.
However, I do 100% fully consider this a trick question. Why? Because the author specifies the Service Pack when it comes to Windows Server, but omits it for SQL Server, which leaves you wondering therefore what is the correct answer, as it is very much SP specific. The default scenario would be to always maintain your servers with the latest SP, and therefore you would have at least SP2 (most likely SP3, maybe even SP4) on this SQL Server 2005 installation.
However, this question was about a previous (to current) version of SQL Server on a specific version of the SP, and the author deliberately omitted to specify that in the question.
That aside, a great question which, as I say, I had a great time researching. Thanks
_____________________________________________________________________
"The difficult tasks we do immediately, the impossible takes a little longer"
Post #1150739
Shark Energy
Shark Energy
Posted Friday, July 29, 2011 3:31 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Friday, March 22, 2013 9:32 AM
Points: 547,
Visits: 995
No excuses people I mean if follow the question in your head, it fails before you get to installing any SPx so follow the question and its all in front of you.
Post #1150744
cengland0
cengland0
Posted Friday, July 29, 2011 3:35 AM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, January 24, 2013 9:59 PM
Points: 1,354,
Visits: 1,299
Got it right by process of elimination. The installs correctly almost had me but that would have been too easy. Obviously there was something that was going to go wrong. I knew the other two fail options weren't correct so it had to be the odd number of processors as the only correct answer.
Besides, that's weird to have an odd number of processors installed in a server. Personally, I've never seen that before but that doesn't make it impossible.
Post #1150748
Carlton Leach
Carlton Leach
Posted Friday, July 29, 2011 3:57 AM
SSC Eights!
Group: General Forum Members
Last Login: Monday, May 20, 2013 6:52 AM
Points: 863,
Visits: 1,022
SQL can't be installed on a single socket machine?
Carlton.
Post #1150761
DugyC
DugyC
Posted Friday, July 29, 2011 4:00 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 3:25 AM
Points: 1,165,
Visits: 731
Shark Energy (7/29/2011)
No excuses people I mean if follow the question in your head, it fails before you get to installing any SPx so follow the question and its all in front of you.
Not if the disc you installed it from is already with SP2 or 3... and there are plenty of those around, or for that matter if you downloaded it from an MSDN subscription with SP2 of 3.
Agree to disagree me thinks...
_____________________________________________________________________
"The difficult tasks we do immediately, the impossible takes a little longer"
Post #1150763
Shark Energy
Shark Energy
Posted Friday, July 29, 2011 4:02 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Friday, March 22, 2013 9:32 AM
Points: 547,
Visits: 995
In the absence of an SP listed in the question for the SQL install, I'd assume he is referring to vanilla flavour.
Totally agreeing to disagree
Post #1150765
« Prev Topic
|
Next Topic »
49 posts, Page 1 of 5
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.
