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.
|