Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available

Bueno, parece que han sacado un FIX para un fallo de la lista del artículo:

http://solidqualitylearning.com/Blogs/eladio/archive/2007/03/08/3909.aspx

50000939 The Maintenance Cleanup task uses an incorrect age group for cleanup operations.

 

Pero parece que el otro no está resuelto todavía… en fin, para mi gusto (y el de muchos de vosotros), demasiada frecuencia de SP2, refresh, cummulative…

 

El KB está en http://support.microsoft.com/kb/933097/en-us

 

Lo solucionado es:

SQL bug number

Description

50000783

When you define the value of the AdminTimeout property and the value of the ServerTimeout property, a profiler trace stops unexpectedly.

50000784

When you make a data manipulation language (DML) change to a published table, error 2812 occurs.

50000785

When you create a cursor by using an SQL statement that uses the OPTION (RECOMPILE) hint, error 16943 occurs. Error 16943 indicates that the table schema changed. This problem occurs when you retrieve information from the cursor location.

50000786

A memory leak exists in the MSOLAP provider (Msolap90.dll).

50000787

When you configure the Scheduler component to use a time-out value that is less than 15 milliseconds, you experience high CPU usage.

50000809

The LazyWriter process uses lots of CPU resources. This problem occurs on a non-uniform memory access (NUMA)-enabled x64-based server that is running SQL Server 2005 x64 Edition.

50000810

When you update a view through a cursor, you cannot make a CSEQUAL request or a TSEQUAL request for rows that are extended by using NULL values.

50000873

When you run an application in SQL Server 2005, error 8624 occurs. Error 8624 indicates that the cycle check failed.

50000874

When the stored procedure runs outside an explicit transaction, a temporary table in a stored procedure is not cleaned up correctly.

50000889

When you run a Microsoft Office Excel data mining operation, you receive the following error message:

The ‘MINIMUM_DEPENDENCY_PROBABILITY’ data mining parameter is not valid for the ‘Table1_283833_NB_413946’ model

50000939

The Maintenance Cleanup task uses an incorrect age group for cleanup operations.

 

 

Cuidado con los prerequisites (HABILITAR SMO y DMO XPs):

SQL Server 2005 hotfixes are now multilanguage. There is only one cumulative hotfix package for all languages.

One cumulative hotfix package includes all the component packages. The cumulative hotfix package is designed to update only those components that are installed on the system.

You must enable the SQL Server Management Object (SMO) extended stored procedures and the SQL Server Distributed Management Object (SQL-DMO) extended stored procedures before you install the cumulative hotfix package. For more information about the SMO and DMO XPs option, see SQL Server 2005 Books Online.

Note SQL Server 2005 Books Online notes that the default setting of these stored procedures is 0 (off). However, this value is incorrect. By default, the setting is 1 (on).

 

 

Eladio Rincón