Hello All, We are going to start new batch from next week. message/call or mail us for more details.

4 September 2013

Upgrade SQL Server 2005 SP3 to SP4

To download SP4, go to this link:


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):


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.

No comments:

Post a Comment