SQL Server 2005 SP1

Question

SQL Server 2005 SP1

imarchenko-236376

SSCommitted

Points: 1734
More actions
May 10, 2006 at 12:42 pm

#366109

Hello!

I saw list of new features added/bugs fixes in SP1.
I was wondering if anyone can share his/her personal experience on SQL Server 2005 SP1. We are considering installing it on our SQL Server 2005 x-64 bit Active/Passive Cluster.

Thanks,
Igor

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

David Scotland-132255 SSCertifiable Points: 5599 More actions · Answer 1

There are few things you need to be aware of with SSIS before applying service pack 1. The way dates are treated has changed and the service mat not start applying the service pack. The links below explain. I believe there is a hot fix being released to fix the service not starting which is to do with a certificate.

http://blogs.conchango.com/jamiethomson/archive/2006/04/26/3870.aspx

http://sqljunkies.com/WebLog/sqlbi/archive/2006/04/27/20615.aspx

http://blogs.conchango.com/jamiethomson/archive/2006/04/26/3877.aspx

Also if you use SSRS then the SELECT ALL parameter has gone (This is intentional)

http://nickbarclay.blogspot.com/2006/04/ssrs-disappearing-select-all-parameter.html

I have applied it in my development envrionment and apart from the SSIS service stupidity have found it to be OK although I am waiting before I deploy it onto my live servers.

hth

David

Kid-266422 SSC Veteran Points: 261 More actions · Answer 2

the article for SSIS on SP1:

http://support.microsoft.com/kb/918644

David Manix Say Hey Kid Points: 685 More actions · Answer 3

Personally I have had some issues with upgrading to SP1 (like the above links and more), but no problems with a fresh install.

Good luck.