Can SQL2005 SP3 be applied to...

Can SQL2005 SP3 be applied to SQL2005 that is at level: 9.00.2040 SP 1 Mar 2006 CTP? A fellow DBA is saying that you cannot apply SP3 to a "CTP".

more ▼

asked Feb 05 '10 at 03:30 PM in Default

Kevin Newton gravatar image

Kevin Newton
23 1 1 1

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

I think you guys are confusing a CTP of SQL Server with a CTP of a SQL Server Service Pack (a pre-release CTP of SQL Server 2005 would have a build <= 9.00.1399). I think you should be able to apply SP3 to that build (9.00.2040) no problem.

more ▼

answered Feb 08 '10 at 06:49 PM

Aaron Bertrand gravatar image

Aaron Bertrand

You are right, I didn't read the question right. But I still don't think it is supported. All releases before SP2 has passed microsofts "mainstream support"
Feb 09 '10 at 03:13 AM Håkan Winther
Yes I'm talking about a CTP of a Service Pack. Thanks Aaron
Feb 11 '10 at 09:34 PM Kevin Newton
(comments are locked)
10|1200 characters needed characters left

I agree with him. I wouldn't apply the SP to a CTP either. As a matter of fact, I would strongly suggest that, 5 years since the release of 2005, it's probably time to get rid of the CTP.

Is it possible to do? Sure. But you're looking at the strong possibility of unknown effects. Why take chances?

more ▼

answered Feb 05 '10 at 05:27 PM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
90.5k 19 21 74

I'm not talking about a CTP of the actual SQL engine. I'm talking about a Service Pack CTP...9.00.2040. 2040 being the Service Pack CTP released in Mar 2006
Feb 11 '10 at 09:36 PM Kevin Newton
That makes some difference, but not tons. I'm still nervous about applying approved SP's to test SP's, but... I'd get the system upgraded,regardless of where it's at now.
Feb 12 '10 at 09:37 AM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left

I dont know about CTP but I recently updated one SQL2005 RTM+ instance directly to SQL2005 sp3 and everything works fine.

more ▼

answered Feb 07 '10 at 10:58 PM

DaniSQL gravatar image

4.9k 33 35 39

Yes, a service pack includes all previous service packs for the product. So yu can install the RTM and then service pack 3 and you have all patches from service packs 1 & 2 included. It's the same with the Books Online service packs.
Feb 08 '10 at 05:05 AM David Wimbush
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Feb 05 '10 at 03:30 PM

Seen: 1010 times

Last Updated: Feb 05 '10 at 03:30 PM