Dec 26 - Jan 18 SQL Server 2005 Hotfix KB

  • Article

Below are the KB articles published recently, I will introduce more information about sql hotfix and sql rollup ost later.

  • 946127 - FIX: You may experience problems when you use SQL Server Management Studio in SQL Server 2005 to connect to an instance of SQL Server 2008
  • 946082 - FIX: Error message when you display a SQL Server 2005 Reporting Services report on a computer that has multiple processors: "An internal error occurred on the report server"
  • 946039 - FIX: A query that involves an outer join operation returns an incorrect result after you install Cumulative update package 4 for SQL Server 2005 Service Pack 2
  • 946038 - FIX: Error message when you run the sp_dbmmonitorresults stored procedure in SQL Server 2005: "An internal error has occurred in the database mirroring monitor"
  • 946037 - FIX: The Processors page in the Server Properties dialog box in SQL Server Management Studio does not correctly report the processor affinity for an instance of SQL Server 2005 on a computer that has more than 32 processors
  • 946035 - FIX: Error message when you try to save a SQL Server 2005 Reporting Services report in Report Builder: "An error occured while saving your report"
  • 946031 - FIX: A query returns the incorrect result when you run a query that uses the USE PLAN query hint in SQL Server 2005
  • 946029 - FIX: You cannot export a SQL Server 2005 Reporting Services report from a report server to an Excel format file on a computer that has FIPS-compliant algorithms enabled
  • 946028 - FIX: An MDX query that uses the NonEmptyCrossjoin function on more than one measure group does not return all records after you install SQL Server 2005 Service Pack 2
  • 946027 - FIX: An MDX query that uses subqueries may return incorrect data after you install SQL Server 2005 Service Pack 2
  • 946024 - FIX: A Multidimensional Expressions (MDX) query that references a named set may return incorrect data after you install SQL Server 2005 Service Pack 2
  • 945914 - FIX: Error message when an application that is running as a Windows service calls some SSIS packages: "A variable may only be added once to either the read lock list or the write lock list"
  • 945913 - FIX: You receive one or more error messages when you run the DBCC CHECKTABLE statement against a partitioned table in SQL Server 2005
  • 945910 - FIX: The InScope function returns incorrect data when you use the function for a static column or for a subtotal column in a matrix data region in a SQL Server 2005 Reporting Services report
  • 945907 - FIX: Error messages when you run the database mirroring monitoring job by using the sp_dbmmonitorupdate stored procedure in SQL Server 2005: "Error: 102, Severity: 15, State: 1" and "Error: 319, Severity: 15, State: 1"
  • 945900 - FIX: Error message when you run an MDX query that contains calculated members in SQL Server 2005 Analysis Services: "Internal error: An unexpected exception occured"
  • 945897 - FIX: The row at the publisher contains incorrect values in the column that has the UniqueIdentifier data type when you synchronize a subscription in a merge replication between SQL Server 2005 and SQL Server 2005 Compact Edition
  • 945893 - FIX: Error message when you run a parent package that contains some child packages in SQL Server 2005 Integration Services: "Error: 0xC001000E"
  • 945308 - FIX: You may receive incorrect data when you run a query against a database that has the PARAMETERIZATION database option set to FORCED in SQL Server 2005
  • 945127 - FIX: You may still experience the performance issue that is described in KB article 940945 after you install Cumulative Update 3 for SQL Server 2005 Service Pack 2
  • 945054 - FIX: You can run the ALTER ASYMMETRIC KEY statement or the ALTER CERTIFICATE statement by using a SQL Server login that does not have permissions to run these statements in Microsoft SQL Server 2005
  • 944001 - FIX: Unexpected results may be returned when you discontinuously run MDX queries that cross both hierarchies against the dimension in SQL Server 2005 Analysis Services
  • 943525 - You cannot start the SQL Server Agent service of a failover cluster of SQL Server 2005 if the build of SQL Server is 3179 or a later build
  • 942839 - An MDX query returns additional cell data when you use the IsEmpty function on the query axis in Analysis Services with SQL Server 2005 Service Pack 2
  • 942680 - FIX: The CREATE PROCEDURE statement does not run when you try to run the statement to create a stored procedure that contains a very large amount of text in SQL Server 2005
  • 941742 - A cube is not modified when you process the cube by using the ProcessDefault option in SQL Server 2005 Analysis Services