Ramblings of a DBA

Tara Kizer
posts - 165, comments - 832, trackbacks - 75

My Links

Advertisement

News

Subscribe
Search this Blog

Archives

Post Categories

Work
<< Index Fragmentation | Home | 64-bit server article in SQL Server Magazine >>

SQL Server 2005 Service Pack 1

Service Pack 1 is now available for SQL Server 2005.  You can download it here.

Here is the list of the new features and improvements included in this service pack.

Database Mirroring is enabled in this service pack!

Print | posted on Wednesday, April 19, 2006 10:49 AM | Filed Under [ SQL Server - Database Administration ]

Feedback

Gravatar

# re: SQL Server 2005 Service Pack 1

I have experienced, and have heard from a few others, SP1 breaking SSIS but cannot find any info regarding this.
4/25/2006 6:37 AM | Keath
Gravatar

# re: SQL Server 2005 Service Pack 1

Submit a ticket with MS on your SSIS and sp1 problems. If sp1 caused it, then I believe the call to PSS will be free. But you'd have to check with them to confirm.
4/25/2006 10:58 AM | Tara
Gravatar

# Test it first!

Make sure you test SQL Server 2005 Service Pack 1 thoroughly before deploying. Here is something pretty good...and then something pretty bad that I ran into with it:
http://rentacoder.com/CS/blogs/real_life_it/archive/2006/04/26/468.aspx
4/26/2006 8:50 PM | Ian Ippolito
Gravatar

# re: SQL Server 2005 Service Pack 1

Service Pack 1 hasn't presented too many problems for us. You'll find that most of the problems you experience from SP1 (or upgrading from 2000) stem from problems with your previous database or the use of replication--replication always seems to be a biggy with service packs.
5/5/2006 8:01 PM | Brett
Gravatar

# re: SQL Server 2005 Service Pack 1 problems

After installing a fresh copy of SQL Server 2000 on a newly built 2003 box then installing SQL Server 2005 works fine (proof of concept project), however after installing SP1, integration services won't start.

A removal then re-install of integration services works fine. Re-apply SP1 and the same thing happens again. This is not a big deal for us as it’s only on a development box, being used to test the install. Going through the logs but nothing obvious yet, will be placing a call to MS premium support otherwise.
6/11/2006 1:53 PM | Graeme
Gravatar

# re: SQL Server 2005 Service Pack 1

Solution for SSIS:

Windows Registry Editor Version 5.00

[HKEY_USERS\S-1-5-20\Software\Microsoft\Windows\CurrentVersion\WinTrust\Trust Providers\Software Publishing]
"State"=dword:00023e00
6/15/2006 5:02 AM | Mert Yerli
Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET

Copyright © Tara Kizer