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 | 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 | Correcting the lack of cryptographic salt variation on SQL Server sa login hash | |
308002 | 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.
Leave Comment