Select the product you need help with

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

Article ID: 2463332 - View products that this article applies to.

SUMMARY

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.

Back to the top | Give Feedback

MORE INFORMATION

Download information

To obtain SQL Server 2005 SP4, visit the following Microsoft Web site:

Microsoft SQL Server 2005 Service Pack 4 RTM

To obtain SQL Server 2005 Express Edition SP4, visit the following Microsoft Web site:

Microsoft SQL Server 2005 Express Edition Service Pack 4

For more information about how to obtain SQL Server 2005 service packs, click the following article number to view the article in the Microsoft Knowledge Base:

913089 How to obtain the latest service pack for SQL Server 2005

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:

Collapse this tableExpand this table

VSTS bug number	KB article number	Description
294192	2445326 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/980671/ )	Correcting the lack of cryptographic salt variation on SQL Server sa login hash
308002	968749 (http://support.microsoft.com/kb/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:

Collapse this tableExpand this table

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

(http://support.microsoft.com/kb/960598/ )

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

Back to the top | Give Feedback

Troubleshoot Windows update issues

You may also encounter the following issues when you try to install this update:

The update installation fails.
The system keeps reminding you to install this update although you already installed it.
The desktop does not load.

If you encounter one if the issues mentioned above, you may try the following methods.

Click here to view or hide detailed information

Back to the top | Give Feedback

REFERENCES

For more information about how to determine the current SQL Server version and edition, click the following article number to view the article in the Microsoft Knowledge Base:

321185

(http://support.microsoft.com/kb/321185/ )

How to identify your SQL Server version and edition

The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of these products.

Back to the top | Give Feedback