Na stronach producenta udostępniono piąty pakiet skumulowanych poprawek dla serwera SQL 2005 z zainstalowanym Service Packiem 3.
Skumulowany pakiet poprawek naprawia błędy jakie ukazały się od czasu udostępnienia dodatku Service Pack 3. Ponizej lista błedów jakich dotyczy poprawka:
VSTS bug number | KB article number | Description | |
308815 | 970726 (http://support.microsoft.com/kb/970726/ ) | FIX: Error message when you try to rebuild one partition of an index on an indexed view in SQL Server 2005: “A system assertion check has failed. Check the SQL Server error log for details.” | |
319368 | 971057 (http://support.microsoft.com/kb/971057/ ) | FIX: An INSERT INTO <table name> EXEC <stored procedure name> statement generates error messages even if you set the ANSI_WARNINGS option to “OFF” in SQL Server 2005 and SQL Server 2008 | |
321588 | 971114 (http://support.microsoft.com/kb/971114/ ) | FIX: Error message when you run a report in SQL Server 2005 SP2 Reporting Services by using a URL from a subscription: “Object reference not set to an instance of an object” | |
321564 | 972271 (http://support.microsoft.com/kb/972271/ ) | FIX: Error message when you run a “BULK INSERT” statement on a table that does not have a clustered index in SQL Server 2005: “spid1005 Error: 5243, Severity: 22, State: 1 An inconsistency was detected during an internal operation” | |
321943 | 972365 (http://support.microsoft.com/kb/972365/ ) | FIX: Error message when you run a SQL Server 2005 Integration Services package that contains a column of a BLOB data type in a data flow task: “The buffer manager could not get a temporary file name. The call to GetTempFileName failed” | |
324086 | 972687 (http://support.microsoft.com/kb/972687/ ) | FIX: Error message when you restore a SQL Server 2000 database by using SQL Server 2005 Management Studio or SQL Server 2008 Management Studio: “Cannot show requested dialog. Failed to retrieve data for this request (Microsoft.SqlServer.SmoEnum)” | |
316129 | 972694 (http://support.microsoft.com/kb/972694/ ) | FIX: SQL Server 2008 Reporting Services Add-in for SharePoint removes the “Microsoft.SqlServer.Smo” assembly for SQL Server 2005 from the GAC | |
327557 | 973103 (http://support.microsoft.com/kb/973103/ ) | FIX: Error message when you run the Distribution Agent to synchronize the subscribers with the publisher in Microsoft SQL Server 2005:” The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect” | |
331569 | 973524 (http://support.microsoft.com/kb/973524/ ) | FIX: The execution of the “xp_readerrorlog” command in SQL Server 2005 hangs and consumes CPU resources | |
331898 | 973578 (http://support.microsoft.com/kb/973578/ ) | FIX: An incorrect result is returned when you run a query against an XML column that contains XML data that is generated by the FOR XML clause and contains nested data sections in SQL Server 2005 | |
328191 | 973877 (http://support.microsoft.com/kb/973877/ ) | FIX: A performance issue occurs when you run a query by using a Fast Forward cursor in SQL Server 2005 | |
318498 | 972767 (http://support.microsoft.com/kb/972767/ ) | FIX: The SQL Server database engine and SQL Server Reporting Services may consume more power on Windows client computers than expected |
Poprawka obejmuje nastepujące wersje SQL Server 2005:
- Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems
- Microsoft SQL Server 2005 Express Edition
- Microsoft SQL Server 2005 Express Edition with Advanced Services
- Microsoft SQL Server 2005 Workgroup Edition
- Microsoft SQL Server 2005 Standard Edition
- Microsoft SQL Server 2005 Developer Edition
- Microsoft SQL Server 2005 Enterprise Edition
- Microsoft SQL Server 2005 Standard X64 Edition
- Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems
Poprawka oraz jej szczegółowy opis znaleźć można pod tym adresem: Cumulative update package 5 for SQL Server 2005 Service Pack 3