InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 04:42:21 GMT20http://www.sqlservercentral.com/Forums/Topic455158-146-1.aspxPlease note: 3 year old thread.Sun, 17 Apr 2011 12:38:31 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic455158-146-1.aspxSQL Server 2005 SP4 is available nowhttp://www.microsoft.com/downloads/en/details.aspx?FamilyID=b953e84f-9307-405e-bceb-47bd345baeceRegards,Syed Jahanzaib Bin HassanMCTS|MCITP|OCA|OCP|OCE|SCJP|IBMCDBAMy Blogwww.aureus-salah.comSun, 17 Apr 2011 12:22:19 GMTSyed Jahanzaib Bin hassanhttp://www.sqlservercentral.com/Forums/Topic455158-146-1.aspxPeople might be trying to find some more info about SP4.I know I have been looking to find comments from anyone who has actually applied SP4 in a production environment.I saw a couple of posts first about the 'community' version and one mention of the final version but otherwise no mention.Does anyone know the impact of applying SP4?Wed, 23 Feb 2011 13:06:02 GMTEllen-477471http://www.sqlservercentral.com/Forums/Topic455158-146-1.aspxAs far as I know they don't delete old topics on this site...if people would stop re-activating them by posting in them it might help stop them coming to everyone's attention, though! :-)Wed, 23 Feb 2011 03:15:41 GMTpaul.knibbshttp://www.sqlservercentral.com/Forums/Topic455158-146-1.aspxI agree with SQLApprentice. This topic is outdated. SP4 has been released!Wed, 23 Feb 2011 02:59:11 GMTIgnacio A. Salom Rangelhttp://www.sqlservercentral.com/Forums/Topic455158-146-1.aspxShouldn't this topic be taken off already? SP4 has been release quite a time ago.Wed, 23 Feb 2011 01:21:05 GMTsqlnickxuhttp://www.sqlservercentral.com/Forums/Topic455158-146-1.aspxI think Microsoft has released Sp4 for 2005...on november 4th ..pls check..correct me if i am incorrect...thanks.Thu, 09 Dec 2010 07:18:21 GMTrajesh0928http://www.sqlservercentral.com/Forums/Topic455158-146-1.aspxPlease find the version detailsMicrosoft SQL server 2005- 9.00.1399.06(IntelX86).appreciated ur supportSat, 13 Nov 2010 02:43:47 GMTjvasu83http://www.sqlservercentral.com/Forums/Topic455158-146-1.aspxPlease post new questions in a new threadSat, 13 Nov 2010 02:10:50 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic455158-146-1.aspxCan you please the result of the following query on the forum [code="sql"]select @@version[/code].Sat, 13 Nov 2010 00:29:45 GMTIgnacio A. Salom Rangelhttp://www.sqlservercentral.com/Forums/Topic455158-146-1.aspxHi evrey body,i have an issue..While applying the SP 3 on SQL 2005,i am unable to locate Dtabase Engine to apply the SP3. But rest of the futures i can see like SQL Server Setup support files etc...I would if u could help me out in providing the solution ASAP..Fri, 12 Nov 2010 23:21:24 GMTjvasu83http://www.sqlservercentral.com/Forums/Topic455158-146-1.aspxHi evrey body,i have an issue..While applying the SP 3 on SQL 2005,i am unable to locate Dtabase Engine to apply the SP3. But rest of the futures i can see like SQL Server Setup support files etc...I would if u could help me out in providing the solution ASAP..Fri, 12 Nov 2010 23:16:38 GMTjvasu83http://www.sqlservercentral.com/Forums/Topic455158-146-1.aspxHi evrey body,i have an issue..While applying the SP 3 on SQL 2005,i am unable to locate Dtabase Engine to apply the SP3. But rest of the futures i can see like SQL Server Setup support files etc...I would if u could help me out in providing the solution ASAP..Fri, 12 Nov 2010 23:16:15 GMTjvasu83http://www.sqlservercentral.com/Forums/Topic455158-146-1.aspxThis thread is more than two years old...I'm sure the people who posted in it have probably figured out by now that SP3 is available, especially since that's been the case for more than a year and a half!Tue, 28 Sep 2010 02:31:54 GMTpaul.knibbshttp://www.sqlservercentral.com/Forums/Topic455158-146-1.aspx[quote][b]GilaMonster (12/16/2008)[/b][hr][quote][b]Saurabh Vegda (12/15/2008)[/b][hr]http://www.microsoft.com/downloads/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4&displaylang=en[/quote]We are sorry, the page you requested cannot be found.Looks like it's been pulled back for some reason...[/quote]HiIts working Now..Mon, 27 Sep 2010 00:17:16 GMTAli Tailorhttp://www.sqlservercentral.com/Forums/Topic455158-146-1.aspx[quote][b]oraculum (2/13/2008)[/b][hr]SQL Server 2005 SP3 It just isn't available yet! I can already hear you saying "But it must be coming any day now, right?" Wrong There are no current plans for releasing a new service pack for the very simple reason not enough people are asking for it. So click on this [url=https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=326575][b][u]link[/u][/b][/url] and vote for another SQL Server service pack! (and rate it also..!!)Or URL https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=326575[/quote]HiYou can Download SQL 2K5 Sp3 from herehttp://www.microsoft.com/downloads/en/details.aspx?FamilyID=AE7387C3-348C-4FAA-8AE5-949FDFBE59C4Mon, 27 Sep 2010 00:12:11 GMTAli Tailorhttp://www.sqlservercentral.com/Forums/Topic455158-146-1.aspxPlease note: year old thread.Mon, 02 Aug 2010 10:26:34 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic455158-146-1.aspxThis could also be due to the fact the log file drive for the SQL Agnet was changed. To fix the issue change the registry to point to the new log file location for the SQL Agnet. [b]HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL10.MSTGENT\SQL Server Agent[/b]Mon, 02 Aug 2010 10:16:58 GMTandyansryanhttp://www.sqlservercentral.com/Forums/Topic455158-146-1.aspxSQL Server 2005 SP3 is quite good enough on some of the bugs in SQL 2005.:-PTue, 27 Oct 2009 09:36:28 GMTmcvilbarhttp://www.sqlservercentral.com/Forums/Topic455158-146-1.aspx[quote][b]Ellen-477471 (10/5/2009)[/b][hr]Have there been any significant issues reported with any of the cumulative updates? We are planning to apply SP3 -- CU 5 this week and wondered if there is anything specific to watch out for.Thank you for sharing your experience.Ellen[/quote]test in QA firstwe usually upgrade our QA every CU or every other CU. our distributor and some "semi-production" servers get upgraded as well without QA testingfor everything else we only upgrade once QA tests all of the apps they test. SOme apps don't go through QA and we will send a note to development for a heads up. Great Plains only gets upgraded once we get an OK from the consultant who does a lot of the work on itWed, 21 Oct 2009 10:12:00 GMTalen teplitskyhttp://www.sqlservercentral.com/Forums/Topic455158-146-1.aspxThanks Keep it up.........[url=http://productreviewsby.me/ab-rocket/] Ab rocket [/url]Wed, 21 Oct 2009 06:52:15 GMTksnetsolutionhttp://www.sqlservercentral.com/Forums/Topic455158-146-1.aspxAgreed, I have never been able to keep up with Microsoft; usually a better idea to leapfrog product releases. SQL 2008 should be your SP3. thx,Wed, 07 Oct 2009 08:45:48 GMTAppleMouthhttp://www.sqlservercentral.com/Forums/Topic455158-146-1.aspxsee http://www.microsoft.com/downloads/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4&displaylang=en for download of SP3Tue, 06 Oct 2009 10:00:25 GMTfhanlonhttp://www.sqlservercentral.com/Forums/Topic455158-146-1.aspxI have not seen issues reported with any CUs lately, but I would caution you that these are not heavily tested. If you don't have an issue specifically with one of the fixes, don't apply it.The schedule for SPs is one per year, the first 6 months post RTM. We got SP3 last year, so I expect SP4 this year.Mon, 05 Oct 2009 11:46:56 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic455158-146-1.aspxHave there been any significant issues reported with any of the cumulative updates? We are planning to apply SP3 -- CU 5 this week and wondered if there is anything specific to watch out for.Thank you for sharing your experience.EllenMon, 05 Oct 2009 11:25:49 GMTEllen-477471http://www.sqlservercentral.com/Forums/Topic455158-146-1.aspxNow you are just stirring up trouble... :-DMon, 05 Oct 2009 11:20:01 GMTskrilla99http://www.sqlservercentral.com/Forums/Topic455158-146-1.aspxI haven't really seen any issues reported with SP3. The new system seems to be working well. I expect an SP4 before too much longer.Mon, 05 Oct 2009 11:16:28 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic455158-146-1.aspxInstalled SP3 on a consolidated server last week. No issues.Mon, 05 Oct 2009 11:09:44 GMTrhunthttp://www.sqlservercentral.com/Forums/Topic455158-146-1.aspxAs with all Microsoft products, SQL server 2005 needed a service pack 3 too. And now its already up and running fine!!Thu, 24 Sep 2009 05:12:42 GMTArun Jebakumarhttp://www.sqlservercentral.com/Forums/Topic455158-146-1.aspxInstall SP3 last week into my Prod env.Had no issues with the install or the P2P setup I have.I would recommend running it through stage/qa 1st.Have fun!Tue, 01 Sep 2009 06:48:43 GMTsql_lockhttp://www.sqlservercentral.com/Forums/Topic455158-146-1.aspxI think it should be properly tested before applying to production, SP2 is much stable for many environments.Sat, 08 Aug 2009 13:07:49 GMTSarab_SQLGeekhttp://www.sqlservercentral.com/Forums/Topic455158-146-1.aspx:-P:w00t:;-):-D:cool::hehe:Thu, 30 Jul 2009 12:29:47 GMTKatmai Stratovolcanohttp://www.sqlservercentral.com/Forums/Topic455158-146-1.aspxI have to agree with smunson. Plan the upgrade to SP3 at a time when you will be able to reboot the server. Good luck with the upgrade!Mon, 27 Jul 2009 00:00:03 GMTIgnacio A. Salom Rangelhttp://www.sqlservercentral.com/Forums/Topic455158-146-1.aspxPatience, patience...No but Patience.MSSQL SP3 is round da corner...Beta 4 2k8..Fri, 24 Jul 2009 07:46:08 GMTBudaClihttp://www.sqlservercentral.com/Forums/Topic455158-146-1.aspxThat probably depends on exactly how you go about installing it. However, on any reasonably current server, it's not as if this takes all that long to install, so why would you want to have the server waiting for a re-boot, when you certainly aren't going to want the server's SQL services active at the time of the install? I can't imagine making any attempt to install a service pack while it's still possible for people to connect to the server. That's asking for trouble, even if the risk might be low, and I just have to ask why? What could be so important that you'd be willing to risk the server sitting there for a few hours in a state you wouldn't want to operate in while someone could possibly be making use of it ???Steve(aka smunson):ermm::ermm::ermm:Thu, 11 Jun 2009 13:11:07 GMTsgmunsonhttp://www.sqlservercentral.com/Forums/Topic455158-146-1.aspxThis service pack requires a reboot. Does anyone know whether or not the installation of SP3 can be done let's say during a saturday evening and the actual follow up reboot be done several hours later when (during it's normal window of opportunity)? Thanks for your time.Thu, 11 Jun 2009 09:09:08 GMTdasundellhttp://www.sqlservercentral.com/Forums/Topic455158-146-1.aspx;-):w00t::cool::hehe::-P:-D:-)Thu, 14 May 2009 07:10:08 GMTBLADE-1043594http://www.sqlservercentral.com/Forums/Topic455158-146-1.aspx:-DMon, 30 Mar 2009 07:10:12 GMTBLADE-1043594http://www.sqlservercentral.com/Forums/Topic455158-146-1.aspxTx all much appreciated. I think I'll stick with what I have for now. Having both SP3 and 2k8 was just a want and to keep to the standard. In any case I'll be migrating because of licence issues on 3rd party software using current 2k5 SP2.Wed, 25 Feb 2009 00:24:08 GMTBudaClihttp://www.sqlservercentral.com/Forums/Topic455158-146-1.aspxWhat's the business reason? Applying SP3 is a patch. If you don't have a reason to upgrade, I'm not sure I would. If it's just to be current, SP3 is current for 2005 and since we'll likely have a new version in 2010, I'd stick with 2005 for now, unless you need something that's in 2k8.Tue, 24 Feb 2009 07:28:53 GMTSteve Jones - SSC Editor