SQL Server 2005 articles, fixes and updates - December 2007

This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft SQL Server 2005 that have been released in December 2007. The list is daily updated.

• 945937 The SQL Server 2005 Setup program generates an incorrect error message when you install a SQL Server 2005 failover cluster and the Setup program cannot access the cluster resource Q945937 KB945937 December 31, 2007
• 945913 FIX: You receive one or more error messages when you run the DBCC CHECKTABLE statement against a partitioned table in SQL Server 2005 Q945913 KB945913 December 31, 2007
• 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 Q944001 KB944001 December 31, 2007
• 946089 You encounter a problem with a subscription that uses the file share delivery extension in SQL Server 2005 Reporting Services or in SQL Server 2008 Reporting Services after you upgrade Windows Server 2003 to Windows Server 2008 Q946089 KB946089 December 27, 2007
• 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" Q946038 KB946038 December 26, 2007
• 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 Q946037 KB946037 December 26, 2007
• 946031 FIX: A query returns the incorrect result when you run a query that uses the USE PLAN query hint in SQL Server 2005 Q946031 KB946031 December 26, 2007
• 946027 FIX: An MDX query that uses subqueries may return incorrect data after you install SQL Server 2005 Service Pack 2 Q946027 KB946027 December 26, 2007
• 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 Q946024 KB946024 December 26, 2007
• 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" Q945914 KB945914 December 26, 2007
• 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 Q942680 KB942680 December 26, 2007
• 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 Q946028 KB946028 December 21, 2007
• 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 Q945910 KB945910 December 21, 2007
• 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" Q946035 KB946035 December 20, 2007
• 946000 FIX: The prediction process may take a long time when you use a mining model to generate predictions in SQL Server 2005 Analysis Services Q946000 KB946000 December 20, 2007
• 945685 When you request a large MDSCHEMA_MEMBERS schema rowset from a client application, the request takes a long time to respond and the client application uses lots of virtual memory in SQL Server 2005 Analysis Services Q945685 KB945685 December 20, 2007
• 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 Q945308 KB945308 December 20, 2007
• 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 Q945054 KB945054 December 20, 2007
• 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" Q946082 KB946082 December 19, 2007
• 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 Q946029 KB946029 December 19, 2007
• 946025 FIX: HTTP access to a SQL Server 2005 Analysis Services instance fails if you use a proxy server that requires authentication Q946025 KB946025 December 19, 2007
• 945894 FIX: A prediction operation takes a long time to execute when you have a mining model that uses the Microsoft Neural Network algorithm in SQL Server 2005 Analysis Services Q945894 KB945894 December 19, 2007
• 945891 FIX: Some user-defined hierarchies are missing when you view the local cube if you filter some dimensions of the source cube in SQL Server 2005 Analysis Services Q945891 KB945891 December 19, 2007
• 946023 FIX: Error message when you jump to another report that uses a shared data source in SQL Server 2005 Reporting Services: "One or more data sources is missing credentials" Q946023 KB946023 December 18, 2007
• 944152 FIX: A Multidimensional Expressions (MDX) query takes a long time to finish in Microsoft SQL Server 2005 Analysis Services Q944152 KB944152 December 18, 2007
• 945374 You cannot compile a SQL Server Compact-based OLE DB application for Windows Mobile 5.0, and the Transact.h file cannot be found Q945374 KB945374 December 13, 2007
• 945068 Some visual elements in SQL Server Management Studio lose functionality when you register many instances of SQL Server Q945068 KB945068 December 12, 2007
• 932011 BUG: The Installation Progress dialog box displays a status of Failure for the Database Services component when you install SQL Server 2005 Service Pack 1 or SQL Server 2005 Service Pack 2 on an instance of SQL Server 2005 Q932011 KB932011 December 12, 2007
• 945842 FIX: The setMaxRows method unexpectedly applies to DELETE statements when you use the SQL Server 2005 JDBC Driver version 1.2 to connect to a database Q945842 KB945842 December 11, 2007
• 945770 FIX: The DBCC CHECKDB statement takes longer to run on an x64-based computer than the statement takes to run on a 32-bit computer when you run the statement against a database in SQL Server 2005 Q945770 KB945770 December 11, 2007
• 945600 FIX: You receive an exception error message when you try to display a Reporting Services report on a server that uses the AMD Cool'n'Quiet technology Q945600 KB945600 December 11, 2007
• 945896 FIX: Error message when you run a complex query in SQL Server 2005: "The query processor ran out of stack space during query optimization" Q945896 KB945896 December 10, 2007
• 945539 SQL Server 2005 cannot index some 2007 Office document formats Q945539 KB945539 December 5, 2007
• 945066 SQL Server 2005 does not validate all articles in a transactional publication when you run the sp_publication_validation stored procedure to validate the articles Q945066 KB945066 December 5, 2007
• 938910 FIX: Error message when you execute a maintenance plan that contains a Rebuild Index task in SQL Server 2005 Service Pack 2: "The Execute method on the task returned error code 0x8007000E (Exception of type 'System.OutOfMemoryException' was thrown)" Q938910 KB938910 December 4, 2007
• 273673 Description of SQL Virtual Server client connections Q273673 KB273673 December 4, 2007
• 945323 FIX: The logins are incorrectly deleted when you run a SQL Server 2005 Integration Services package that contains a Transfer SQL Server Objects task Q945323 KB945323 December 3, 2007
• 325877 How to control access to a database on a Web server in Windows Server 2003 Q325877 KB325877 December 3, 2007