Home > DeveloperSection > Articles > Upgrade SQL Server 2005 SP3 to SP4

Upgrade SQL Server 2005 SP3 to SP4


Database Database 
Ratings:
0 Comment(s)
 5160  View(s)
Rate this:

Upgrade SQL Server 2005 SP3 to SP4

To download SP4, go to this link:

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=b953e84f-9307-405e-bceb-47bd345baece 

If you are looking for the Express versions of SP4, you can get Express, Express with Tools, and Express with Advanced Services at the following URL (though they don't really do a great job of describing which file(s) may be most appropriate for you):

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=26435597-b28e-4568-9d16-017bdf47abdc 

If you want Express that can install on 32-bit or 64-bit systems, download SQLEXPR.EXE.  If you know you will only install to 32-bit systems, download the smaller SQLEXPR32.EXE.  (The only difference is the size of the package - I can hear the peanut gallery now.  In all seriousness, there is no such thing as a 64-bit version of SQL Server Express for SQL Server 2005 - which option first arrived with SQL Server 2008.)  If you want Express with Tools, use SQLEXPR_TOOLKIT.EXE, and if you want Express with Advanced Services, use SQLEXPR_ADV.EXE.

List of the issues that are fixed in SQL Server 2005 Service Pack 4

 

This article contains information about the issues that are fixed in Microsoft SQL Server 2005 Service Pack 4 (SP4).

Notes

 ·         Other fixes that are not documented may be included in the service pack.

 ·         This list will be updated when more articles are released.

Issues that are fixed in this service pack

 

For more information about the issues that are fixed in SQL Server 2005 Service Pack 4, click the following article numbers to view the articles in the Microsoft Knowledge Base:

VSTS bug number

KB article number

Description

294192

2445326

FIX: 0xC02020A1, 0xC020902A, 0xC0202092, and 0xC0047038 errors may occur at the same time when you try to run an SSIS 2005 package if you use multi-character column delimiters in a Flat File source

396531

980671

Correcting the lack of cryptographic salt variation on SQL Server sa login hash

308002

968749

SQL Server 2005 setup fails when MSXML Core Services 6.0 Service Pack 2 has already been installed

Additional issues that are fixed in this service pack

Resolutions to the following issues are also included in SQL Server 2005 Service Pack 4:

VSTS bug number

Description

297747

The multimedia timer frequency does not increase when you use Windows Internal Database.

555409

An access violation error may occur during the execution of Extended Stored Procedures under high stress conditions.

   

 

In addition to the fixes that are listed below, SQL Server 2005 SP4 contains the hotfixes that were included in cumulative update packages for SQL Server 2005 Service Pack 3 from cumulative update package 1 to cumulative update package 11.

For more information about the cumulative update packages for SQL Server 2005 Service Pack 3, click the following article number to view the article in the Microsoft Knowledge Base:

960598 The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 3 was released.


Don't want to miss updates? Please click the below button!

Follow MindStick