SQL Server 2005 articles, fixes and updates - letter F

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

• 2455009 FIX: Slow performance when you recover a database if there are many VLFs inside the transaction log in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2 Q2455009 KB2455009 October 18, 2022
• 2860310 FIX: Incorrect results when you run a query that uses a LIKE operator in a WHERE clause in SQL Server Compact 3.5 Q2860310 KB2860310 January 26, 2021
• 2718718 FIX: "Cannot open the shared memory" error message when you try to create or open a SQL Server Compact 3.5 SP2 database file on a shared network folder Q2718718 KB2718718 January 26, 2021
• 2616117 FIX: Incorrect mail profile is displayed in the Alert System page in SQL Server 2008 R2 Q2616117 KB2616117 January 26, 2021
• 2598903 FIX: SQL Server Agent job randomly stops when you schedule the job to run past midnight on specific days in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2 Q2598903 KB2598903 January 26, 2021
• 2591902 FIX: XML data loss when a merge replication encounters a foreign key violation error in SQL Server 2005, in SQL Server 2008, in SQL Server 2008 R2, or in SQL Server 2012 Q2591902 KB2591902 January 26, 2021
• 2590839 FIX: Low CPU spikes at a set interval even without user activity in SQL Server 2008 R2 or in SQL Server 2012 Q2590839 KB2590839 January 26, 2021
• 2585082 FIX: "A specified value violated the integrity constraints for a column or table" error if the merge publication contains many articles and constraints in SQL Server Compact 3.5 Q2585082 KB2585082 January 26, 2021
• 2583994 FIX: SSIS Checkpoint restores an incorrect variable value for an Execute SQL Task item of a For Loop Container item in SSIS 2008 or in SSIS 2008 R2 if an SSIS package executes again after it fails or stops Q2583994 KB2583994 January 26, 2021
• 2539378 FIX: Replmerg.exe crashes when it enumerates changes to a statement in SQL Server if the stored procedure contains more than 4,000 characters Q2539378 KB2539378 January 26, 2021
• 2526552 FIX: SQL Server Browser service periodically does not respond to incoming requests Q2526552 KB2526552 January 26, 2021
• 2515286 FIX: "There is no function '{urn:schemas-microsoft-com:xml-sql}:variable()" error for an XQuery query that updates the value of an XML column in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2 Q2515286 KB2515286 January 26, 2021
• 2511151 FIX: Column of a Flat File source is not imported if the next column data is one byte longer than the output column width in SSIS 2005, SSIS 2008 or in SSIS 2008 R2 Q2511151 KB2511151 January 26, 2021
• 2498818 FIX: Error 7359 when you run a query against a user-defined function or a view that uses a synonym on a linked server in SQL Server 2005, SQL Server 2008 or SQL Server 2008 R2 Q2498818 KB2498818 January 26, 2021
• 2490920 FIX: "Msg 2601, Level 14, State 1, Line 1 Cannot insert duplicate key row" error when you run the ALTER PARTITION FUNCTION statement to split or merge a partition range in SQL Server 2005 or in SQL Server 2008 Q2490920 KB2490920 January 26, 2021
• 2489667 FIX: SQL Server Agent job runs incorrectly if it is scheduled to run every hour on the last day of every week or month in SQL Server 2005 or in SQL Server 2008 or in SQL Server 2008 R2 Q2489667 KB2489667 January 26, 2021
• 2482977 FIX: 10061 Winsock error code occurs when an application uses the extended OLE DB initialization properties for the SQL Server Native Client 10.0 OLE DB provider in the connection string Q2482977 KB2482977 January 26, 2021
• 2481274 FIX: A query that uses the DATEDIFF function may run slowly in SQL Server 2005 or in SQL Server 2008 or in SQL Server 2008 R2 Q2481274 KB2481274 January 26, 2021
• 2451540 FIX: Poor performance may occur when you execute a query that contains multiple self-join operations on the same column in SQL Server 2005, in SQL Server 2008 and in SQL Server 2008 R2 Q2451540 KB2451540 January 26, 2021
• 2448991 FIX: The variables of an SSIS 2008, SSIS 2008 R2 or SSIS 2005 package are evaluated incorrectly when you run the package in parallel Q2448991 KB2448991 January 26, 2021
• 2413430 FIX: "Cannot locate version record and page is not allocated" error message occurs when you rebuild an index by using the ONLINE option in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2 Q2413430 KB2413430 January 26, 2021
• 2407172 FIX: An exception occurs before the error output for invalid data of an "XML Source" task is redirected in SSIS 2005, SSIS 2008 or SSIS 2008R2 Q2407172 KB2407172 January 26, 2021
• 2403218 FIX: Database mirroring session is suspended in SQL Server 2005 and in SQL Server 2008 and in SQL Server 2008 R2 if the High-performance (asynchronous) mode is used Q2403218 KB2403218 January 26, 2021
• 2295878 FIX: LOB pages that are allocated in a failed INSERT statement may not be reclaimed after you apply SQL Server 2005 SP3, SQL Server 2005 SP4, SQL Server 2008 SP1 or SQL Server 2008 R2 Q2295878 KB2295878 January 26, 2021
• 2295869 FIX: An unresolved deadlock occurs when a database is recovered in SQL Server 2005, SQL Server 2008, or in SQL Server 2008 R2 Q2295869 KB2295869 January 26, 2021
• 2295460 Fix: Replication error message when you register a custom resolver to a merge replication in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2 if a BIGINT column contains a NULL value Q2295460 KB2295460 January 26, 2021
• 2276717 FIX: Error code 1456 when you add a witness to a new database mirroring session that has the same database name as an existing database mirroring session in Microsoft SQL Server 2008 and in Microsoft SQL Server 2008 R2 Q2276717 KB2276717 January 26, 2021
• 2268122 FIX: "User 'guest' does not have permission to run DBCC checkdb for database 'mssqlsystemresource'" error message when you run the DBCC CHECKDB('master') command on a computer that is running SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 Q2268122 KB2268122 January 26, 2021
• 2261403 FIX: The "SQL Server:SSIS Pipeline 10.0" performance object does not appear in the "Performance object" list while another user accesses some SSIS pipeline counters in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2005 Q2261403 KB2261403 January 26, 2021
• 2159286 FIX: The Remote Registry service crashes when an application tries to retrieve performance counter data from an instance of SQL Server on another computer Q2159286 KB2159286 January 26, 2021
• 983516 FIX: A Deadlock occurs when two transactions try to perform a DML operation on a table that contains a TABLOCK locking hint or an XLOCK locking hint Q983516 KB983516 January 26, 2021
• 982376 FIX: A non-yielding scheduler error or an error 8623 occurs when you run a query that contains a large IN clause in SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 Q982376 KB982376 January 26, 2021
• 980849 FIX: You experience high latency for peer-to-peer distribution agents in Microsoft SQL Server 2005, Microsoft SQL Server 2008, or Microsoft SQL Server 2008 R2 Q980849 KB980849 January 26, 2021
• 980142 FIX: "Provider Load Failure" error message or the Wmiprvse.exe process stops responding when you use a SQL Server WMI provider to obtain information about SQL Server 2012, SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 services Q980142 KB980142 January 26, 2021
• 979212 FIX: A DateTime value is replaced by a NULL value when a conflict is resolved by using a custom resolver in Microsoft SQL Server 2005, Microsoft SQL Server 2008 or Microsoft SQL Server 2008 R2 merge replication Q979212 KB979212 January 26, 2021
• 974660 FIX: You receive out-of-memory error messages when you use merge replication with Web synchronization in SQL Server 2005 or in SQL Server 2008 Q974660 KB974660 January 26, 2021
• 973524 FIX: The execution of the xp_readerrorlog command in SQL Server 2005 and in SQL Server 2008 stops responding and the usage of the CPU that is running the command increases to 100 percent Q973524 KB973524 January 26, 2021
• 969845 FIX: Error message when you run a SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 Integration Services package (SSIS) after you install the .NET Framework 2.0 SP2 or the .NET Framework 3.5 SP1: "ADO NET Source [1424]" Q969845 KB969845 January 26, 2021
• 968834 FIX: Error message when you send an e-mail by using Database Mail in SQL Server 2005 or in SQL Server 2008: "The operation has timed out" Q968834 KB968834 January 26, 2021
• 959015 FIX: A conflict with the foreign key constraint occurs when you update the case of the column values in the primary key table or you pad column values in the primary key table in SQL Server 2005 Q959015 KB959015 January 26, 2021
• 958478 FIX: Error message when you run a "LINQ to Entities" query that uses a string parameter or a binary parameter against a SQL Server Compact 3.5 database: "The ntext and image data types cannot be used in WHERE, HAVING, GROUP BY, ON, or IN... Q958478 KB958478 January 26, 2021
• 958006 FIX: The size of the error log file for the SQL Server 2008 error log file grows very quickly when query notifications are created and destroyed in a high ratio Q958006 KB958006 January 26, 2021
• 954950 FIX: Error message when you run a distributed query in SQL Server 2005 or SQL Server 2008: "OLE DB provider 'SQLNCLI' for linked server '<Linked Server>' returned message 'No transaction is active'" Q954950 KB954950 January 26, 2021
• 942712 FIX: The W3WP.exe process of Internet Information Services stops unexpectedly when you configure a merge replication that uses Web synchronization in SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2 Q942712 KB942712 January 26, 2021
• 934458 FIX: The Check Database Integrity task and the Execute T-SQL Statement task in a maintenance plan may lose database context in certain circumstances in SQL Server 2005 builds 3042 through 3053 Q934458 KB934458 January 26, 2021
• 930283 FIX: You receive error 1456 when you add a witness to a database mirroring session and the database name is the same as an existing database mirroring session in SQL Server 2005 or SQL Server 2008 Q930283 KB930283 January 26, 2021
• 926421 FIX: You receive error messages when you use SQL Server Management Studio or SQL Server Business Intelligence Development Studio after you install Microsoft Office Excel 2007 on a computer that has SQL Server 2005 Analysis Services installed Q926421 KB926421 January 26, 2021
• 926292 FIX: When you query through a view that uses the ORDER BY clause in SQL Server 2008, the result is still returned in random order Q926292 KB926292 January 26, 2021
• 924291 FIX: Error message when you execute a user-defined function in SQL Server 2005: "Invalid length parameter passed to the SUBSTRING function" or "A transport-level error has occurred when receiving results from the server" Q924291 KB924291 January 26, 2021
• 922578 FIX: Lots of messages that have message ID 19030 and message ID 19031 are logged in SQL Server 2005, SQL Server 2008 or SQL Server 2008 R2 Errorlog file when you use SQL Server Profile in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2 Q922578 KB922578 January 26, 2021
• 972767 FIX: The SQL Server database engine and SQL Server Reporting Services may consume more power on Windows client computers than expected Q972767 KB972767 January 25, 2021
• 975681 FIX: The database mirroring session is suspended when you add more than one log transaction file to a folder on the principle server that does not exist on the mirror server in SQL Server 2005 or in SQL Server 2008 Q975681 KB975681 September 29, 2020
• 975090 FIX: Deadlocks may occur when multiple concurrent query notification subscriptions are fired on same objects in SQL Server 2005 or in SQL Server 2008 Q975090 KB975090 September 29, 2020
• 972498 FIX: You receive error messages or data is damaged after you run an SSIS package that contains a data flow task in a low memory situation in SQL Server 2005 or in SQL Server 2008 Q972498 KB972498 September 29, 2020
• 971402 FIX: Error message when you send an e-mail by using a private Database Mail profile in SQL Server 2005 or in SQL Server 2008: "profile name is not valid" Q971402 KB971402 September 29, 2020
• 969611 FIX: Error message when you run a job whose owner is a Windows user account after SQL Server 2005 Agent or SQL Server 2008 Agent is restarted: "The job failed. The owner () of job <Job Name> does not have server access" Q969611 KB969611 September 29, 2020
• 961282 FIX: Error message when you try to display a report in SQL Server 2008 Management Studio: "System.IndexOutOfRangeException: Index was outside the bounds of the array" Q961282 KB961282 September 29, 2020
• 942657 FIX: You have to enter the old password of a SQL Server login when you try to change the password of the login by using SQL Server Management Studio in SQL Server 2005 Q942657 KB942657 February 20, 2020
• 939285 FIX: Error message when you run a stored procedure that starts a transaction that contains a Transact-SQL statement in SQL Server 2005: "New request is not allowed to start because it should come with valid transaction descriptor" Q939285 KB939285 February 20, 2020
• 937745 FIX: You may receive error messages when you try to log in to an instance of SQL Server 2005 and SQL Server handles many concurrent connections Q937745 KB937745 February 20, 2020
• 937545 FIX: Error message when you use the BULK INSERT statement to import a data file into a table in SQL Server 2005 with SP1: "The OLE DB provider "BULK" for linked server "(null)" reported an error" Q937545 KB937545 February 20, 2020
• 937544 FIX: You may receive error 3456 when you try to restore a transaction log for a SQL Server 2005 database Q937544 KB937544 February 20, 2020
• 937517 FIX: Error message when you commit a distributed transaction that contains a query that retrieves data from a linked server in SQL Server 2005: "Transaction manager has cancelled the distributed transaction" Q937517 KB937517 February 20, 2020
• 937343 FIX: SQL Server 2005 stops and then restarts unexpectedly, and errors occur in the tempdb database Q937343 KB937343 February 20, 2020
• 937277 FIX: A memory leak occurs when you use the sp_OAMethod stored procedure or the sp_OAGetProperty stored procedure to call a method of a COM object in SQL Server 2005 Q937277 KB937277 February 20, 2020
• 937041 FIX: Changes in the publisher database are not replicated to the subscribers in a transactional replication if the publisher database runs exposed in a database mirroring session in SQL Server 2005 Q937041 KB937041 February 20, 2020
• 935446 FIX: You receive error messages when you use the BULK INSERT statement in SQL Server 2005 to import data in bulk Q935446 KB935446 February 20, 2020
• 934226 FIX: Error message when you try to use Database Mail to send an e-mail message in SQL Server 2005: "profile name is not valid (Microsoft SQL Server, Error 14607)" Q934226 KB934226 February 20, 2020
• 932556 FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 1500 and later builds Q932556 KB932556 February 20, 2020
• 931821 FIX: High CPU utilization by SQL Server 2005 may occur when you use NUMA architecture on a computer that has SQL Server 2005 installed Q931821 KB931821 February 20, 2020
• 930775 FIX: Error message when you try to retrieve rows from a cursor that uses the OPTION (RECOMPILE) query hint in SQL Server 2005: "Could not complete cursor operation because the table schema changed after the cursor was declared" Q930775 KB930775 February 20, 2020
• 929240 FIX: I/O requests that are generated by the checkpoint process may cause I/O bottlenecks if the I/O subsystem is not fast enough to sustain the IO requests in SQL Server 2005 Q929240 KB929240 February 20, 2020
• 926773 FIX: Error message when you run a query that uses a fast forward-only cursor in SQL Server 2005: "Query processor could not produce a query plan because of the hints defined in this query" Q926773 KB926773 February 20, 2020
• 925001 FIX: Error message when you run queries between two SQL Server 2005 linked servers: "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'" Q925001 KB925001 February 20, 2020
• 922804 FIX: After you detach a Microsoft SQL Server 2005 database that resides on network-attached storage, you cannot reattach the SQL Server database Q922804 KB922804 February 20, 2020
• 916086 FIX: Errors may be generated in the tempdb database when you create and then drop many temporary tables in SQL Server 2005 Q916086 KB916086 February 20, 2020
• 941105 FIX: Error messages after SQL Server has been running for some time on Windows Server 2003 or on Windows 2000: "Failed to load FileName.dll" and "Attempts to load any type of dll might fail within the SQL Server process" Q941105 KB941105 November 20, 2019
• 928323 FIX: A script task or a script component is executed multiple times in duplicate when you run packages that contain script tasks or script components in parallel in SSIS Q928323 KB928323 November 20, 2019
• 928083 FIX: You may receive an error message when you run a CLR stored procedure or CLR function that uses a context connection in SQL Server 2005 Q928083 KB928083 November 20, 2019
• 953568 FIX: The synchronization operation of a merge replication times out in Microsoft SQL Server 2005 Q953568 KB953568 November 6, 2019
• 983390 FIX: ACCESS_VIOLATION error when you rebuild indexes online in Microsoft SQL Server 2005 Q983390 KB983390 September 21, 2018
• 936179 FIX: Error message when you use SQL Native Client to connect to an instance of a principal server in a database mirroring session: "The connection attempted to fail over to a server that does not have a failover partner" Q936179 KB936179 May 17, 2018
• 953481 FIX: Error message when you try to insert data on a subscriber of a merge replication in SQL Server 2005: "Msg 548, Level 16, State 2, Line 1. The insert failed" Q953481 KB953481 May 10, 2018
• 940126 FIX: Error 9003 is logged in the SQL Server error log file when you use log shipping in SQL Server 2005 Q940126 KB940126 May 10, 2018
• 938102 FIX: Error messages when you run a query that references a view in SQL Server 2005 Service Pack 2: “A severe error occurred on the current command. The results, if any, should be discarded” Q938102 KB938102 May 10, 2018
• 929376 FIX: A "17187" error message may be logged in the Errorlog file when an instance of SQL Server 2005 is under a heavy load Q929376 KB929376 May 10, 2018
• 974205 FIX: Error message in the Errorlog file of SQL Server 2005 or of SQL Server 2008 after the SQL Server service stops responding: "Timeout occurred while waiting for latch" Q974205 KB974205 April 21, 2018
• 969775 FIX: Distribution Agent fails when you try to apply a snapshot for a newly added view in a publication in SQL Server 2005 or in SQL Server 2008 Q969775 KB969775 April 21, 2018
• 978430 FIX: The Ghost Cleanup task uses 100% of the CPU on an idle system in SQL Server 2008 or in SQL Server 2005 Q978430 KB978430 April 20, 2018
• 908915 FIX: You receive an error message when you use Microsoft OLE DB Provider for Visual FoxPro in SQL Server Q908915 KB908915 April 18, 2018
• 944390 FIX: Error message when you connect to a named instance of SQL Server on a client computer that is running Windows Vista or Windows Server 2008: "Specified SQL server not found" or "Error Locating Server/Instance Specified" Q944390 KB944390 April 18, 2017
• 925744 FIX: Error message when you try to use a SQL Server authenticated login to log on to an instance of SQL Server 2005: "Logon error: 18456" Q925744 KB925744 March 30, 2017
• 922853 FIX: You may receive an error message when you try to use the Aggregation Design Wizard to design aggregations in SQL Server 2005 Analysis Services Q922853 KB922853 March 30, 2017
• 922063 FIX: You may notice a large increase in compile time when you enable trace flags 2389 and 2390 in SQL Server 2005 Service Pack 1 Q922063 KB922063 March 30, 2017
• 921292 FIX: You may receive a "0x80004005 (E_FAIL)" error message when you use a range rowset in OLE DB for OLAP in a SQL Server 2005 Analysis Services-based application Q921292 KB921292 March 30, 2017
• 921106 FIX: You receive an error message when you try to create a differential database backup in SQL Server 2005 Q921106 KB921106 March 30, 2017
• 919568 FIX: You may receive an error message when you use an escaped single quotation mark to set a parameter value for a prepared statement in the SQL Server 2005 JDBC Driver Q919568 KB919568 March 30, 2017
• 918644 FIX: The SQL Server Integration Services (SSIS) service does not start when you install SQL Server 2005 SP1 on a computer that is already running the SSIS service Q918644 KB918644 March 30, 2017
• 912017 FIX: Error message when you connect to an instance of SQL Server 2005 Analysis Services: "A connection cannot be made. Ensure that the server is running." Q912017 KB912017 March 30, 2017
• 936185 FIX: Blocking and performance problems may occur when you enable trace flag 1118 in SQL Server 2005 if the temporary table creation workload is high Q936185 KB936185 March 29, 2017
• 933564 FIX: A gradual increase in memory consumption for the USERSTORE_TOKENPERM cache store occurs in SQL Server 2005 Q933564 KB933564 February 16, 2017
• 926612 FIX: SQL Server Agent does not send an alert quickly or does not send an alert when you use an alert of the SQL Server event alert type in SQL Server 2005 Q926612 KB926612 February 16, 2017
• 912439 FIX: Error message when you try to run several queries on large data sets at the same time in SQL Server 2005: "701 There is insufficient system memory to run this query" Q912439 KB912439 February 16, 2017
• 905417 FIX: Error message when you try to open SQL Server 2000 Data Transformation Services (DTS) packages in SQL Server Management Studio: "SQL Server 2000 DTS Designer components are required to edit DTS packages" Q905417 KB905417 February 16, 2017
• 910416 FIX: Error message when you run certain queries or certain stored procedures in SQL Server 2005: "A severe error occurred on the current command" Q910416 KB910416 February 15, 2017
• 910070 FIX: The SQL Server 2005 Setup program may take much longer than expected to finish running Q910070 KB910070 February 15, 2017
• 953721 FIX: The performance of a query in SQL Server 2005 Service Pack 2 Cumulative Update 6 is slow Q953721 KB953721 December 10, 2015
• 938748 FIX: You obtain inconsistent results when you run an MDX query that uses the Siblings function against an instance of SQL Server 2005 Analysis Services compared to an instance of SQL Server 2000 Analysis Services Q938748 KB938748 December 10, 2015
• 932610 FIX: Error message when you run an MDX query in SQL Server 2005 Analysis Services: "An unexpected error occurred (file 'pffilestore.cpp', line 3267, function 'PFFileStore::HandleDataPageFault')" Q932610 KB932610 December 9, 2015
• 932609 FIX: Error message when you use the Association Rules algorithm to process a data mining model in SQL Server 2005 Analysis Services: "This number of attributes exceeds the attribute limit of 5000 allowed by the current version of the algorithm" Q932609 KB932609 December 9, 2015
• 932608 FIX: You obtain an incorrect prediction when you browse a mining structure that is created by using the Microsoft Association algorithm in SQL Server 2005 Analysis Services Q932608 KB932608 December 9, 2015
• 931329 FIX: Error message when you run a query in Microsoft SQL Server 2005: "Msg 8624, Level 16, State 116 Internal Query Processor Error: The query processor could not produce a query plan" Q931329 KB931329 December 9, 2015
• 928792 FIX: The output rows of the Aggregate transformation are divided into multiple rows in SQL Server 2005 Integration Services Q928792 KB928792 December 9, 2015
• 928789 FIX: Error message in the database mail log when you try to use the sp_send_dbmail stored procedure to send an e-mail in SQL Server 2005: "Invalid XML message format received on the ExternalMailQueue" Q928789 KB928789 December 9, 2015
• 926240 FIX: SQL Server 2005 may stop responding when you use the SqlBulkCopy class to import data from another data source Q926240 KB926240 December 9, 2015
• 923296 FIX: Log Reader Agent fails, and an assertion error message is logged when you use transactional replication in SQL Server 2005 Q923296 KB923296 December 9, 2015
• 917070 FIX: Error message when you use SQL Server 2005 Report Manager to try to run a linked report: "An internal catalog exception has occurred" Q917070 KB917070 December 9, 2015
• 925058 FIX: Error message when you create a new subscription to a report in SQL Server 2005 Reporting Services: "Error: Object expected" Q925058 KB925058 January 17, 2015
• 925057 FIX: Color images in a report appear in grayscale after you export the report to a PDF file in SQL Server 2005 Reporting Services Q925057 KB925057 January 17, 2015
• 925050 FIX: The result set is returned very slowly when you use the ResultSet object that is included in the SQL Server 2005 JDBC Driver 1.1 Q925050 KB925050 January 17, 2015
• 924954 FIX: Error message when you use a table-valued function (TVF) together with the CROSS APPLY operator in a query in SQL Server 2005: "There is insufficient system memory to run this query" Q924954 KB924954 January 17, 2015
• 924808 FIX: You receive an error message, or you obtain an incorrect result when you query data in a partitioned table that does not have a clustered index in SQL Server 2005 Q924808 KB924808 January 17, 2015
• 924807 FIX: The restore operation may take a long time to finish when you restore a database in SQL Server 2005 Q924807 KB924807 January 17, 2015
• 924686 FIX: The database mirroring session may remain in the synchronizing state and may stop responding when a database failover occurs in SQL Server 2005 Q924686 KB924686 January 17, 2015
• 924601 FIX: A partitioned table may generate an inefficient query plan when you run a Transact-SQL query that uses the Top n clause on a partitioned table in SQL Server 2005 Q924601 KB924601 January 17, 2015
• 924346 FIX: An access violation may intermittently occur when you run a SQL Server Integration Services package in SQL Server 2005 Q924346 KB924346 January 17, 2015
• 924345 FIX: Error message when you try to open a file attachment in a message that is generated by the sp_send_dbmail procedure in SQL Server 2005: "This file is not in a recognizable format" Q924345 KB924345 January 17, 2015
• 924344 FIX: You may receive incorrect results when you use the bulk copy program command-line utility to import data in SQL Server 2005 Q924344 KB924344 January 17, 2015
• 924264 FIX: The metadata of the Description object of a Key Performance Indicator appears in the default language after you define a translation for the Description object in SQL Server 2005 Business Intelligence Development Studio Q924264 KB924264 January 17, 2015
• 924012 FIX: Error message when you try to process a cube that has a relationship between two tables in a data source view that contains more than four keys in SQL Server 2005 Analysis Services: "000042ac" Q924012 KB924012 January 17, 2015
• 923849 FIX: When you run a query that references a partitioned table in SQL Server 2005, query performance may decrease Q923849 KB923849 January 17, 2015
• 923624 FIX: Error message when you run an application against SQL Server 2005 that uses many unique user logins or performs many user login impersonations: "insufficient system memory to run this query" Q923624 KB923624 January 17, 2015
• 923623 FIX: Error message when you use Report Builder after you install SQL Server 2005 Reporting Services SP1: "Short time pattern does not include hours and minutes" Q923623 KB923623 January 17, 2015
• 923478 FIX: You receive an error message when you deploy a cube dimension that has a dimension description in Business Intelligence Development Studio Q923478 KB923478 January 17, 2015
• 923477 FIX: Unfiltered results may be generated when you use a drillthrough action on a dimension that is stored in the ROLAP storage mode in SQL Server 2005 Analysis Services Q923477 KB923477 January 17, 2015
• 923476 FIX: An MDX query may never finish when you run the MDX query against a parent/child dimension in SQL Server 2005 Analysis Services Q923476 KB923476 January 17, 2015
• 923475 FIX: The cells may be incorrectly updated when you execute multiple UPDATE CUBE statements in a single transaction in SQL Server 2005 Analysis Services Q923475 KB923475 January 17, 2015
• 923473 FIX: SQL Server 2005 Analysis Services may stop responding when you try to process a ROLAP dimension two times Q923473 KB923473 January 17, 2015
• 923436 FIX: JavaScript error message when you click a hyperlink in a SQL Server 2005 Reporting Services report that you view by using a ReportViewer control from Visual Studio 2005: "Can’t execute code from a freed script" Q923436 KB923436 January 17, 2015
• 923304 FIX: Error message when you run a MDX query after you install the cumulative hotfix package for SQL Server 2005 Analysis Services for Itanium-based operating systems (build 9.0.2153): "Internal error: An unexpected exception occured" Q923304 KB923304 January 17, 2015
• 923301 FIX: SQL Server 2005 Analysis Services continually generates minidump files when you try to deploy a new cube Q923301 KB923301 January 17, 2015
• 923300 FIX: The calculated members are not returned in subsequence levels when you run an XML for Analysis (XMLA) script to retrieve child members at a level that is in a hierarchy in SQL Server 2005 Analysis Services Q923300 KB923300 January 17, 2015
• 923008 FIX: Error message when you use the Bcp.exe utility to import data into a table from a text file in SQL Server 2005: "The memory could not be written" Q923008 KB923008 January 17, 2015
• 922852 FIX: You may experience high CPU utilization across multiple processors when you run a SQL Server 2005 Analysis Services query against a large partition or lots of partitions Q922852 KB922852 January 17, 2015
• 922798 FIX: A member property is returned in an unexpected data type when you call the "IMDDataset::GetAxisRowset" interface in SQL Server 2005 Analysis Services Q922798 KB922798 January 17, 2015
• 922594 FIX: Error message when you use SQL Server 2005: "High priority system task thread Operating system error Exception 0xAE encountered" Q922594 KB922594 January 17, 2015
• 922579 FIX: The operation may take longer than you expect when you run a warm query to obtain information from the Microsoft Search service in SQL Server 2005 Q922579 KB922579 January 17, 2015
• 922577 FIX: You may receive "UnavailableException" and "LogonFailedException" error messages when you perform a stress test on the report server in SQL Server 2005 Reporting Services Q922577 KB922577 January 17, 2015
• 922527 FIX: Error message when you schedule some SQL Server 2005 Integration Services packages to run as jobs: "Package <PackageName> has been cancelled" Q922527 KB922527 January 17, 2015
• 922438 FIX: A query may take a long time to compile when the query contains several JOIN clauses against a SQL Server 2005 database Q922438 KB922438 January 17, 2015
• 922436 FIX: You receive an error message in a Visual Studio Just-In-Time Debugger dialog box when you debug a SQL Server 2005 Integration Services package in SQL Server Business Intelligence Development Q922436 KB922436 January 17, 2015
• 922296 FIX: You may receive an access violation error message when you run a query against a linked server in SQL Server 2005 Q922296 KB922296 January 17, 2015
• 921536 FIX: A handled access violation may occur in the CValSwitch::GetDataX function when you run a complex query in SQL Server 2005 Q921536 KB921536 January 17, 2015
• 921405 FIX: An image placeholder that contains a red X appears when you run a report in SQL Server 2005 Reporting Services Q921405 KB921405 January 17, 2015
• 921395 FIX: The color and the background image may not appear when you try to display a report in HTML format in Report Manager in SQL Server 2005 Reporting Services Q921395 KB921395 January 17, 2015
• 921295 FIX: You may receive an incorrect result when you try to run a Multidimensional Expressions (MDX) query by using SQL Server 2005 Q921295 KB921295 January 17, 2015
• 921294 FIX: You may receive an error message when you try to process a measure group under a low-memory condition in SQL Server 2005 Analysis Services Q921294 KB921294 January 17, 2015
• 921293 FIX: The description for the Dimension field is not set in the local cube file when you use the CREATE LOCAL CUBE statement in SQL Server 2005 Q921293 KB921293 January 17, 2015
• 921003 FIX: You may receive an error message when you manually define a Back Up Database task in SQL Server 2005 to back up the transaction log Q921003 KB921003 January 17, 2015
• 920974 FIX: SQL Server 2005 treats an identity column in a view as an ordinary int column when the compatibility level of the database is set to 80 Q920974 KB920974 January 17, 2015
• 920794 FIX: The size of the e-mail message is very large when you use Database Mail in SQL Server 2005 to send query results to users Q920794 KB920794 January 17, 2015
• 920765 FIX: The ResultSet.getBoolean method in the SQL Server 2005 JDBC Driver version 1.0 returns False when you retrieve data from a column of type char or varchar that has the value 1 Q920765 KB920765 January 17, 2015
• 920347 FIX: The SQL Server 2005 query optimizer may incorrectly estimate the cardinality for a query that has a predicate that contains an index union alternative Q920347 KB920347 January 17, 2015
• 920346 FIX: SQL Server 2005 may overestimate the cardinality of the JOIN operator when a SQL Server 2005 query contains a join predicate that is a multicolumn predicate Q920346 KB920346 January 17, 2015
• 920340 FIX: A query may return incorrect results when you run the query against a SQL Server 2005 Analysis Services cube Q920340 KB920340 January 17, 2015
• 920298 FIX: Error message when you try to add a configuration to a SQL Server 2005 Integration Services .dtsx package: "An error occurred while a new configuration was being added" Q920298 KB920298 January 17, 2015
• 920206 FIX: System performance may be slow when an application submits many queries against a SQL Server 2005 database that uses simple parameterization Q920206 KB920206 January 17, 2015
• 920203 FIX: You receive inconsistent return values when you use Microsoft SQL Server 2005 Analysis Services to perform several queries for the same measure in a local cube Q920203 KB920203 January 17, 2015
• 920116 FIX: A SELECT query that uses the LIKE clause may return incorrect results in SQL Server 2005 Compact Edition Q920116 KB920116 January 17, 2015
• 919957 FIX: Some cells return the NULL value instead of returning the actual value when you query a dimension that contains a parent/child hierarchy in a SQL Server 2005 Analysis Services cube Q919957 KB919957 January 17, 2015
• 919956 FIX: Error message when you execute an MDX query that calls a VBA function in SQL Server 2005 Service Pack 1: "PFE_ASSEMBLY_NOT_SAFETOPREPARE" Q919956 KB919956 January 17, 2015
• 919955 FIX: You may receive incorrect results when you run a Multidimensional Expressions (MDX) query that involves a calculated member and the autoexist functionality in SQL Server 2005 Analysis Services Q919955 KB919955 January 17, 2015
• 919949 FIX: The sp_MSinitDynamicSubscriber stored procedure is called more than one time by using the same parameters in SQL Server 2005 Q919949 KB919949 January 17, 2015
• 919905 FIX: A query may take longer to run in SQL Server 2005 SP1 than it takes to run in the original release version of SQL Server 2005 or in SQL Server 2000 Q919905 KB919905 January 17, 2015
• 919839 FIX: The Distribution Agent may not apply transactions when you use transactional replication with a published Oracle table and the table contains a column that uses the number data type in SQL Server 2005 Q919839 KB919839 January 17, 2015
• 919775 FIX: The BULK INSERT statement may not return any errors when you try to import data from a text file to a table by using the BULK INSERT statement in Microsoft SQL Server 2005 Q919775 KB919775 January 17, 2015
• 919731 FIX: SQL Server Analysis Services 2005 system performance may be slow after you use the ADOMD.NET data provider to run an MDX query that returns a large result set from a cube Q919731 KB919731 January 17, 2015
• 919636 FIX: Memory usage of the compiled query plan may unexpectedly increase in SQL Server 2005 Q919636 KB919636 January 17, 2015
• 919609 FIX: The SQL-DMO SpaceAvailableInMB property of the Database object may return an incorrect value in SQL Server 2005 or in SQL Server 2000 Q919609 KB919609 January 17, 2015
• 919556 FIX: You cannot select a multivalued parameter from a drop-down list when you view a report in Report Manager in SQL Server 2005 Reporting Services Q919556 KB919556 January 17, 2015
• 919538 FIX: SQL Server 2005 Reporting Services cannot generate an error message in a report when the data source of the report calls a stored procedure that contains the RAISERROR statement Q919538 KB919538 January 17, 2015
• 919243 FIX: Some rows in the Text Data column are always displayed for a trace that you create by using SQL Server Profiler in SQL Server 2005 Q919243 KB919243 January 17, 2015
• 919193 FIX: A forward-only cursor may be implicitly converted to a keyset cursor in SQL Server 2005 Q919193 KB919193 January 17, 2015
• 919150 FIX: Error message when you run SQL Server 2005 Mobile Edition: "80004005 unspecified error" Q919150 KB919150 January 17, 2015
• 919144 FIX: An access violation may occur when you enable the "lazy schema validation" option for any linked server and when you run a distributed partitioned view query in SQL Server 2005 Q919144 KB919144 January 17, 2015
• 919006 FIX: An exception occurs when you try to perform a one-phase commit on an XA-enabled JDBC connection in SQL Server 2005 Q919006 KB919006 January 17, 2015
• 918882 FIX: A query plan is not cached in SQL Server 2005 when the text of the hint is a large object Q918882 KB918882 January 17, 2015
• 918833 FIX: A cell writeback operation in SQL Server 2005 Analysis Services takes a significantly longer time than a cell writeback operation in SQL Server 2000 Analysis Services Q918833 KB918833 January 17, 2015
• 918832 FIX: An inefficient or incorrect SQL query is generated when you try to use SQL Server 2005 to browse a ROLAP dimension Q918832 KB918832 January 17, 2015
• 918756 FIX: The restore operation may fail when you try to restore a database to a new database name in SQL Server 2005 Analysis Services Q918756 KB918756 January 17, 2015
• 918753 FIX: You receive an access violation error message on a server that is running SQL Server 2005 Analysis Services when you run a MDX query that contains a user-defined function Q918753 KB918753 January 17, 2015
• 918747 FIX: You receive an access violation error message when you try to restore a SQL Server 2005 Analysis Services database Q918747 KB918747 January 17, 2015
• 918735 FIX: You may experience decreased performance when you browse a ragged hierarchy dimension that uses the HideMemberIf property in SQL Server 2005 Analysis Service Q918735 KB918735 January 17, 2015
• 918677 FIX: Expected performance benefits may not occur when you process partitions in parallel in SQL Server 2005 Analysis Services on a computer that uses NUMA Q918677 KB918677 January 17, 2015
• 918555 FIX: Error message when you use Report Manager in SQL Server 2005 Reporting Services to view a report: "The request failed with an empty response" Q918555 KB918555 January 17, 2015
• 918529 FIX: You cannot open a SQL Server 2005 report in some versions of Excel after you render the report to an Excel format Q918529 KB918529 January 17, 2015
• 918276 FIX: You notice additional random trailing character in values when you retrieve the values from a fixed-size character column or a fixed-size binary column of a table in SQL Server 2005 Q918276 KB918276 January 17, 2015
• 918251 FIX: You receive an incorrect grand total for a measure when you browse a cube in SQL Server 2005 Analysis Services Q918251 KB918251 January 17, 2015
• 918210 FIX: You receive an error message when you use a range rowset to iterate through rows that are returned by a Multidimensional Expressions (MDX) query in SQL Server 2005 Analysis Services Q918210 KB918210 January 17, 2015
• 918105 FIX: You may receive an error message when you run Database Engine Tuning Advisor by using the dta command-prompt utility in SQL Server 2005 Q918105 KB918105 January 17, 2015
• 917971 FIX: You may receive more than 100,000 page faults when you try to back up a SQL Server 2005 database that contains hundreds of files and file groups Q917971 KB917971 January 17, 2015
• 917940 FIX: The prediction performance of the Microsoft Naive Bayes algorithm may be slower than the prediction performance of other algorithms for the same mining model in SQL Server 2005 Analysis Services Q917940 KB917940 January 17, 2015
• 917929 FIX: In SQL Server 2005 Analysis Services, the session-scoped calculated members or the query-defined calculated members may not return the expected results Q917929 KB917929 January 17, 2015
• 917905 FIX: SQL Server 2005 performance may be slower than SQL Server 2000 performance when you use an API server cursor Q917905 KB917905 January 17, 2015
• 917872 FIX: Error message when you try to connect to SQL Server 2005 Analysis Services from Object Explorer: "System.OutOfMemoryException" Q917872 KB917872 January 17, 2015
• 917870 FIX: An MDX query returns no results and you cannot cancel the operation in SQL Server 2005 Analysis Services Q917870 KB917870 January 17, 2015
• 917824 FIX: The SQL Server 2005 SqlCommandBuilder.DeriveParameters method returns an exception when the input parameter is a XML parameter that has an associated XSD from an SQL schema Q917824 KB917824 January 17, 2015
• 917738 FIX: SQL Server 2005 system performance may be slow when you use a keyset-driven cursor to execute a FETCH statement Q917738 KB917738 January 17, 2015
• 917526 FIX: The chart label values may be displayed incorrectly for the y-axis when you use the Chart control in SQL Server 2005 Reporting Services Q917526 KB917526 January 17, 2015
• 917494 FIX: A "System.NullReferenceException" exception may be logged in the Reporting Services log when you try to create a snapshot report in SQL Server 2005 Reporting Services Q917494 KB917494 January 17, 2015
• 917492 FIX: The MDSCHEMA_PROPERTIES rowset may return the incorrect data type for the user-defined properties in SQL Server 2005 Analysis Services Q917492 KB917492 January 17, 2015
• 917479 FIX: The SQL Server 2005 Analysis Services service does not start if you try to use Japanese_Unicode_CI_AS as a collation for the instance of Analysis Services Q917479 KB917479 January 17, 2015
• 917426 FIX: You receive an error message when you try to create a full-text schedule by using SQL Server Management Studio in localized versions of SQL Server 2005 Q917426 KB917426 January 17, 2015
• 917355 FIX: You receive an error message when you try to connect to a cube that contains a parent-child dimension Q917355 KB917355 January 17, 2015
• 917131 FIX: Error message when you try to use Database Engine Tuning Advisor to analyze the performance effects of a workload that includes an indexed view in SQL Server 2005: "Tuning process exited unexpectedly" Q917131 KB917131 January 17, 2015
• 917100 FIX: The YTD calculation is incorrect when you use the Business Intelligence Wizard to automatically generate a YTD calculation Q917100 KB917100 January 17, 2015
• 917055 FIX: The SQL Server 2005 JDBC Driver may not return the correct dates when you use the getTimestamp(,,Calendar) method or the setTimestamp(,,Calendar) method in a prepared statement Q917055 KB917055 January 17, 2015
• 917054 FIX: You may receive an error message when you use the SQL Server 2005 Driver for JDBC and try to perform a batch insert by using a prepared statement that contains the "SelectMethod=cursor" property on a connection Q917054 KB917054 January 17, 2015
• 917035 FIX: Query performance may decrease after SQL Server 2005 has been running for a while Q917035 KB917035 January 17, 2015
• 917016 FIX: The monitor server does not monitor all primary servers and secondary servers when you configure log shipping in SQL Server 2005 Q917016 KB917016 January 17, 2015
• 916828 FIX: Error message when you use ADOMD.NET in an application to connect to an instance of SQL Server 2005 Analysis Services: "The session, '<SessionID>', does not exist" Q916828 KB916828 January 17, 2015
• 916827 FIX: The false value is always returned when you query the IS_PLACEHOLDERMEMBER member property of a dimension member in SQL Server 2005 Analysis Services Q916827 KB916827 January 17, 2015
• 916820 FIX: An access violation may occur in the Msmdsrv.exe process, and the server may crash when you try to run an Alter DDL command in SQL Server 2005 Analysis Services Q916820 KB916820 January 17, 2015
• 916795 FIX: Error message when you run a query inside a stored procedure in SQL Server 2005: "Internal query processor error" Q916795 KB916795 January 17, 2015
• 916780 FIX: Error message when you try to change a column of a table by using the ALTER TABLE statement in SQL Server 2005: "Could not allocate space" Q916780 KB916780 January 17, 2015
• 916706 FIX: When you run the "dbcc dbreindex" command or the "alter index" command, some transactions are not replicated to the subscribers in a transactional replication in SQL Server 2005 Q916706 KB916706 January 17, 2015
• 916046 FIX: Indexes may grow very large when you insert a row into a table and then update the same row in SQL Server 2005 Q916046 KB916046 January 17, 2015
• 915999 FIX: Error message when you browse a cube in SQL Server 2005 Analysis Services: "The query could not be processed The data provider didn't supply any further error information" Q915999 KB915999 January 17, 2015
• 915918 FIX: The internal deadlock monitor may not detect a deadlock between two or more sessions in SQL Server 2005 Q915918 KB915918 January 17, 2015
• 915836 FIX: The second user can view only the same members that the first user can view when two users connect to an instance of SQL Server 2005 Analysis Services Q915836 KB915836 January 17, 2015
• 915835 FIX: The page breaks in a report are not rendered correctly when you render a SQL Server 2005 Reporting Services report in Excel Q915835 KB915835 January 17, 2015
• 915796 FIX: You may receive unexpected results when you query data from a set that uses the MDX Crossjoin function in SQL Server 2005 Analysis Services Q915796 KB915796 January 17, 2015
• 915795 FIX: An MDX query against a measure group takes much longer than you expect to run, and SQL Server 2005 Analysis Services incorrectly reads data from the partitions instead of from the aggregations Q915795 KB915795 January 17, 2015
• 915793 FIX: You cannot restore the log backups on the mirror server after you remove database mirroring for the mirror database in SQL Server 2005 Q915793 KB915793 January 17, 2015
• 915763 FIX: The Permissions column for the Audit Schema Object Access event does not populate in SQL Server 2005 Q915763 KB915763 January 17, 2015
• 915309 FIX: When you start a merge agent, synchronization between the subscriber and the publisher takes a long time to be completed in SQL Server 2005 Q915309 KB915309 January 17, 2015
• 915308 FIX: The CPU usage of the server reaches 100% when many DML activities occur in SQL Server 2005 Q915308 KB915308 January 17, 2015
• 915307 FIX: You experience a slow uploading process if conflicts occur when many merge agents upload changes to the publishers at the same time in SQL Server 2005 Q915307 KB915307 January 17, 2015
• 915306 FIX: The merge agent fails and a "permission denied" error message is logged when you synchronize a SQL Server 2005-based merge publication Q915306 KB915306 January 17, 2015
• 915112 FIX: Error message when an ADO.NET-connected application tries to reuse a connection from the connection pool in SQL Server 2005: "The request failed to run because the batch is aborted" Q915112 KB915112 January 17, 2015
• 915088 FIX: The .NET Framework 2.0 Thread.IsThreadPoolThread property always returns a value of false, and the SQL Server 2005 Reporting Services log file grows uncontrollably Q915088 KB915088 January 17, 2015
• 915085 FIX: Error message when you run an MDX query that uses the NON EMPTY keyword in SQL Server 2005 Analysis Services: "Errors in the OLAP storage engine" or "Internal error" Q915085 KB915085 January 17, 2015
• 914598 FIX: The Analysis Services service may stop unexpectedly when you run several concurrent queries against a SQL Server 2005 Analysis Services database Q914598 KB914598 January 17, 2015
• 914597 FIX: An MDX query that uses the unique name property returns incorrect results when you use a client tool to run the query in SQL Server 2005 Analysis Services Q914597 KB914597 January 17, 2015
• 914595 FIX: Dimension processing may fail, and you may receive an error message in SQL Server 2005 Analysis Services Q914595 KB914595 January 17, 2015
• 914535 FIX: When you use an ActiveX Data Objects Recordset object to access a database in SQL Server 2005, the Recordset object returns no records Q914535 KB914535 January 17, 2015
• 914398 FIX: Error message when you try to export SQL Server 2005 reports to Excel: "Index out of range" Q914398 KB914398 January 17, 2015
• 914233 FIX: SQL Server 2005 Analysis Services may close unexpectedly when you create and then delete a subcube in the same session Q914233 KB914233 January 17, 2015
• 914019 FIX: Problems may occur when you use the SQLdiag utility in SQL Server 2005 Q914019 KB914019 January 17, 2015
• 913941 FIX: A SQL Server login may have more permissions when you log on to an instance of SQL Server 2005 Q913941 KB913941 January 17, 2015
• 913939 FIX: The return value of the Member_Unique_Name property in SQL Server 2005 Analysis Services differs from the return value in SQL Server 2000 Analysis Services Q913939 KB913939 January 17, 2015
• 913932 FIX: The SQL Server session may be blocked unexpectedly when you execute an ALTER VIEW statement on a view or when you execute an ALTER FUNCTION statement on a table-valued function Q913932 KB913932 January 17, 2015
• 913859 FIX: Multiple problems occur when you run a SQL Server 2005 Analysis Services MDX query that uses the DrillDownMember function Q913859 KB913859 January 17, 2015
• 913849 FIX: No result set is returned when you run an MDX query that uses an unnatural hierarchy in SQL Server 2005 Q913849 KB913849 January 17, 2015
• 913848 FIX: The results that are returned when you query a SQL Server 2005 Analysis Services cube may be incorrect for some members Q913848 KB913848 January 17, 2015
• 913771 FIX: You may receive an error message when you try to print a SQL Server 2005 Reporting Services report from a WebBrowser control Q913771 KB913771 January 17, 2015
• 913667 FIX: No value is returned for the user login when you try to use an HTTP connection and basic authentication to connect to the server that is running SQL Server 2005 Analysis Services Q913667 KB913667 January 17, 2015
• 913552 FIX: You cannot drill down a dimension from the (All) level in SQL Server 2005 Analysis Services build 1507 Q913552 KB913552 January 17, 2015
• 913494 FIX: The merge agent does not use a specified custom user update to handle conflicting UPDATE statements in SQL Server 2005 Q913494 KB913494 January 17, 2015
• 913371 FIX: You may receive error messages when you use the sp_cursoropen statement to open a cursor on a user-defined stored procedure in SQL Server 2005 Q913371 KB913371 January 17, 2015
• 913367 FIX: Seven connections are created and the connections are not reused when you connect to an instance of SQL Server 2005 Analysis Services Q913367 KB913367 January 17, 2015
• 913363 FIX: You receive an error message when you use SQL Server 2005 Reporting Services to run a report that has two or more parameters Q913363 KB913363 January 17, 2015
• 913061 FIX: Transferred data is not compressed when you connect to a SQL Server 2005 Analysis Services server by using HTTP Q913061 KB913061 January 17, 2015
• 912885 FIX: You may receive an access violation error message when you run a parallel execution plan in SQL Server 2005 Q912885 KB912885 January 17, 2015
• 912705 FIX: Error message when you try to drill through a report in SQL Server 2005 Reporting Services: "An internal error occurred on the report server. See the error log for more details" Q912705 KB912705 January 17, 2015
• 912702 FIX: Error message when you run an MDX query in SQL Server 2005 Analysis Services: "Dimension attribute was not found" Q912702 KB912702 January 17, 2015
• 912631 FIX: You cannot connect to SQL Server 2000 Analysis Services when you configure the Office Web Components data source connection string to use OLE DB Provider for Analysis Services 9.0 to connect to SQL Server 2005 Analysis Services Q912631 KB912631 January 17, 2015
• 912472 FIX: An incorrect result may appear in the subscribing database when you set database mirroring for a database and database failover occurs in SQL Server 2005 Q912472 KB912472 January 17, 2015
• 912471 FIX: The replication on the server does not work any longer when you manually fail over databases in SQL Server 2005 Q912471 KB912471 January 17, 2015
• 912459 FIX: Error message when you query data from a SQL Server 2005 Analysis Services database by using the HTTP protocol: "Xml Parsing failed" Q912459 KB912459 January 17, 2015
• 912450 FIX: You may receive a null value for a calculated member when you run an MDX query in SQL Server 2005 Analysis Services Q912450 KB912450 January 17, 2015
• 912446 FIX: You receive an incorrect result when you execute a DISCOVER request or call the AdomdConnection.GetSchemaDataSet method against a SQL Server 2005 Analysis Services server Q912446 KB912446 January 17, 2015
• 912429 FIX: Error message when you run an MDX statement to query data from a SQL Server 2005 Analysis Services database: "Internal error An unexpected exception occurred" Q912429 KB912429 January 17, 2015
• 912423 FIX: Memory leaks occur when you use Fuzzy Lookup and Fuzzy Grouping to transform a SQL Server 2005 Integration Services package Q912423 KB912423 January 17, 2015
• 912419 FIX: The attribute hierarchy for an attribute still appears when you browse a cube even if you set the value of the AttributeHierarchyVisible property for the attribute to False in SQL Server 2005 Analysis Services Q912419 KB912419 January 17, 2015
• 912383 FIX: You receive error messages in the output file when you try to rebuild a SQL Server 2005 Analysis Services project by using the Devenv command-line tool in Visual Studio 2005 Q912383 KB912383 January 17, 2015
• 912335 FIX: SQL Server 2005 Analysis Services may stop responding because a deadlock condition occurs Q912335 KB912335 January 17, 2015
• 912322 FIX: An application query that reads lots of data may be slow, and the SQL Server service may take a long time to start in SQL Server 2005 Q912322 KB912322 January 17, 2015
• 912151 FIX: The connection may time out before the first try to connect to the failover partner server when you try to connect to a SQL Server 2005 mirrored database by using an ADO.NET 2.0-based application Q912151 KB912151 January 17, 2015
• 912021 FIX: You may receive an error message when you try to use backup software to back up a database in SQL Server 2005 for Itanium-based Systems Q912021 KB912021 January 17, 2015
• 912016 FIX: Error message when you process a dimension by using the Process Update processing option or the Process Default processing option in SQL Server 2005 Analysis Services: "Operation has been cancelled" Q912016 KB912016 January 17, 2015
• 912001 FIX: Error message when you design aggregations in the Aggregation Design Wizard in SQL Server 2005 Analysis Services: "Internal error an unexpected exception occurred" Q912001 KB912001 January 17, 2015
• 911997 FIX: A parent/child dimension contains duplicate calculated members under all the top-level members after you upgrade SQL Server 2000 Analysis Services to SQL Server 2005 Analysis Services Q911997 KB911997 January 17, 2015
• 911937 FIX: The schema that indicates the Identity column in the source database is not transferred to the destination database when you try to transfer objects from a source database to a destination database by using SQL Management Objects in SQL Server 2005 Q911937 KB911937 January 17, 2015
• 911912 FIX: You experience low CPU spikes at set intervals even when there is no user activity in SQL Server 2005 Q911912 KB911912 January 17, 2015
• 911876 FIX: You may unexpectedly receive a series of messages when you use Object Explorer in Management Studio to restart SQL Server 2005 Q911876 KB911876 January 17, 2015
• 911695 FIX: You may receive an "Internal SQL Server error" error message when you run a query from Report Designer in SQL Server 2005 Analysis Services Q911695 KB911695 January 17, 2015
• 911678 FIX: User Transaction is Aborted When fn_trace_gettable Reads Corrupt Trace File Q911678 KB911678 January 17, 2015
• 911662 FIX: You may receive an access violation error message when you run a SELECT query in SQL Server 2005 Q911662 KB911662 January 17, 2015
• 910419 FIX: You receive an error message when you try to build a project for deployment and the project contains multiple packages that are configured to use a shared configuration file in SQL Server 2005 Integration Services Q910419 KB910419 January 17, 2015
• 910418 FIX: You may receive an error message when you try to connect to SQL Server 2005 Analysis Services by using an ADO connection string that uses the CustomData property Q910418 KB910418 January 17, 2015
• 910376 FIX: You may unexpectedly receive a zero or null return value when you run an MDX query on relational OLAP partitions in SQL Server 2005 Analysis Services Q910376 KB910376 January 17, 2015
• 909535 FIX: A query disappears in the MDX query designer, and you cannot modify a report in Layout view when you create the report in Business Intelligence Development Studio in SQL Server 2005 Q909535 KB909535 January 17, 2015
• 906532 FIX: Error message when you run the SQLDiag utility or the PSSDiag utility: "Exception creating Perfmon log" Q906532 KB906532 January 17, 2015
• 969997 FIX: You receive an incorrect result when you query data from a linked server that is created by using an index OLE DB provider in SQL Server 2005 or in SQL Server 2008 Q969997 KB969997 January 16, 2015
• 961920 FIX: A syntax error occurs when you try to use the lift chart to validate a mining model that uses an Oracle data source in SQL Server 2005 Analysis Services and in SQL Server 2008 Analysis Services Q961920 KB961920 January 16, 2015
• 961479 FIX: An unresolved deadlock occurs when you perform an online reindex operation that runs on parallel threads in SQL Server 2005 Q961479 KB961479 January 16, 2015
• 961146 FIX: You cannot connect to an instance of SQL Server 2005 Analysis Services or to an instance of SQL Server 2008 Analysis Services through HTTP when you configure Internet Explorer to use a .pac file Q961146 KB961146 January 16, 2015
• 961123 FIX: The SQL Server service stops when you run one of the DBCC CHECK commands on a SQL Server 2005 database or when you create a database snapshot for a SQL Server 2005 database Q961123 KB961123 January 16, 2015
• 961050 FIX: When you run a query that has a parallel execution plan in parallel under the READ COMMITTED isolation level on a database that is set the READ COMMITTED SNAPSHOT option in SQL Server 2005, the query that you may obtain may return uncommitted data Q961050 KB961050 January 16, 2015
• 960542 FIX: When you run the ALTER TRIGGER statement for a trigger in a merge publication in SQL Server 2005 or in SQL Server 2008, a change is not replicated to the subscriber database Q960542 KB960542 January 16, 2015
• 959031 FIX: Error message when you try to expand the Catalogs node for a linked server that links to a Teradata Database in SQL Server 2005: "Cannot obtain the schema rowset DBSCHEMA_CATALOGS for OLE DB provider SQL Server for linked server (null)" Q959031 KB959031 January 16, 2015
• 959001 FIX: The Log Reader Agent skips some transactions when the Log Reader Agent runs to replicate transactions for a transactional replication in SQL Server 2005 and in SQL Server 2008 Q959001 KB959001 January 16, 2015
• 958573 FIX: A memory leak occurs when you repeatedly invoke a trigger that contains the RAISERROR statement by using a SQLCLR stored procedure in SQL Server 2005 Q958573 KB958573 January 16, 2015
• 958554 FIX: Error message when you restore a transaction log for a database by using the STANDBY option in SQL Server 2005: "The transaction log for database '<DatabaseName>' is full" Q958554 KB958554 January 16, 2015
• 958549 FIX: You may be unable to cancel an MDX query that uses the NonEmpty function on a large set in SQL Server 2005 Analysis Services Q958549 KB958549 January 16, 2015
• 958547 FIX: The values of the datetime column are not same for the rows that are copied when you copy data to a table by using the GETDATE() function in Microsoft SQL Server 2005 Q958547 KB958547 January 16, 2015
• 958500 FIX: MDX queries that use the EXCEPT function in the WHERE clause run much slower after you install a hotfix or a cumulative update whose version is later than the version of Cumulative Update 4 for SQL Server 2005 SP2 Q958500 KB958500 January 16, 2015
• 956377 FIX: Error message when you try to synchronize a database again in SQL Server 2005 Analysis Services: "Processing for the database will be disabled because an error occurred while loading the '<DatabaseName>' database cryptography key" Q956377 KB956377 January 16, 2015
• 956376 FIX: The SQL Server 2005 Distribution Agent and the SQL Server 2008 Distribution Agent do not skip error 20598 when you configure a SQL Server 2000 transactional publication to skip error 20598 Q956376 KB956376 January 16, 2015
• 955694 FIX: When you update rows by using a cursor in SQL Server 2005, the update may take a long time to finish Q955694 KB955694 January 16, 2015
• 955693 FIX: In SQL Server 2005, the file information about the transaction log that was last copied and the file information about the transaction log that was last restored are missing Q955693 KB955693 January 16, 2015
• 953991 FIX: The size of a database keeps increasing when you perform many DELETE operations and many INSERT operations on the database in SQL Server 2005 Q953991 KB953991 January 16, 2015
• 953850 FIX: When you define an alert activity on a fractional performance counter of an instance of Microsoft SQL Server 2005 in System Monitor, the alert does not work Q953850 KB953850 January 16, 2015
• 945641 FIX: A calculation script that calculates the same cells several times may return an incorrect result in SQL Server 2005 Analysis Services Service Pack 2 Q945641 KB945641 January 16, 2015
• 943388 FIX: The witness server crashes and a minidump file is generated in the SQL Server 2005 log folder when you manually failover database mirroring in SQL Server 2005 build 2239 Q943388 KB943388 January 16, 2015
• 942711 FIX: You receive a time-out error message when you try to send a message to the target service of a Service Broker application that you create in SQL Server 2005 Q942711 KB942711 January 16, 2015
• 942666 FIX: The process stops responding when you run an SSIS package that contains a Flat File destination in x64 versions of Microsoft SQL Server 2005 Q942666 KB942666 January 16, 2015
• 942530 FIX: Error message when you display a parameterized report in a Report Viewer Web part in SQL Server 2005 Reporting Services: "Object reference not set to an instance of an object" Q942530 KB942530 January 16, 2015
• 942444 FIX: A query that involves an outer join operation runs very slowly in Microsoft SQL Server 2005 Q942444 KB942444 January 16, 2015
• 942121 FIX: Event ID 22 is logged in the Application log when you process an object in a database in SQL Server 2005 Analysis Services Q942121 KB942121 January 16, 2015
• 941178 FIX: SQL Server Agent replaces the A_DBN token with "master" in a job that responds to a database alert in SQL Server 2005 Q941178 KB941178 January 16, 2015
• 940996 FIX: Error message when you run a Multidimensional Expressions (MDX) query in SQL Server 2005 Analysis Services: "Internal error An unexpected exception occured" Q940996 KB940996 January 16, 2015
• 940962 FIX: Error message when you process a database in SQL Server 2005 Analysis Services: "Failed generate and process of Olap object(s): Internal error: The operation terminated unsuccessfully" Q940962 KB940962 January 16, 2015
• 940949 FIX: You receive an error message when you run an UPDATE CUBE statement to update a cube in SQL Server 2005 Analysis Services Q940949 KB940949 January 16, 2015
• 940948 FIX: Error message when you use Database Engine Tuning Advisor to tune a database in SQL Server 2005 Service Pack 2: "An unhandled win32 exception occurred in dtaengine90.exe [4308]" Q940948 KB940948 January 16, 2015
• 940945 FIX: Performance is very slow when the same stored procedure is executed at the same time in many connections on a multiple-processor computer that is running SQL Server 2005 Q940945 KB940945 January 16, 2015
• 940939 FIX: When you roll back a transaction that contains a writeback operation, SQL Server does not roll back the writeback operation in SQL Server 2005 Analysis Services Q940939 KB940939 January 16, 2015
• 940386 FIX: You cannot install the SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies on a computer that is running a beta version of Windows Server 2008 Q940386 KB940386 January 16, 2015
• 940385 FIX: A SQL Server 2005 Reporting Services report that uses the Right-to-Left (RTL) layout displays incorrectly in Internet Explorer 7 Q940385 KB940385 January 16, 2015
• 940382 FIX: The calendar control in a SQL Server 2005 Reporting Services report may display incorrect values Q940382 KB940382 January 16, 2015
• 940377 FIX: Error message when you process cubes for one of the named instances of SQL Server 2005 Analysis Services: "Error opening file" Q940377 KB940377 January 16, 2015
• 940373 FIX: The performance of an MDX query in SQL Server 2005 Analysis Services Service Pack 2 is much slower than the performance of the same query in earlier builds of SQL Server 2005 Analysis Services Q940373 KB940373 January 16, 2015
• 940221 FIX: Error message when you try to create an Oracle publication by using the New Publication Wizard in SQL Server 2005 Service Pack 2: "OLE DB Provider 'OraOLEDB.ORACLE' for Linked server <LinkedServerName> returned message" Q940221 KB940221 January 16, 2015
• 940210 FIX: Error message when you try to insert more than 3 megabytes of data into a distributed partitioned view in SQL Server 2005: "A system assertion check has failed" Q940210 KB940210 January 16, 2015
• 939942 FIX: You receive an error message when you try to access a report after you configure SQL Server 2005 Reporting Services to run under the SharePoint integrated mode Q939942 KB939942 January 16, 2015
• 939564 FIX: You receive an incorrect result when you use a SQL Native Client provider to read the data on the client computer in SQL Server 2005 Q939564 KB939564 January 16, 2015
• 938915 FIX: You cannot select the child parameters even after you select the parent parameter when you use the Report Viewer Web part on a SharePoint site to view a SQL Server 2005 Reporting Services report Q938915 KB938915 January 16, 2015
• 938750 FIX: Error message when you connect to an instance of SQL Server 2005 Analysis Services after you cancel an MDX query that has been running for a long time: "A connection attempt failed because the connected party did not properly respond" Q938750 KB938750 January 16, 2015
• 938712 FIX: Some records in the fact table may not be processed when you process a dimension that contains many attributes or many members in SQL Server 2005 Q938712 KB938712 January 16, 2015
• 938675 FIX: The update may take a longer time to complete in SQL Server 2005 than in SQL Server 2000 when you update subscribers of a transactional publication that has immediate updating subscriptions enabled Q938675 KB938675 January 16, 2015
• 937521 FIX: An access violation may occur when you run a query that uses a hash join hint in the x64 version of SQL Server 2005 Service Pack 2 Q937521 KB937521 January 16, 2015
• 936489 FIX: A SQL Server assertion is logged in the Errorlog file when the Log Reader Agent runs for a transactional publication in SQL Server 2005 Q936489 KB936489 January 16, 2015
• 936261 FIX: The process stops responding and the CPU utilization reaches 100 percent when you process a partition in SQL Server 2005 Analysis Services Q936261 KB936261 January 16, 2015
• 935832 FIX: You cannot cancel an MDX query that runs for a long time in SQL Server 2005 Analysis Services Q935832 KB935832 January 16, 2015
• 934706 FIX: Error message when you perform a piecemeal restore operation after you enable vardecimal database compression in SQL Server 2005 Service Pack 2: "Piecemeal restore is not supported when an upgrade is involved" Q934706 KB934706 January 16, 2015
• 933831 FIX: A schema change that is made to a published table may not be propagated to subscriptions in SQL Server 2005 Q933831 KB933831 January 16, 2015
• 933808 FIX: Error message when you run a query that contains nested FOR XML clauses in SQL Server 2005: “The XML data type is damaged” Q933808 KB933808 January 16, 2015
• 933549 FIX: You may receive an access violation when you perform a bulk copy operation in SQL Server 2005 Q933549 KB933549 January 16, 2015
• 933463 FIX: Managed applications that use SQL Server 2005 Mobile Edition may stop unexpectedly if the location of the SQL Mobile DLLs changes Q933463 KB933463 January 16, 2015
• 932593 FIX: You receive an error message when you try to install the original release version of SQL Server 2005 or SQL Server 2005 Service Pack 1 on a computer that is running Windows Vista Q932593 KB932593 January 16, 2015
• 930691 FIX: SQL Server Profiler stops monitoring the instance after a time when you use SQL Server Profiler to monitor an instance of SQL Server 2005 Analysis Services Q930691 KB930691 January 16, 2015
• 930284 FIX: You receive error 1456 when you try to add a witness to a DBM session in SQL Server 2005 Q930284 KB930284 January 16, 2015
• 929404 FIX: Error message when you perform a transaction log backup operation and another data backup operation in parallel in SQL Server 2005: "Error 3633" Q929404 KB929404 January 16, 2015
• 929375 FIX: The SQL Native Client OLE DB provider (SQLNCLI) leaks memory when you call the IRowsetFastLoad::Commit method in a SQL Server 2005-based application Q929375 KB929375 January 16, 2015
• 928537 FIX: The full-text index population for the indexed view is very slow in SQL Server 2005 Q928537 KB928537 January 16, 2015
• 927455 FIX: The query runs much slower than you expect when you use the InStr function in a calculated member of an MDX query in SQL Server 2005 Analysis Services Q927455 KB927455 January 16, 2015
• 927179 FIX: Processing is never completed and cannot be stopped when you process a cube in SQL Server 2005 Analysis Services Q927179 KB927179 January 16, 2015
• 927109 FIX: Many query notifications are sent to the data warehouse when proactive caching is enabled in SQL Server 2005 Analysis Services Q927109 KB927109 January 16, 2015
• 926775 FIX: The sum total of a column contains incorrect data when you browse or query a cube in SQL Server 2005 Analysis Services Q926775 KB926775 January 16, 2015
• 926774 FIX: You may receive incorrect results when you try to aggregate a non-additive measure on the parent-child dimension in SQL Server 2005 Analysis Services Q926774 KB926774 January 16, 2015
• 926235 FIX: In SQL Server 2005 Analysis Services, the query may not return all the expected rows when you use the TopCount function in an MDX query Q926235 KB926235 January 16, 2015
• 925754 FIX: You may experience stack corruption and SQL Server 2005 Analysis Services may stop responding when you run SQL Server 2005 Analysis Services on a Dual-Core Intel Itanium 2 Processor 9000 Series-based computer Q925754 KB925754 January 16, 2015
• 925335 FIX: Error message when you use a label after a Transact-SQL query in SQL Server 2005: "Incorrect syntax near 'X'" Q925335 KB925335 January 16, 2015
• 971970 FIX: You cannot insert rows or upload changes into the SQL Server 2005 Compact Edition subscriber tables after you run the "sp_changemergearticle" stored procedure or you add a new merge publication article when another article has an IDENTIT... Q971970 KB971970 January 15, 2015
• 967963 FIX: Some rows are deleted when you repair a database by using the Repair method together with the RepairOption.RecoverCorruptedRows option in SQL Server 2005 Compact Edition and in SQL Server Compact 3.5 Q967963 KB967963 January 15, 2015
• 967348 FIX: Error message when you run a series of the CREATE SESSION CUBE statement and the DROP SESSION CUBE statement in SQL Server 2005 Analysis Services: "An unexpected exception occurred" Q967348 KB967348 January 15, 2015
• 967199 FIX: The Wmiprvse.exe host process stops responding when you run a SQL Server 2005-based application that sends a Windows Management Instrumentation (WMI) query to the SQL Server WMI provider Q967199 KB967199 January 15, 2015
• 967192 FIX: Error message when you open Replication Monitor for a transactional publication in SQL Server 2005: "Initial snapshot for publication <PublicationName> is not available" Q967192 KB967192 January 15, 2015
• 965217 FIX: An incorrect backup set is listed when you restore a database from a backup file by using SQL Server Management Studio in SQL Server 2005 or in SQL Server 2008 Q965217 KB965217 January 15, 2015
• 953676 FIX: You may receive the incorrect result when you query a calculated member that uses the Aggregate function or the Sum function and that uses another calculated member in SQL Server 2005 Analysis Services Q953676 KB953676 January 15, 2015
• 953624 FIX: Error message when you synchronize data for a merge replication in SQL Server 2005: "The Merge Agent failed after detecting that retention - based metadata cleanup has deleted metadata at the Subscriber" Q953624 KB953624 January 15, 2015
• 953569 FIX: The compilation time of some queries is very long in an x64-based version of SQL Server 2005 Q953569 KB953569 January 15, 2015
• 953553 FIX: An access violation occurs when you run an XMLA query in SQL Server 2005 Analysis Services Q953553 KB953553 January 15, 2015
• 953547 FIX: A time series prediction query takes a long time to run in SQL Server 2005 Analysis Services Q953547 KB953547 January 15, 2015
• 953496 FIX: CPU utilization is high when you run a trace that contains a text filter in SQL Server 2005 Q953496 KB953496 January 15, 2015
• 951186 FIX: In SQL Server 2005 Reporting Services with Service Pack 2, the maximum session limit may be reached on the server of the data source when the data source uses the .NET Data Provider for SAP NetWeaver Business Intelligence Q951186 KB951186 January 15, 2015
• 951184 FIX: A query may run much slower in SQL Server 2005 than in SQL Server 2000 when you use a cursor to run the query Q951184 KB951184 January 15, 2015
• 950880 FIX: The query runs slowly when you run a query that joins data between a local table and a remote table in SQL Server 2005 Q950880 KB950880 January 15, 2015
• 950520 FIX: Error message when you use the SQL Server 2005 JDBC driver to run XA transactions together with the MS DTC: "javax.transaction.xa.XAException: java.sql.SQLException" Q950520 KB950520 January 15, 2015
• 949200 FIX: SQL Server 2005 requests columns that you do not expect when you run a SELECT statement Q949200 KB949200 January 15, 2015
• 949097 FIX: Error message when you insert a new row into a view in SQL Server 2005: "Cannot insert explicit value for identity column in table <TableName> when IDENTITY_INSERT is set to OFF" Q949097 KB949097 January 15, 2015
• 948658 FIX: Some rows are not returned when you run a complex query that uses the DISTINCT keyword in Microsoft SQL Server 2005 Q948658 KB948658 January 15, 2015
• 948578 FIX: Some changes are not synchronized between subscribers of a merge publication in SQL Server 2005 Q948578 KB948578 January 15, 2015
• 948525 FIX: Error message when you run a query against a table that does not have a clustered index in SQL Server 2005: "A severe error occurred on the current command" Q948525 KB948525 January 15, 2015
• 948456 FIX: The data in a text box is truncated when you input more than 32000 characters in the text box in a SQL Server 2005 Reporting Services report Q948456 KB948456 January 15, 2015
• 948450 FIX: CPU utilization of a CPU in a single node increases to 100 percent when you use SQL Server 2005 on a multiprocessor computer that uses NUMA architecture Q948450 KB948450 January 15, 2015
• 948344 FIX: Performance data is not updated when you run a tool that uses SQL Server performance counters to collect performance data for an instance of SQL Server 2005 Q948344 KB948344 January 15, 2015
• 947197 FIX: Error message when the workload demand on the server is high in SQL Server 2005 Analysis Services: "Internal error: An unexpected exception occured" Q947197 KB947197 January 15, 2015
• 947196 FIX: An access violation occurs when you run an MDX query by using a user account that is a member of some different roles in SQL Server 2005 Analysis Services Q947196 KB947196 January 15, 2015
• 927859 FIX: You may experience decreased performance when you run a query that contains the CREATE SET statement against a ragged dimension in SQL Server 2005 Analysis Services Q927859 KB927859 January 15, 2015
• 925566 FIX: Error message when you run a query against a cube that contains linked objects in SQL Server 2005 Analysis Services: "Internal error An unexpected error occurred" Q925566 KB925566 January 15, 2015
• 924811 FIX: You cannot use SQL Server 2005 Mobile Edition on Windows CE .NET 4.2-based devices Q924811 KB924811 January 15, 2015
• 923979 FIX: Error message when you try to insert a row or perform other database operations in a SQL Server 2005 Mobile Edition database: "Wrong page (potential database corruption)" Q923979 KB923979 January 15, 2015
• 920882 FIX: You cannot deploy a SQL Server 2005 Integration Services package if you use an XML configuration file whose file name contains an uppercase letter Q920882 KB920882 January 15, 2015
• 919000 FIX: The empty tables in a database do not keep the values in the identity column when you compact the SQL Server 2005 Mobile Edition database Q919000 KB919000 January 15, 2015
• 917886 FIX: Error message after you roll back transactions on a table in SQL Server 2005: "Error: 3315, Severity: 21, State: 1" Q917886 KB917886 January 15, 2015
• 913401 FIX: If you try to perform a site deployment export operation to SQL Server 2005, the export operation fails in Content Management Server 2002 Service Pack 2 Q913401 KB913401 January 15, 2015
• 2572407 FIX: Error 5180 when you use the ONLINE option to rebuild an index in SQL Server 2005 Q2572407 KB2572407 June 21, 2014
• 937033 FIX: Error message when you run a linked server query in SQL Server 2005: "The oledbprovider unisys.dmsII.1 for linkserver '<ServerName>' reported an error the provider ran out of memory" Q937033 KB937033 June 21, 2014
• 936081 FIX: Error message when you connect to an instance of SQL Server 2008 Analysis Services by using the AMO library that is included with SQL Server 2005 Service Pack 2 Analysis Services: "Cannot connect to Analysis Services version '10.0.1600.22'" Q936081 KB936081 June 21, 2014
• 934459 FIX: The Check Database Integrity task and the Execute T-SQL Statement task in a maintenance plan may lose database context in certain circumstances in SQL Server 2005 builds 3150 through 3158 Q934459 KB934459 June 21, 2014
• 917888 FIX: Error message when you use a server-side cursor to run a large complex query in SQL Server 2005: "Error: 8623, Severity: 16, State: 1 The query processor ran out of internal resources" Q917888 KB917888 June 20, 2014
• 2605597 FIX: Time-out error when a mirrored database connection is created by the .NET Framework data provider for SQLClient Q2605597 KB2605597 May 15, 2014
• 2555235 FIX: Time-out error when a mirrored database connection is created by the .NET Framework data provider for SQLClient Q2555235 KB2555235 May 15, 2014
• 818769 FIX: Trace Flag -T8002 Treats an Affinity Mask Like a Process Affinity Q818769 KB818769 February 27, 2014
• 938823 FIX: Dates in the Datetimepicker control appear in the incorrect format when you view a report of SQL Server 2005 Reporting Services with SP2 on a server that is set to a German locale Q938823 KB938823 November 2, 2013
• 935399 FIX: A table in a report that is delivered by SQL Server 2005 Reporting Services with Service Pack 2 appears to be compressed when the report is opened in Outlook 2007 Q935399 KB935399 November 2, 2013
• 935436 FIX: The background color of a report may be black when the report is hosted by a report server in SQL Server 2005 Reporting Services Q935436 KB935436 October 25, 2013
• 959032 FIX: When you run the "dbcc dbreindex" command or the "alter index" command, some transactions are not replicated to the subscribers in a transactional replication in SQL Server 2005 or in SQL Server 2008 Q959032 KB959032 April 23, 2013
• 972936 FIX: "SqlDumpExceptionHandler: Process <spid> generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION." error when you run a query in SQL Server 2012, in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2005 Q972936 KB972936 February 18, 2013
• 938672 FIX: When you populate a full-text index on a table that has a composite clustered index in SQL Server 2005, the population operation may be very slow Q938672 KB938672 May 24, 2012
• 2661225 FIX: Unable to connect to a data source when you use SQL Server Analysis Services 10.0 OLE DB Provider if you enable the "Automatically detect settings" option in the Connections tab of Internet Explorer Q2661225 KB2661225 April 12, 2012
• 2137539 FULL or BULK recovery models can provide better data protection and recovery Q2137539 KB2137539 April 2, 2012
• 935922 FIX: Error message when you install Microsoft Dynamics CRM:"Setup failed to validate specified Reporting Services Report Server" or "Setup requires SQL Server Reporting Services 2005 Hotfix for role creation on SQL Reporting Service SP2 ... Q935922 KB935922 January 20, 2012
• 2615425 FIX: "Msg 7359" error when a view uses another view in SQL Server 2005 if the schema version of a remote table is updated Q2615425 KB2615425 October 24, 2011
• 977007 FIX: MDX queries in a calculation script fail with an internal exception and cause SQL Server 2005 Analysis Services to crash when they are used to generate complex calculations that has some function calls to an external DLL assembly Q977007 KB977007 October 9, 2011
• 972937 FIX: A performance issue in which SQL Server Management Studio checks the fragmentation data of an index in a large database Q972937 KB972937 October 9, 2011
• 945996 FIX: The full-text search engine stops responding intermittently, the CPU utilization is high, and all full-text queries are blocked when you use full-text search in SQL Server 2005 Q945996 KB945996 October 9, 2011
• 945893 FIX: Error message when you run a parent package that contains some child packages in SQL Server 2005 Integration Services: "Error: 0xC001000E" Q945893 KB945893 October 9, 2011
• 923605 FIX: A deadlock occurs and a query never finishes when you run the query on a computer that is running SQL Server 2005 and has multiple processors Q923605 KB923605 October 9, 2011
• 922638 FIX: An EXCEPTION_STACK_OVERFLOW exception may occur when you try to run a Transact-SQL query in SQL Server 2005 Q922638 KB922638 October 9, 2011
• 922545 FIX: JavaScript error message when you click a hyperlink in a SQL Server 2005 Reporting Services report: "Can’t execute code from a freed script" Q922545 KB922545 October 9, 2011
• 920205 FIX: A memory leak may occur when you run SQL Server 2005 Integration Services packages that are stored in the SSIS Package store Q920205 KB920205 October 9, 2011
• 919929 FIX: Error message when the Replication Merge Agent runs in SQL Server 2005: "Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199402" Q919929 KB919929 October 9, 2011
• 919611 FIX: The value of the automatic growth increment of a database file may be very large in SQL Server 2005 with Service Pack 1 Q919611 KB919611 October 9, 2011
• 919478 FIX: "Select All" may not be available when you try to preview a report in Report Designer after you install SQL Server 2005 Service Pack 1 Q919478 KB919478 October 9, 2011
• 918757 FIX: The value of a cell is not updated correctly when you use multiple UPDATE CUBE statements inside a single transaction in SQL Server 2005 Analysis Services Q918757 KB918757 October 9, 2011
• 918091 FIX: You may receive an error message when you try to run an SSIS package in SQL Server 2005 Q918091 KB918091 October 9, 2011
• 917887 FIX: The value of the automatic growth increment of a database file may be very large in SQL Server 2005 Q917887 KB917887 October 9, 2011
• 917271 FIX: Error message when you run a SQL Server 2005 application that contains user-defined data types: "AppDomain 3 (<db_name>.dbo[runtime].2) is marked for unload due to memory pressure" Q917271 KB917271 October 9, 2011
• 916497 FIX: You cannot use SQL Server Management Studio to view job steps that have the SSIS data type on an installation of SQL Server 2005 that uses Turkish collation, and you may receive an "Index was outside the bounds of the array" error message Q916497 KB916497 October 9, 2011
• 914375 FIX: You may receive an error message when you run a package that calls other child packages in SQL Server 2005 Integration Services Q914375 KB914375 October 9, 2011
• 912422 FIX: The synchronous database mirroring session status may remain disconnected when you set up synchronous database mirroring but do not configure a witness database and you run a DBCC STACKDUMP command in SQL Server 2005 Q912422 KB912422 October 9, 2011
• 910414 FIX: You may receive an error message when you try to load data by using CLR functions in a Transact-SQL job in SQL Server 2005 Q910414 KB910414 October 9, 2011
• 960611 FIX: An incorrect result is returned when you run a Multidimensional Expressions (MDX) query in Microsoft SQL Server 2005 Analysis Services Q960611 KB960611 October 8, 2011
• 959595 FIX: Error message when you view a SQL Server Reporting Services report in the ReportViewer control in Visual Studio 2008: "Object reference not set to an instance of an object" Q959595 KB959595 October 8, 2011
• 959132 FIX: Error message when you install Cumulative Update 10, Cumulative Update 9, or security update 954606 (security bulletin MS08-052) for SQL Server 2005 Service Pack 2 on a drive that uses the FAT32 file system: "Unexpected Error Occurred" Q959132 KB959132 October 8, 2011
• 956382 FIX: Error message when you view a report in SQL Server 2005 Report Manager: "Microsoft.ReportingServices.Diagnostics.Utilities.RPCException: The report server has encountered a configuration error" Q956382 KB956382 October 8, 2011
• 956381 FIX: Error message when you render a report in SQL Server 2005 SharePoint integrated mode: "An unexpected error occurred while connecting to the report Server. Verify that the Report Server is available and configured for Sharepoint Integration m... Q956381 KB956381 October 8, 2011
• 956378 FIX: You may be unable to start the SQL Server agent if you configure a SQL Server 2005 failover cluster to use Kerberos constrained delegation for a domain user account Q956378 KB956378 October 8, 2011
• 950117 FIX: The value in the <ZIndex> tag for an item in the .rdl file is changed after you make a small change in a SQL Server 2005 Reporting Services report Q950117 KB950117 October 8, 2011
• 947463 FIX: A stored procedure cannot finish its execution in SQL Server 2005 Q947463 KB947463 October 8, 2011
• 947179 FIX: An MDX query that uses the VisualTotals function returns an incorrect empty value in SQL Server 2005 Analysis Services Q947179 KB947179 October 8, 2011
• 945443 FIX: A query takes longer to finish in SQL Server 2005 than in SQL Server 2000 when you open a fast forward-only cursor for the query Q945443 KB945443 October 8, 2011
• 945442 FIX: You cannot cancel the query execution immediately if you open a fast forward-only cursor for the query in SQL Server 2005 Q945442 KB945442 October 8, 2011
• 944985 FIX: The data on the publisher does not match the data on the subscriber when you synchronize a SQL Server 2005 Mobile Edition subscriber with a SQL Server 2000 "merge replication" publisher Q944985 KB944985 October 8, 2011
• 944968 FIX: A minidump file is generated, and an error message is logged in the SQL Server error log when you run the DBCC MEMORYSTATUS statement in SQL Server 2005 Q944968 KB944968 October 8, 2011
• 944902 FIX: A federated database server stops responding when you run parallel queries on a multiprocessor computer that uses NUMA architecture in SQL Server 2005 Q944902 KB944902 October 8, 2011
• 944677 FIX: Conflicts are not logged when you use the Microsoft SQL Server Subscriber Always Wins Conflict Resolver for an article in a merge replication in Microsoft SQL Server 2005 Q944677 KB944677 October 8, 2011
• 943526 FIX: SQL Server 2005 Analysis Services stops responding when you run an MDX query that references a measure of the double data type or a calculated member of the double data type Q943526 KB943526 October 8, 2011
• 943389 FIX: You must restart the SQL Server service on the principal server after you resume the SQL Server service process from a debug tool in SQL Server 2005 Q943389 KB943389 October 8, 2011
• 941720 FIX: Error message on a Windows Vista-based computer when you try to query data from a column of the XML data type or from a variable of the XML data type in a SQL Server 2005: "Unexpected end of file has occurred" Q941720 KB941720 October 8, 2011
• 940961 FIX: Transactions that are being committed on the principal server may not be copied to the mirror server when a database mirroring failover occurs in SQL Server 2005 Q940961 KB940961 October 8, 2011
• 940719 FIX: A memory leak occurs when you call the Initialize method and the Terminate method of the SQLDistribution object in a loop in an application that you develop by using Microsoft ActiveX replication controls in SQL Server 2005 Q940719 KB940719 October 8, 2011
• 940390 FIX: You cannot roll back changes in a transaction after you call the ITransactionLocal::Abort method by setting the fRetaining flag to TRUE in a SQL Server 2005-based application that uses the SQL Native Client OLE DB provider Q940390 KB940390 October 8, 2011
• 940384 FIX: You receive a System.InvalidCastException exception when you run an application that calls the Server.JobServer.Jobs.Contains method on a computer that has SQL Server 2005 Service Pack 2 installed Q940384 KB940384 October 8, 2011
• 940287 FIX: Error message when you use Service Broker in SQL Server 2005: "An error occurred while receiving data: '64(The specified network name is no longer available.)'" Q940287 KB940287 October 8, 2011
• 940286 FIX: A Service Broker endpoint stops passing messages in a database mirroring session of SQL Server 2005 Q940286 KB940286 October 8, 2011
• 940269 FIX: Error message when you try to edit a SQL Server Agent job or a maintenance plan by using SQL Server Management Studio in SQL Server 2005: "String or binary data would be truncated" Q940269 KB940269 October 8, 2011
• 940129 FIX: An MDX query does not return results when you execute the query against a cube that contains an unnatural hierarchy in a dimension in SQL Server 2005 Analysis Services Q940129 KB940129 October 8, 2011
• 940128 FIX: When you run a complex query in SQL Server 2005, the query performance is slow if the execution plan of the query contains semi join operators Q940128 KB940128 October 8, 2011
• 939768 FIX: An object data source may not appear in the Website Data Sources window when you try to set the object data source for a SQL Server 2005 Reporting Services report in Visual Studio 2005 Q939768 KB939768 October 8, 2011
• 939563 FIX: Error message when you synchronize a merge replication in Microsoft SQL Server 2005: "MSmerge_del_<GUID>, Line 42 String or binary data would be truncated" Q939563 KB939563 October 8, 2011
• 939562 FIX: Error message when you run a query that fires an INSTEAD OF trigger in SQL Server 2005 Service Pack 2: "Internal Query Processor Error The query processor could not produce a query plan" Q939562 KB939562 October 8, 2011
• 938962 FIX: You may receive an access violation or error 942 when you drop a database in SQL Server 2005 Q938962 KB938962 October 8, 2011
• 938913 FIX: Error message when you run a maintenance plan that contains a Back Up Database task in Microsoft SQL Server 2005 Service Pack 2: "0x80004003: Object reference not set to an instance of an object" Q938913 KB938913 October 8, 2011
• 938912 FIX: In a maintenance plan, the databases that you selected are no longer selected when you edit a Back Up Database task in SQL Server 2005 Service Pack 2 Q938912 KB938912 October 8, 2011
• 938911 FIX: Event ID: 21421 occurs when you use the Microsoft Operations Manager 2005 agent to monitor a clustered instance of SQL Server 2005 in a clustered environment Q938911 KB938911 October 8, 2011
• 938697 FIX: Error message when you run a query that references a temporary table in SQL Server 2005: "Internal error. Buffer provided to read column value is too small. Run DBCC CHECKDB to check for any corruption" Q938697 KB938697 October 8, 2011
• 938682 FIX: You receive an access violation when you process an object or alter an object after you run an MDX query against the object in Microsoft SQL Server 2005 Analysis Services Q938682 KB938682 October 8, 2011
• 938585 FIX: Additional data columns for ascendant members are returned unexpectedly when you run an MDX statement against an instance of SQL Server 2005 Analysis Services that has SQL Server 2005 Service Pack 2 installed Q938585 KB938585 October 8, 2011
• 938243 FIX: Error message when you run a full-text query against a catalog in SQL Server 2005: “The execution of a full-text query failed. The content index is corrupt.” Q938243 KB938243 October 8, 2011
• 938086 FIX: A SQL Server Agent job fails when you run the SQL Server Agent job in the context of a proxy account in SQL Server 2005 Q938086 KB938086 October 8, 2011
• 938068 FIX: Hebrew characters are incorrectly converted when you synchronize a replication subscription in SQL Server 2005 Q938068 KB938068 October 8, 2011
• 937969 FIX: Error message when you import data from a flat file in a SQL Server 2005 Integration Services (SSIS) package: "There is a partial row at the end of the file" Q937969 KB937969 October 8, 2011
• 937829 FIX: Error message when you run an MDX query against a database in SQL Server 2005 Service Pack 2: “An unexpected exception occured” Q937829 KB937829 October 8, 2011
• 937533 FIX: Error message when you run a query in SQL Server 2005: "Cannot insert duplicate key row in object <TableName> with unique index <IndexName>" Q937533 KB937533 October 8, 2011
• 937090 FIX: The Report Designer or the Report Manager stops responding when you try to export a SQL Server 2005 Reporting Services report to a PDF file or a TIFF file Q937090 KB937090 October 8, 2011
• 936978 FIX: An access violation occurs when you run the SqlCeEngine.Verify method to check for the consistency of a database in SQL Server 2005 Compact Edition or in SQL Server 2005 Mobile Edition Q936978 KB936978 October 8, 2011
• 936968 FIX: You may receive incorrect results when you run a Multidimensional Expressions (MDX) query and the WHERE clause and the SELECT clause in the query contain different attributes of the same dimension in SQL Server 2005 Analysis Services Q936968 KB936968 October 8, 2011
• 936863 FIX: Some MDX queries may run slower and consume more memory after you install SQL Server 2005 Analysis Services Service Pack 2 Q936863 KB936863 October 8, 2011
• 936728 FIX: Error message when you run a SQL Server 2005 Integration Services (SSIS) package that contains a Fuzzy Lookup transformation: "System.Data.SqlClient.SqlException Error number 8101 is invalid" Q936728 KB936728 October 8, 2011
• 936697 FIX: The getTime method returns an incorrect date in the SQL Server 2005 JDBC Driver 1.1 Q936697 KB936697 October 8, 2011
• 936595 FIX: The estimate of the number of children that a dimension member has may be inaccurate when you request the CHILDREN_CARDINALITY property for a dimension member in SQL Server 2005 Analysis Services Q936595 KB936595 October 8, 2011
• 936534 FIX: Error message when the Distribution Agent tries to apply the snapshot to the subscriber in SQL Server 2005: "Must declare the scalar variable "@Variable"" Q936534 KB936534 October 8, 2011
• 936254 FIX: An MDX query may be slow if it reads from an aggregation that has less than 4,096 records in SQL Server 2005 Analysis Services Q936254 KB936254 October 8, 2011
• 936223 FIX: Error messages when you run a query against a linked server that you create in SQL Server 2005: "Statement(s) could not be prepared" and "The column prefix '<column_prefix_name>' does not match with a table name or alias name ... Q936223 KB936223 October 8, 2011
• 935830 FIX: A server may start slowly if you have SQL Server 2005 Analysis Services installed and if many objects are stored on the server Q935830 KB935830 October 8, 2011
• 935829 FIX: You receive incorrect results when you run an MDX query against a dimension that contains a parent-child hierarchy in SQL Server 2005 Analysis Services Q935829 KB935829 October 8, 2011
• 935769 FIX: Error message when you upgrade a database from SQL Server 2000 Windows CE Edition 2.0 to SQL Server 2005 Mobile Edition: "The database file is larger than the configured maximum database size" Q935769 KB935769 October 8, 2011
• 935360 FIX: Error message when you run an MDX query that retrieves data from an Analysis Services database: "An error occurred while the dimension, with the ID of '<DatabaseName>', Name of '<DimensionName>' was being processed" Q935360 KB935360 October 8, 2011
• 935341 FIX: Error message when you run an MDX query against a measure in SQL Server 2005 Analysis Services: "An internal error has occurred" Q935341 KB935341 October 8, 2011
• 934734 FIX: A database is marked as suspect when you update a table that contains a nonclustered index in SQL Server 2005 Q934734 KB934734 October 8, 2011
• 934713 FIX: Error message when you run the CHECKPOINT statement after you restore a database that has a read-only user-defined filegroup in SQL Server 2005: "The operating system returned error 5(Access is denied.) to SQL Server" Q934713 KB934713 October 8, 2011
• 934396 FIX: Error messages and an event may be logged when you use the Virtual Device Interface in SQL Server 2005 or in SQL Server 2000 Q934396 KB934396 October 8, 2011
• 934386 FIX: You cannot use SQL Server 2005 Compact Edition on an ARMV4i-based device that is running Windows CE .NET 4.2 Q934386 KB934386 October 8, 2011
• 934188 FIX: The Distribution Agent does not deliver commands to the Subscriber even if the Distribution Agent is running in SQL Server 2005 Q934188 KB934188 October 8, 2011
• 934109 FIX: The Distribution Agent generates an access violation when you configure a transactional replication publication to run an additional script after the snapshot is applied at the subscriber in SQL Server 2005 Q934109 KB934109 October 8, 2011
• 934106 FIX: SQL Server 2005 database engine generates failed assertion errors when you use the Replication Monitor to monitor the distribution database Q934106 KB934106 October 8, 2011
• 934066 FIX: The row of data on the publisher and the row of data on the subscriber may be inconsistent in a merge publication after synchronization has occurred in SQL Server 2005 Q934066 KB934066 October 8, 2011
• 933766 FIX: Failed assertion message in the Errorlog file when you perform various operations in SQL Server 2005: "Failed Assertion = 'fFalse' Attempt to access expired blob handle (3)" Q933766 KB933766 October 8, 2011
• 933762 FIX: You receive error 18815 when the Log Reader Agent runs for a transactional publication in SQL Server 2005 Q933762 KB933762 October 8, 2011
• 933724 FIX: The query performance is slow when you run a query that uses a user-defined scalar function against an instance of SQL Server 2005 Q933724 KB933724 October 8, 2011
• 933519 FIX: Error message when the Log Reader Agent runs for a transactional publication in SQL Server 2005: "Invalid Text Info Block for UpdateText" Q933519 KB933519 October 8, 2011
• 933499 FIX: Error message when you use transactional replication to replicate the execution of stored procedures to subscribers in SQL Server 2005: "Insufficient memory to run query" Q933499 KB933499 October 8, 2011
• 933265 FIX: You may receive error 1203 when you run an INSERT statement against a table that has an identity column in SQL Server 2005 Q933265 KB933265 October 8, 2011
• 932990 FIX: You cannot obtain statements in the current batch in SQL Server 2005 by using the DBCC INPUTBUFFER statement, trace flag 1204, deadlock graph event class, or Activity Monitor Q932990 KB932990 October 8, 2011
• 932555 FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 2047 Q932555 KB932555 October 8, 2011
• 932393 FIX: You may experience poor performance after you install SQL Server 2005 Service Pack 1 Q932393 KB932393 October 8, 2011
• 932331 FIX: Error message when you try to build a mining model that contains lots of data on a 32-bit SQL Server 2005 Analysis Services server: "Memory error: Allocation failure: Not enough storage is available to the process command" Q932331 KB932331 October 8, 2011
• 932180 FIX: The Cluster Discrimination tab is empty when you browse a clustering model of SQL Server 2005 Analysis Services in SQL Server BIDS Q932180 KB932180 October 8, 2011
• 932115 FIX: The ghost row clean-up thread does not remove ghost rows on some data files of a database in SQL Server 2005 Q932115 KB932115 October 8, 2011
• 931843 FIX: SQL Server 2005 does not reclaim the disk space that is allocated to the temporary table if the stored procedure is stopped Q931843 KB931843 October 8, 2011
• 931666 FIX: An assertion violation may be logged after you install SQL Server 2005 or after you add more processors to a server that is running SQL Server 2005 Q931666 KB931666 October 8, 2011
• 931593 FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 2153 and later builds Q931593 KB931593 October 8, 2011
• 930505 FIX: Error message when you run DML statements against a table that is published for merge replication in SQL Server 2005: "Could not find stored procedure" Q930505 KB930505 October 8, 2011
• 930409 FIX: Error message when you run a Multidimensional Expressions (MDX) query that uses a calculated member in SQL Server 2005 Analysis Services: "Internal error An unexpected exception occurred" Q930409 KB930409 October 8, 2011
• 929278 FIX: SQL Server 2005 may not perform histogram amendments when you use trace flags 2389 and 2390 Q929278 KB929278 October 8, 2011
• 929179 FIX: A memory leak may occur every time that you synchronize a SQL Server Mobile subscriber in SQL Server 2005 Q929179 KB929179 October 8, 2011
• 928539 FIX: An access violation is logged in the SQL Server Errorlog file when you run a query that uses a plan guide in SQL Server 2005 Q928539 KB928539 October 8, 2011
• 928538 FIX: The Report Server Windows service may stop responding, and you may receive the following error message in SQL Server 2005 Reporting Services: "An internal error occurred on the report server" Q928538 KB928538 October 8, 2011
• 928394 FIX: The changes are not reflected in the publication database after you reinitialize the subscriptions in SQL Server 2005 Q928394 KB928394 October 8, 2011
• 928372 FIX: Error message when you use a synonym for a stored procedure in SQL Server 2005: "A severe error occurred on the current command" Q928372 KB928372 October 8, 2011
• 928243 FIX: When you run a SQL Server 2005 Integration Services package, the package may stop responding Q928243 KB928243 October 8, 2011
• 927643 FIX: Some search results are missing when you perform a full-text search operation on a Windows SharePoint Services 2.0 site after you upgrade to SQL Server 2005 Q927643 KB927643 October 8, 2011
• 927289 FIX: Updates to the SQL Server Mobile subscriber may not be reflected in the SQL Server 2005 merge publication Q927289 KB927289 October 8, 2011
• 926967 FIX: You obtain an incorrect result when you run a Multidimensional Expressions (MDX) query in SQL Server 2005 Service Pack 1 Q926967 KB926967 October 8, 2011
• 926962 FIX: The user can see all the data in a cube, and SQL Server 2005 Analysis Services may crash Q926962 KB926962 October 8, 2011
• 926611 FIX: SQL Server 2005 may not send a message notification that is based on the specific string in the forwarded event when a computer that is running SQL Server 2000 forwards an event to a computer that is running SQL Server 2005 Q926611 KB926611 October 8, 2011
• 926493 FIX: Error message when you restore a transaction-log backup that is generated in SQL Server 2000 SP4 to an instance of SQL Server 2005: "Msg 3456, Level 16, State 1, Line 1. Could not redo log record" Q926493 KB926493 October 8, 2011
• 926425 FIX: Error message when you try to query data from a column of the XML data type or from a variable of the XML data type in SQL Server 2005: "An error occurred while executing batch" Q926425 KB926425 October 8, 2011
• 926422 FIX: You receive error messages when you use SQL Server Management Studio or SQL Server Business Intelligence Development Studio after you install Microsoft Office Excel 2007 on a computer that has SQL Server 2005 Analysis Services installed Q926422 KB926422 October 8, 2011
• 926335 FIX: Error message when you trace the Audit Database Management event and you try to bring a database online in SQL Server 2005: “Msg 942, Level 14, State 4, Line 1” Q926335 KB926335 October 8, 2011
• 926285 Fix: Error message when you convert a column from the varbinary(max) data type to the XML data type in SQL Server 2005: "Msg 6322, Level 16, State 1, Line 2 Too many attributes or namespace definitions" Q926285 KB926285 October 8, 2011
• 925387 FIX: Error message when you use a unary operator in a parent/child dimension in a SQL Server 2005 Analysis Services cube: "Record ID is not valid" Q925387 KB925387 October 8, 2011
• 925278 FIX: A query may crash, and you may receive an error message when an MDX query uses the Filter function at the start to slice a partition in SQL Server 2005 Analysis Services: "An unexpected exception occurred" Q925278 KB925278 October 8, 2011
• 925227 FIX: Error message when you call the SQLTables function against an instance of SQL Server 2005: "Invalid cursor state (0)" Q925227 KB925227 October 8, 2011
• 925153 FIX: You may receive different date values for each row when you use the getdate function within a case statement in SQL Server 2005 Q925153 KB925153 October 8, 2011
• 925135 FIX: An empty string is replicated as a NULL value when you synchronize a table to a SQL Server 2005 Compact Edition subscriber Q925135 KB925135 October 8, 2011
• 978791 FIX: Data loss may occur if the database mirroring thread stops responding for a long time during an automatic failover process in SQL Server 2005 or in SQL Server 2008 Q978791 KB978791 October 7, 2011
• 972139 FIX: The getColumns method of the DatabaseMetaData object returns an incorrect column length if the column length that you defined is 24 in SQL Server 2005 JDBC driver 1.2 Q972139 KB972139 October 7, 2011
• 969619 FIX: The certificate that was used to sign classes in the Microsoft SQL Server JDBC driver has expired in SQL Server JDBC Driver version 1.2 Q969619 KB969619 October 7, 2011
• 973968 FIX: A query notification event occurs at incorrect intervals and the time-out setting is not honored when you use query notification that is created by using the SqlDependency object in SQL Server 2008 or in SQL Server 2005 Q973968 KB973968 October 6, 2011
• 982899 Forms Based Authentication in Reporting Service Q982899 KB982899 October 5, 2011
• 927290 FIX: Error message when you open a report in Report Manager in SQL Server 2005 Reporting Services: "An error has occurred during report processing. There is already an open DataReader associated with this Command which must be closed first" Q927290 KB927290 September 17, 2011
• 926515 FIX: You may receive unexpected results when you run an MDX query in SQL Server 2005 Analysis Services Q926515 KB926515 September 17, 2011
• 925277 FIX: You may experience very large growth increments of a principal database after you manually fail over a database mirroring session in SQL Server 2005 Q925277 KB925277 September 17, 2011
• 955695 FIX: When you run a Transact-SQL script in a step of a SQL Server Agent job in SQL Server 2005 or in SQL Server 2008, the result of the Transact-SQL script may be truncated Q955695 KB955695 June 16, 2011
• 2983564 FIX: Error message when you use database mirroring in Microsoft SQL Server 2005, Microsoft SQL Server 2008, or Microsoft SQL Server 2008 R2, and an assertion failure occurs intermittently Q2983564 KB2983564 May 30, 2011
• 983564 FIX: Error message when you use database mirroring in Microsoft SQL Server 2005, Microsoft SQL Server 2008, or Microsoft SQL Server 2008 R2, and an assertion failure occurs intermittently Q983564 KB983564 May 30, 2011
• 974319 FIX: Intermittent error message and assertion failure when you use database mirroring in SQL Server 2005, in SQL Server 2008, or in SQL Server 2008 R2: "SQL Server Assertion: File: <loglock.cpp>, line=823 Failed Assertion = 'result == LCK_OK'" Q974319 KB974319 April 29, 2011
• 969142 FIX: Error message when you run the DBCC CHECKDB statement on a database in SQL Server 2005: "Unable to deallocate a kept page" Q969142 KB969142 March 22, 2011
• 2475907 FIX: "SQL Server is terminating this process" error message when the "OLEDB Call Event" event is captured by using SQL Server Profiler or a server-side trace in SQL Server 2005 Q2475907 KB2475907 February 21, 2011
• 2468047 FIX: Error code 17883 or "Non-yielding Scheduler" error may occur when you use the OPENQUERY function on SQL Server 2005 Q2468047 KB2468047 February 21, 2011
• 2428229 FIX: Error message when you use Query Designer in SQL Server 2005:"Unable to find an entry point named 'GetWindowLongPtr' in 'user32.dll'" Q2428229 KB2428229 December 23, 2010
• 2397173 FIX: A blank cell is returned when you query XML data by using the "Results to Grid" mode in SQL Server 2005 Management Studio if a large amount of data exists Q2397173 KB2397173 December 23, 2010
• 2389533 FIX: "Infinite recursion detected" error message when a drillthrough action is used in SQL Server 2005 Analysis Services SP3 CU7 Q2389533 KB2389533 December 23, 2010
• 2983500 FIX: The role synchronization process is delayed when a mirroring automatic failover occurs in SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 Q2983500 KB2983500 December 22, 2010
• 983500 FIX: The role synchronization process is delayed when a mirroring automatic failover occurs in SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 Q983500 KB983500 December 22, 2010
• 975860 FIX: A full backup with snapshot may cause SQL Server 2005 or SQL Server 2008 to stop responding Q975860 KB975860 December 15, 2010
• 2983480 FIX: Various issues occur when a database is involved in a database mirroring session and in a transactional replication if trace flag 1448 is enabled Q2983480 KB2983480 November 15, 2010
• 2983429 FIX: A deadlock occurs when you run a query or a stored procedure that contains an XML column in SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 Q2983429 KB2983429 November 15, 2010
• 2222998 FIX: An incorrect cardinality estimate is returned when you run a query in SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 Q2222998 KB2222998 November 15, 2010
• 983480 FIX: Various issues occur when a database is involved in a database mirroring session and in a transactional replication if trace flag 1448 is enabled Q983480 KB983480 November 15, 2010
• 983429 FIX: A deadlock occurs when you run a query or a stored procedure that contains an XML column in SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 Q983429 KB983429 November 15, 2010
• 982363 FIX: SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 may require a long time to complete an ALTER TABLE statement that alters an XML data type column from "NOT NULL" to "NULL" in a table Q982363 KB982363 November 15, 2010
• 981888 FIX: "Deadlock monitor failed to resolve this deadlock. Server may require restart to recover from this condition" error message when a database is being recovered in Microsoft SQL Server 2005, Microsoft SQL Server 2008, or Microsoft SQL Server 2008 R2 Q981888 KB981888 November 15, 2010
• 981867 FIX: A calculated member that uses filtered dimension members returns an incorrect result in SSAS 2005, SSAS 2008 R2 or SSAS 2008 Q981867 KB981867 November 15, 2010
• 981713 FIX: A query returns an incorrect result if it uses an index that is being rebuilt online in SQL Server 2005, SQL Server 2008 R2 or SQL Server 2008 Q981713 KB981713 November 15, 2010
• 981502 FIX: A query that uses a parallel query plan returns different results every time that you run the query in SQL Server 2005, SQL Server 2008 R2 or SQL Server 2008 Q981502 KB981502 November 15, 2010
• 980948 FIX: Metadata is corrupted when you move SSAS 2005, SSAS 2008 R2 or SSAS 2008 data folders from one computer to another computer Q980948 KB980948 November 15, 2010
• 980883 FIX: Proactive caching starts unexpectedly when you insert data in SQL Server 2005, SQL Server 2008 R2 or SQL Server 2008 Q980883 KB980883 November 15, 2010
• 959012 FIX: A database shrink may not succeed or unexplained transaction log growth may occur in SQL Server 2005 Q959012 KB959012 November 9, 2010
• 982853 FIX: Error message when you run a Full-Text query in SQL Server 2005: "Too many full-text columns or the full-text query is too complex to be executed" Q982853 KB982853 October 27, 2010
• 934065 FIX: Error message when the Replication Merge Agent runs to synchronize a merge replication subscription in SQL Server 2005: “The merge process failed to execute a query because the query timed out” Q934065 KB934065 August 31, 2010
• 926024 FIX: The query performance is very slow when you use a fast forward-only cursor to run a query in SQL Server 2005 Q926024 KB926024 August 31, 2010
• 2297203 FIX: "SOS_Task::GetCurrent() == m_parentTask" assertion failure occurs when you run a backup and restore command in Microsoft SQL Server 2005 SP3 Q2297203 KB2297203 August 17, 2010
• 2983390 FIX: ACCESS_VIOLATION error when you rebuild indexes online in Microsoft SQL Server 2005 Q2983390 KB2983390 August 16, 2010
• 2291437 FIX: The Analysis Services process stops responding when you use the writeback feature in SQL Server 2005 SP3 Q2291437 KB2291437 August 16, 2010
• 981814 FIX: SSMS Object Explorer does not display the correct version number for SSIS or for SSRS Q981814 KB981814 August 16, 2010
• 981811 FIX: An error occurs when you update the schema of objects that are in a published database in Microsoft SQL Server 2005, Microsoft SQL Server 2008, or Microsoft SQL Server 2008 R2 Q981811 KB981811 August 16, 2010
• 981273 FIX: A SQL Server assertion is logged in the SQL Server Errorlog file when you restart the SQL Server service in SQL Server 2005 Q981273 KB981273 June 23, 2010
• 950967 FIX: Error message when you run an MDX query that includes a CROSSJOIN operation in SQL Server 2005 Analysis Services: "An unexpected exception occured" Q950967 KB950967 May 24, 2010
• 961237 FIX: You cannot kill a session that is running a query on a linked server in SQL Server 2005 and in SQL Server 2008 Q961237 KB961237 May 13, 2010
• 974985 FIX: A "DBCC CHECKDB" statement or a "DBCC CHECKTABLE" statement reports errors after you rebuild an XML index in SQL Server 2005 Q974985 KB974985 April 26, 2010
• 981755 FIX: "Internal Query Processor Error” error message when you run a query that joins multiple tables in SQL Server 2005 Q981755 KB981755 April 22, 2010
• 981106 FIX: An access violation occurs when you run an SSIS 2005 package that uses Lookup transformations Q981106 KB981106 April 19, 2010
• 981074 FIX: The DownloadGenerationsPerBatch parameter is not applied correctly in a SQL Server 2005 merge replication Q981074 KB981074 April 19, 2010
• 980290 FIX: The content index is corrupted when the master merge process is paused in SQL Server 2005 Q980290 KB980290 April 19, 2010
• 978308 FIX: You cannot create a maintenance plan or perform a DatabaseMail operation after you install a service pack or hotfix on a SQL Server 2005 failover cluster Q978308 KB978308 April 19, 2010
• 979042 FIX: The principal database is not recovered if the database has a large number of virtual log files in SQL Server 2005 or in SQL Server 2008 Q979042 KB979042 February 17, 2010
• 979777 FIX: You experience some problems when you perform a grouping members operation on an Excel pivot table whose data source is an SSAS 2005 cube or an SSAS 2008 cube Q979777 KB979777 February 16, 2010
• 979549 FIX: Data is corrupted when you update data that is in an LOB column in a SQL Server 2005 or SQL Server 2008 transactional replication Q979549 KB979549 February 16, 2010
• 978518 FIX: Error message in SQL Server 2005 when you run an update statement on a database whose compatibility level is 6"Msg 4104, Level 16, State 1, Line 1 The multi-part identifier <Alias Name>.<Column Name> could not be bound" Q978518 KB978518 February 16, 2010
• 970672 FIX: Error message in the Errorlog file when you run a query in SQL Server 2005: "A time-out occurred while waiting for buffer latch" Q970672 KB970672 January 22, 2010
• 978851 FIX: The -R parameter is ignored when you use the BCP.exe utility together with the -R parameter and the -F parameter in SQL Server 2005 or in SQL Server 2008 Q978851 KB978851 January 18, 2010
• 977842 FIX: An access violation occurs when you run the SET FMTONLY statement to set the value of the FMTONLY option to ON and a SQL Server 2005 or SQL Server 2008 server is under memory pressure Q977842 KB977842 January 18, 2010
• 977450 FIX: Error message when you run a query that uses a common table expression to shred XML data in SQL Server 2005 or in SQL Server 2008: "Internal Query Processor Error: The query processor could not produce a query plan" Q977450 KB977450 January 18, 2010
• 977309 FIX: A SSAS 2005 or SSAS 2008 server crashes when you run a Multidimensional Expressions query that uses the CDBL function in a calculated member Q977309 KB977309 January 18, 2010
• 977151 FIX: Error message when you add a subscription to a republisher that is in a merge publication in SQL Server 2005 or in SQL Server 2008: “Cannot create the subscription because the subscription already exists in the subscription database” Q977151 KB977151 January 18, 2010
• 976974 FIX: You are continuously prompted for credentials when you use Business Intelligence Development Studio to deploy a SQL Server 2005 Reporting Services or SQL Server 2008 Reporting Services report Q976974 KB976974 January 18, 2010
• 976691 FIX: An access violation occurs intermittently when you run an application that uses SQL Server 2005 service broker or SQL Server 2008 service broker Q976691 KB976691 January 18, 2010
• 976565 FIX: A query that opens a cursor in an inline table-valued function or a view returns an incorrect result in SQL Server 2005 or in SQL Server 2008 Q976565 KB976565 January 18, 2010
• 976410 FIX: Performance issues occur when the join predicate in your query has outer reference columns in SQL Server 2005 or in SQL Server 2008 Q976410 KB976410 January 18, 2010
• 975950 FIX: Error message when you run an SSIS 2005 or SSIS 2008 package that uses the IBM DB2 OLE DB provider to export data to an IBM DB2 server: "The number of failing rows exceeds the maximum specified. Out of memory" Q975950 KB975950 January 18, 2010
• 975825 FIX: A row is not deleted at a subscriber when you delete a row at the publisher and then perform synchronization in a SQL Server 2005 or SQL Server 2008 merge replication Q975825 KB975825 January 18, 2010
• 974749 FIX: The last character of a char column or an nchar column is incorrectly replaced by a space character (char(32)) after a conflict is resolved by a customized conflict resolver in SQL Server 2005 or in SQL Server 2008 Q974749 KB974749 January 18, 2010
• 973785 FIX: Membership is not scripted in the predefined database roles after you script a database and enable the "Script object-level permissions" option in SQL Server 2005 or in SQL Server 2008 Q973785 KB973785 January 18, 2010
• 977100 FIX: An insert operation for a temporary table that has a foreign key constraint fails when the execution plan for the INSERT statement contains a merge join operation in SQL Server 2005 Q977100 KB977100 December 24, 2009
• 977350 FIX: Assertion failures occur in SQL Server 2005 when a Distributed Transaction Coordinator (DTC) transaction is rolled back while that transaction is being commited by the DTC Q977350 KB977350 December 22, 2009
• 977376 FIX: Even though the Distribution Agent successfully reapplies a batch of failed commands, you still receive error message 20046 that indicates that the Distribution Agent failed in a SQL Server 2005 or SQL Server 2008 transactional replication Q977376 KB977376 December 21, 2009
• 977255 FIX: The leading spaces in a text box or spaces in a multiline text block are truncated when you export a SQL Server 2005 Reporting Services report to a PDF file Q977255 KB977255 December 21, 2009
• 977247 FIX: An access violation occurs when you run a query on a table that has a partitioned nonclustered index in SQL Server 2005 Q977247 KB977247 December 21, 2009
• 976754 FIX: An assertion failure occurs when you query the sys.dm_broker_activated_tasks DMV in SQL Server 2005 or in SQL Server 2008 Q976754 KB976754 December 21, 2009
• 976412 FIX: An MDX query resets to a blank query when you click the Data tab in Business Intelligence Development Studio 2005 Report Designer Q976412 KB976412 December 21, 2009
• 978145 FIX: Error message when you concurrently process objects in SQL Server Analysis Services after you install a cumulative update: "While attempting to acquire one or more locks, the transaction was canceled" Q978145 KB978145 December 17, 2009
• 961704 FIX: The SQL Server Writer Service is not listed in the results when you run the Volume Shadow Copy Service administrative command-line tool on a server that has SQL Server 2005 installed Q961704 KB961704 December 15, 2009
• 974290 FIX: You experience high latency for all the Peer-To-Peer transactional distribution agents when you insert lots of rows in a batch to multiple publications in a SQL Server 2005 Peer-To-Peer transactional replication Q974290 KB974290 November 24, 2009
• 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)" Q972687 KB972687 November 24, 2009
• 976030 FIX: Error message after you perform a Process Update on a dimension used on a cube that contains a writeback partition: "Errors in the high-level relational engine. The data source view does not contain a definition for the <tablename> table or view" Q976030 KB976030 November 16, 2009
• 974130 FIX: A memory leak may occur if you use a linked server query to retrieve a sql_variant column from a remote server in SQL Server 2005 or in SQL Server 2008 Q974130 KB974130 November 16, 2009
• 975783 FIX: You receive an incorrect result when you run an MDX query against a dimension that has a parent/child relationship after you install a cumulative update in SQL Server 2005 Analysis Services or in SQL Server 2008 Analysis Services Q975783 KB975783 November 3, 2009
• 975134 FIX: Capitalization and accent changes on a column of user-defined data type are not propagated in SQL Server 2005 merge replication or in SQL Server 2008 merge replication Q975134 KB975134 October 23, 2009
• 974785 FIX: An API cursor plan that is created by a plan guide is not reused when the cursor is active in SQL Server 2005 and in SQL Server 2008 Q974785 KB974785 October 23, 2009
• 972926 FIX: The connection to a Microsoft SQL Server 2005 Reporting Services catalog database encounters an error, and the connection is not reset Q972926 KB972926 October 23, 2009
• 975159 FIX: For SQL Server Compact Edition (CE) Subscribers, only schema without data is replicated for newly added articles to an existing Merge Publication using “ExchangeType.Upload” Q975159 KB975159 October 22, 2009
• 976041 FIX: You receive an incorrect result when you run a query that uses a parallel execution plan in SQL Server 2005 or in SQL Server 2008 Q976041 KB976041 October 19, 2009
• 975748 FIX: You cannot process an object when you change or delete another unrelated object at the same time in the same database in SQL Server 2005 Analysis Services or in SQL Server 2008 Analysis Services Q975748 KB975748 October 19, 2009
• 975417 FIX: A SELECT statement returns an incorrect result set if a linked server is being used in SQL Server 2005 or in SQL Server 2008 Q975417 KB975417 October 19, 2009
• 975230 FIX: You receive an incorrect result when you run a query that uses a ranking function on a partitioned table in SQL Server 2005 Q975230 KB975230 October 19, 2009
• 975089 FIX: The restore operation takes a long time when you restore a database that has query notification enabled in SQL Server 2005 or in SQL Server 2008 Q975089 KB975089 October 19, 2009
• 974777 FIX: Database restore operation may fail during the recovery phase when the database uses query notification in SQL Server 2005 or in SQL Server 2008 Q974777 KB974777 October 19, 2009
• 974296 FIX&#58; A deadlock occurs when you perform an operation that cleans up the security cache in SQL Server 2005 Q974296 KB974296 October 19, 2009
• 974067 FIX: You use the COUNT function on a column that is returned by a subquery that returns no rows in SQL Server 2005 or in SQL Server 2008, and an incorrect result is returned Q974067 KB974067 October 19, 2009
• 973643 FIX: The synchronization of a merge publication that uses Web synchronization takes a very long time to finish after the initial synchronization in SQL Server 2005 or in SQL Server 2008 Q973643 KB973643 October 19, 2009
• 953948 FIX: Error message when you perform an update operation by using a cursor in SQL Server 2005: "Transaction (Process ID <SPID>) was deadlocked on lock resources with another process and has been chosen as the deadlock victim" Q953948 KB953948 September 25, 2009
• 973103 FIX: Error message when you run the Distribution Agent to synchronize the subscribers with the publisher in Microsoft SQL Server 2005 or SQL Server 2008:" The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect" Q973103 KB973103 September 22, 2009
• 974398 FIX: The removal of a transaction log file from the database on the principal server causes a database mirroring session to be suspended in SQL Server 2005 or in SQL Server 2008 Q974398 KB974398 September 21, 2009
• 970939 FIX: Error message when you run a query that queries the sys.sysindexes view in SQL Server 2005: "Error: 701, Severity: 17, State: 123. There is insufficient system memory to run this query" Q970939 KB970939 August 27, 2009
• 971409 FIX: Error message when you run a query that contains duplicate join conditions in SQL Server 2005: "Internal Query Processor Error: The query processor could not produce a query plan" Q971409 KB971409 August 24, 2009
• 960142 FIX: An error message is logged, and the synchronization may take a long time to finish when you use an application to synchronize a merge replication that contains a SQL Server 2005 Compact Edition subscriber Q960142 KB960142 August 24, 2009
• 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" Q972365 KB972365 August 18, 2009
• 973877 FIX: A performance issue in which you run a query by using a Fast Forward cursor in SQL Server 2005 or SQL Server 2008 Q973877 KB973877 August 17, 2009
• 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 Q973578 KB973578 August 17, 2009
• 972694 FIX: SQL Server 2008 Reporting Services Add-in for SharePoint removes the "Microsoft.SqlServer.Smo" assembly for SQL Server 2005 from the GAC Q972694 KB972694 August 17, 2009
• 972681 FIX: The removal of a transaction log file of the database on the principal server breaks a database mirroring session in SQL Server 2005 or in SQL Server 2008 Q972681 KB972681 August 17, 2009
• 972637 FIX&#58; An access violation occurs when you run a query that uses a string matching function in SQL Server 2005 Q972637 KB972637 August 17, 2009
• 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 or SQL Server 2008: "spid1005 Error: 5243, Severity: 22, State: 1 An inconsistency was detected during an internal operation" Q972271 KB972271 August 17, 2009
• 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" Q971114 KB971114 August 17, 2009
• 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 Q971057 KB971057 August 17, 2009
• 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." Q970726 KB970726 August 17, 2009
• 969086 FIX: The SQL Server service stops responding, and event ID 2019 is logged in the System log in SQL Server 2005 or in SQL Server 2008 Q969086 KB969086 August 11, 2009
• 968615 FIX: SQL Server Integration Services Import and Export Wizard does not provide the ConnectionString property for the .NET Framework Data Provider for ODBC Q968615 KB968615 August 7, 2009
• 968171 FIX: Error message when you try to create an encrypted database in SQL Server 2005 Compact Edition: "The operating system does not support encryption" Q968171 KB968171 July 24, 2009
• 970966 FIX: An MDX query that uses the NON EMPTY clause and the DrillDownLevel function returns null values in SQL Server 2005 Analysis Services or SQL Server 2008 Analysis Services Q970966 KB970966 July 21, 2009
• 970823 FIX: CPU usage increases when you run a query that uses a string comparison function on a computer that has many processors after you upgrade to SQL Server 2005 Service Pack 3 or to SQL Server 2008 Q970823 KB970823 July 21, 2009
• 970551 FIX: Error message when you run an MDX query that requests a dimension property on a parent-child hierarchy in Microsoft SQL Server 2005 Analysis Services or in SQL Server 2008 Analysis Services Q970551 KB970551 July 21, 2009
• 970058 FIX: Error message when you open a report by specifying a multivalued parameter in a URL in SQL Server 2005 or SQL Server 2008 Reporting Services: "Default value or value provided for the report parameter '<Parameter>' is not a valid value" Q970058 KB970058 July 21, 2009
• 969844 FIX: You receive inconsistent results when you run index-related DMVs to return statistical information about missing indexes in SQL Server 2005 or in SQL Server 2008 Q969844 KB969844 July 21, 2009
• 969528 FIX: An assertion failure occurs when you switch the schedule of a report subscription between a shared schedule and a custom schedule in SQL Server 2005 Report Services or SQL Server 2008 Reporting Services Q969528 KB969528 July 21, 2009
• 967522 FIX: The SQL Server engine in SQL Server 2005 and in SQL Server 2008 may consume large amounts of memory during the setup configuration phase Q967522 KB967522 July 21, 2009
• 956574 FIX: Data results are inconsistent in SQL Server 2005 and in SQL Server 2008 when you run a search query that uses the NEAR operator against an XML type data that contains the xml:lang attribute Q956574 KB956574 July 21, 2009
• 948567 FIX: When you run a query against a table that contains Traditional Chinese characters, the incorrect result is returned in SQL Server 2005 or SQL Server 2008 Q948567 KB948567 July 21, 2009
• 970915 FIX: Error message when you synchronize a merge replication with SQL Server 2005 Compact Edition subscribers: "A column ID occurred more than once in the specification. HRESULT 0x80040E3E (0)" Q970915 KB970915 July 3, 2009
• 971607 FIX: The synchronization operation fails when you run the Merge Agent to synchronize a merge publication that uses Web synchronization in SQL Server 2005 Q971607 KB971607 June 16, 2009
• 971529 FIX: An UPDATE or a DELETE statement that uses a join on a remote table in a linked server runs very slowly in Microsoft SQL Server 2005 Q971529 KB971529 June 16, 2009
• 970648 FIX: The SQL Server service consumes lots of memory when you run a query that uses the sys.dm_exec_sql_text dynamic management function in the APPLY operator in SQL Server 2005 Q970648 KB970648 June 16, 2009
• 970349 FIX&#58; Queries from a query notification that has a lot of subscriptions run slowly when you change the Auto Close option to False in SQL Server 2005 or in SQL Server 2008 Q970349 KB970349 June 16, 2009
• 968900 FIX: Measures, measure groups, and dimensions that are not part of a perspective are exposed incorrectly when you create a grouping on the perspective in SQL Server 2005 Analysis Services or in SQL Server 2008 Analysis Services Q968900 KB968900 June 16, 2009
• 967470 FIX: Error message when you perform an update or a delete operation on a table that does not have a clustered index created in SQL Server 2005 and in SQL Server 2008: "The operating system returned error 1450" Q967470 KB967470 June 16, 2009
• 967164 FIX: The SQL Server service stops responding, and you receive error 1450 when you create database snapshot or run a DBCC CHECK statement on a database in SQL Server 2005 and in SQL Server 2008 Q967164 KB967164 June 16, 2009
• 950435 FIX: Error messages may be logged in the SQL Server error log when you use the BULK INSERT statement on a table or you insert data into a table by using Transact-SQL in SQL Server 2005 Q950435 KB950435 May 30, 2009
• 969588 FIX: Some cell values are doubled when you run an MDX query against a database that has the AllowedSet permission set for a dimension in SQL Server 2005 Analysis Services or in SQL Server 2008 Analysis Services Q969588 KB969588 May 18, 2009
• 968449 FIX: A query that runs in parallel on a multiprocessor computer returns incorrect results in SQL Server 2005 or in SQL Server 2008 Q968449 KB968449 May 18, 2009
• 968290 FIX: A mining model of the Microsoft Decision Tree algorithm generates incorrect nodes when you set the MINIMUM_SUPPORT parameter to "9" in SQL Server 2005 Analysis Services or in SQL Server 2008 Analysis Services Q968290 KB968290 May 18, 2009
• 967983 FIX: You receive an incorrect result when you enable the ANSI_NULLS database option and run a query against an indexed view in SQL Server 2005 or in SQL Server 2008 Q967983 KB967983 May 18, 2009
• 967337 FIX: When you run a stored procedure that contains a query that uses the FOR XML EXPLICIT clause, you may obtain a schema that is badly formed in SQL Server 2005 or in SQL Server 2008 Q967337 KB967337 May 18, 2009
• 967206 FIX: You obtain incorrect values for a column when you use the OPENROWSET function to import data from a data file by using an XML format file in SQL Server 2005 or in SQL Server 2008 Q967206 KB967206 May 18, 2009
• 961811 FIX: The CPU usage and the memory usage increase gradually and many session IDs are in the dormant status in SQL Server 2005 and in SQL Server 2008 Q961811 KB961811 May 18, 2009
• 961106 FIX: Error message when you run a query in SQL Server 2005 or in SQL Server 2008: "Internal Query Processor Error: The query processor could not produce a query plan" Q961106 KB961106 May 18, 2009
• 961049 FIX: When you run a query that uses the NOLOCK table hint in SQL Server 2005 or in SQL Server 2008 to retrieve BLOB data, the query runs very slowly Q961049 KB961049 May 18, 2009
• 961739 FIX: The tempdb database is corrupted when you start some transactions that use the snapshot isolation level on a database that has row versioning enabled in SQL Server 2005 Q961739 KB961739 May 12, 2009
• 960552 FIX: Error message when you create a WMI event alert by using the sp_add_alert stored procedure in a SQL Server 2005 cluster: "The @wmi_query could not be executed in the @wmi_namespace provided" Q960552 KB960552 May 11, 2009
• 968951 FIX: A SQL Server 2005-based application cannot connect to a mirrored database by using the JDBC driver 1.2 after the first successful connection Q968951 KB968951 April 30, 2009
• 962003 FIX: Error message when you synchronize data for a SQL Server Compact Edition subscriber in SQL Server 2005 and in SQL Server 2008: "A call to SQL Server Reconciler failed. Try to resynchronize. HRESULT 0x80004005 (29006)" Q962003 KB962003 April 22, 2009
• 961935 FIX: A query notification is not fired correctly if the query contains inner joins and the IS NULL clause in SQL Server 2005 and in SQL Server 2008 Q961935 KB961935 April 22, 2009
• 961648 FIX: You receive an error message when you try to query or update a column of large object (LOB) data in SQL Server 2005 and in SQL Server 2008 Q961648 KB961648 April 22, 2009
• 969466 FIX: Error message when you run a query that uses the CASE function in SQL Server 2005: "Conversion failed when converting the <DateType> value '<Value>' to data type <DataType>" Q969466 KB969466 April 20, 2009
• 969123 FIX: Error message occurs unexpectedly at different times in a SQL Server 2005 Analysis Services database that uses user-defined functions: "The <Function Name> function does not exist" Q969123 KB969123 April 20, 2009
• 969021 FIX: A query that contains the IS NOT NULL clause returns an incorrect result in SQL Server 2005 Q969021 KB969021 April 20, 2009
• 968914 FIX: When you convert a TEXT column to a VARCHAR(MAX) column, an NTEXT column to a NVARCHAR(MAX) column, or an IMAGE column to a VARBINARY(MAX) column, the original NULL values in these columns may become empty strings in SQL Server 2005 Q968914 KB968914 April 20, 2009
• 968906 FIX: An access violation occurs when a peer-to-peer transactional replication is under stress in SQL Server 2005 Q968906 KB968906 April 20, 2009
• 968233 FIX: A SQL Server 2005 database becomes offline unexpectedly when you run an application that uses service broker on this database Q968233 KB968233 April 20, 2009
• 968079 FIX: Error message after you configure a peer-to-peer transactional replication and then apply SQL Server 2005 Service Pack 3: "The process could not allocate memory. (Source: MSSQL_REPL, Error number: MSSQL_REPL20001)" Q968079 KB968079 April 20, 2009
• 967984 FIX&#58; When you process a full-text catalog in SQL Server 2005 and in SQL Server 2008, the operation stops responding Q967984 KB967984 April 20, 2009
• 967625 FIX: Error message when you synchronize a database in SQL Server 2005 Analysis Services: "Errors in the metadata manager. The dimension with ID of '<Dimension ID>', Name of '<Dimension Name>' referenced by the '<Cube Name>' cube, does not exist" Q967625 KB967625 April 20, 2009
• 967618 FIX: Error message when you try to export a report to a PDF file in SQL Server 2005 Reporting Services: "Non-negative number required" Q967618 KB967618 April 20, 2009
• 967570 FIX: An empty result set is returned when you run an SSIS package that contains an Execute SQL task in SQL Server 2005 Service Pack 2 Q967570 KB967570 April 20, 2009
• 967527 FIX: Error message when you apply a snapshot file that is exactly divisible by 1 MB in SQL Server 2005: "The process could not bulk copy into table dbo.<tablename>. (Source: MSSQLServer, Error number: 20253)" Q967527 KB967527 April 20, 2009
• 967316 FIX: The values of some SQL Server 2005 SSIS pipeline counters are always 0 when you try to view them in a terminal session Q967316 KB967316 April 20, 2009
• 967169 FIX: When you run an UPDATE statement against a table that has a FOR UPDATE trigger that joins the DELETED and INSERTED tables, the query takes a long time to finish Q967169 KB967169 April 20, 2009
• 967101 FIX: The performance of database mirroring decreases when you run a database maintenance job that generates a large number of transaction log activities in SQL Server 2005 Q967101 KB967101 April 20, 2009
• 962903 FIX: The population process stops responding when you create an additional full-text catalog in SQL Server 2005 Q962903 KB962903 April 20, 2009
• 961396 FIX: When you insert a string to a table by using the SQL Native Client (SNAC) OLE DB provider or the SNAC ODBC provider in a SQL Server 2005-based application, the string is truncated Q961396 KB961396 April 20, 2009
• 960543 FIX: SQL Server 2005 or SQL Server 2008 may stop responding when you are performing a backup Q960543 KB960543 April 10, 2009
• 959026 FIX: Error message when you run a DB2 query that uses the WITH UR query hint in SQL Server 2005 Analysis Services and in SQL Server 2008 Analysis Services: "OLE DB error: OLE DB or ODBC error: An unexpected token "WITH" was found following "<Query>"" Q959026 KB959026 April 7, 2009
• 959025 FIX: Error message when you call a stored procedure that returns a rowset which has the DBPROP_MAXROWS rowset property or the SSPROP_MAXBLOBLENGTH rowset property specified: "The incoming tabular data stream (TDS) protocol stream is incorrect" Q959025 KB959025 April 7, 2009
• 968398 FIX&#58; The SQL Server 2005 Analysis Services service crashes when you process dimensions in a cube that contains a calculation script by using the Process Update option Q968398 KB968398 April 3, 2009
• 961073 FIX: Error message when you run a DML statement in a LINQ to SQL application in SQL Server 2008: "The target table '<Table Name>' of the DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause" Q961073 KB961073 April 2, 2009
• 956351 FIX: Queries in multiple threads run much slower when you use the SQL Server 2005 Java Database Connectivity (JDBC) driver 1.2 than when you use the SQL Server JDBC driver 2.0 Q956351 KB956351 March 30, 2009
• 947204 FIX: The used space in the tempdb database increases continuously when you run a query that creates internal objects in the tempdb database in SQL Server 2005 Q947204 KB947204 March 9, 2009
• 963684 FIX: The execution plan does not use the forced index when you use the INDEX optimizer hint in a query that runs against a synonym in SQL Server 2005 Q963684 KB963684 February 17, 2009
• 967180 FIX: You are prompted to provide the credentials when you view a history snapshot for a SQL Server 2005 Reporting Services report if you use stored credentials for the data source of the report Q967180 KB967180 February 16, 2009
• 962209 FIX: Error message when you run an UPDATE statement on a database that has the SNAPSHOT or READ COMMITTED SNAPSHOT isolation level enabled in SQL Server 2005: "The Database ID <Database ID>, Page (<N>:<N>), slot <N> for LOB data type node does not exist" Q962209 KB962209 February 16, 2009
• 960977 FIX: Error message when you run a Multidimensional Expressions (MDX) query that contains a calculation in SQL Server 2005 Analysis Services: "An unexpected exception occurred" Q960977 KB960977 February 16, 2009
• 960971 FIX: Error message when you run some Multidimensional Expressions (MDX) queries that reference some calculated members in many connections at the same time in SQL Server 2005 Analysis Services: "An unexpected error occurred" Q960971 KB960971 February 16, 2009
• 960575 FIX: Some DML statements that should not be replicated are replicated to the subscribers when you replicate the execution of a stored procedure in a transactional replication in SQL Server 2005 or in SQL Server 2008 Q960575 KB960575 January 19, 2009
• 960574 FIX: Error message when you run the Snapshot Agent for a transactional replication that uses an Oracle 11g publisher in SQL Server 2005 or in SQL Server 2008: "Msg 21613, Level 16, State 1, Procedure sp_IHsyncmetadata, Line 223" Q960574 KB960574 January 19, 2009
• 960571 FIX: The Distribution Agent fails when you perform DML operations in a publication article and a concurrent snapshot is created in SQL Server 2005 or in SQL Server 2008 Q960571 KB960571 January 19, 2009
• 960562 FIX: Error message when you run two MDX queries on different connections at the same time in SQL Server 2005 Analysis Services or in SQL Server 2008 Analysis Services: "Transaction errors: The lock operation ended unsuccessfully because of deadlock" Q960562 KB960562 January 19, 2009
• 960283 FIX: You may encounter a deadlock scenario when you use table variables in SQL Server 2005 or in SQL Server 2008 Q960283 KB960283 January 19, 2009
• 959893 FIX: Some changes may not be replicated to the subscriber correctly in SQL Server 2005 or in SQL Server 2008 when the sum of the parameters exceeds 2,100 Q959893 KB959893 January 19, 2009
• 960570 FIX: A maintenance plan that contains a Rebuild Index task takes much longer to run in SQL Server 2005 Q960570 KB960570 December 20, 2008
• 960559 FIX&#58; Error message when you visit an ASP page that connects to an instance of SQL Server 2005 Analysis Services by using the MSOLAP90 provider&#58; &#34;The system cannot find the file specified&#34; Q960559 KB960559 December 20, 2008
• 960545 FIX&#58; Error message when you run an MDX query in SQL Server 2005 Analysis Services&#58; &#34;An unexpected error occurred &#40;file &#39;mdpropertyset.cpp&#39;, line 1032, function &#39;MDRangePropertySet&#58;&#58;Init&#39;&#34; Q960545 KB960545 December 20, 2008
• 960161 FIX: The changes to the data source of a SQL Server 2005 Integration Services package may be lost when the package is run by a job Q960161 KB960161 December 20, 2008
• 957357 FIX: You receive an error message that the file is being used by another process when you try to rename or move an output file from a job in SQL Server Agent in SQL Server 2005 Q957357 KB957357 December 20, 2008
• 956686 FIX: When you run a query that contains a JOIN operation in SQL Server 2005 or SQL Server 2008, and the ON clause of the JOIN operator contains a LIKE predicate, the query runs slower than in SQL Server 2000 Q956686 KB956686 December 20, 2008
• 956298 FIX: When you download the Report Builder ClickOnce application of SQL Server 2005 Reporting Services or SQL Server 2008 Reporting Services, the Reportbuilder.chm.deploy file is downloaded as the text/html content type instead of the application/octet-str Q956298 KB956298 December 20, 2008
• 956254 FIX: You may obtain an incorrect result when you use a cursor to perform DML operations on a table that does not have a clustered index in SQL Server 2008 or in SQL Server 2005 Q956254 KB956254 December 20, 2008
• 955920 FIX: Error message when you try to install SQL Server 2005: "[Microsoft][SQL Native Client][SQL Server]The certificate cannot be dropped because one or more entities are either signed or encrypted using it" Q955920 KB955920 December 20, 2008
• 955374 FIX: Error message when you run an MDX query in SQL Server 2005 Analysis Services after you install cumulative update 7 for SQL Server 2005 Service Pack 2: "The SQL Server Analysis Services (<InstanceName>) service terminated unexpectedly" Q955374 KB955374 December 20, 2008
• 948452 FIX: Error message when you run a full-text search query in SQL Server 2005: "Insufficient system resources exist to complete the requested service" Q948452 KB948452 December 20, 2008
• 960567 FIX: Error message when you try to shrink a database in SQL Server 2005 Service Pack 2: "File ID <FileID> of database ID <DatabaseID> cannot be shrunk as it is either being shrunk by another process or is empty" Q960567 KB960567 December 19, 2008
• 960555 FIX: Error message when you run a query that selects a column of the xml data type in SQL Server 2005: "'?', hexadecimal value 0xDC55, is an invalid character" Q960555 KB960555 December 19, 2008
• 960110 FIX: A significant delay occurs after you cancel a query on a client computer that connects to SQL Server 2005 across a slow link Q960110 KB960110 December 19, 2008
• 959030 FIX: If you enter many rows into the Fuzzy Grouping transformation, you may obtain an incorrect result in SQL Server 2005 Integration Services Q959030 KB959030 December 19, 2008
• 959028 FIX: Error message when you parse a query after you run the SET XACT_ABORT ON statement in SQL Server 2005: ".Net SqlClient Data Provider: A severe error occurred on the current command" Q959028 KB959028 December 19, 2008
• 958684 FIX: Log Reader Agent fails with error code 18834 in SQL Server 2005 Q958684 KB958684 December 19, 2008
• 958555 FIX: A SQL Server Agent job that creates a ServerXMLHTTP object by using an ActiveX script remains in the Executing status and is never completed in SQL Server 2008 or in SQL Server 2005 Q958555 KB958555 December 19, 2008
• 958004 FIX: The file growth setting is incorrect after you restore a database from SQL Server 2000 in SQL Server 2005 Q958004 KB958004 December 19, 2008
• 956889 FIX: Error message when you run the snapshot agent on a replication of a stored procedure in SQL Server 2005 or in SQL Server 2008: "The Name property cannot have a value of @param＿name for this version of SQL Server" Q956889 KB956889 December 19, 2008
• 959376 FIX: Error message when you run the DBCC SHRINKFILE command or the DBCC SHRINKDATABASE command on a server that contains a SQL Server 2008 database: "5205 : DBCC SHRINKFILE: Moving Page <FileId>:<PageId> failed" Q959376 KB959376 December 16, 2008
• 959017 FIX: You receive an incorrect result when you query a column of the varchar(max) data type that contains only one character from a table in SQL Server 2005 Q959017 KB959017 December 16, 2008
• 959004 FIX&#58; When a process that is running on an instance of SQL Server 2005 consumes a large amount of memory, dump files are generated in the folder that contains the SQL Server error log Q959004 KB959004 December 16, 2008
• 959003 FIX: Only the first command in a transaction is replicated to the subscriber when you set the MaxCmdsInTran parameter of Log Reader Agent to 1 in SQL Server 2005 Q959003 KB959003 December 16, 2008
• 959000 FIX: When you validate a publication in a transactional replication, articles that you added after you added a vertical filter to an article are not validated in SQL Server 2005 Q959000 KB959000 December 16, 2008
• 956911 FIX: A time-out setting is not available for the Web Service task in a Microsoft SQL Server 2005 Integration Services (SSIS) package Q956911 KB956911 December 16, 2008
• 959024 FIX: When the Merge Agent synchronizes multiple batches of changes, the synchronization may take a long time to finish or the synchronization may expire unexpectedly in SQL Server 2005 Q959024 KB959024 December 15, 2008
• 959023 FIX: A blocking issue occurs when you run the Merge Agent in SQL Server 2005 Q959023 KB959023 December 15, 2008
• 959020 FIX: When you use a CASE function that returns constants of the binary data type, some constants are trimmed incorrectly even after you run the SET ANSI_PADDING ON statement in SQL Server 2005 Q959020 KB959020 December 15, 2008
• 959019 FIX: You receive an incorrect result when you run a query that uses the LIKE operator in SQL Server 2005 Q959019 KB959019 December 15, 2008
• 959016 FIX: Rows that include a NULL column may not be deleted when you delete rows from a table by using "<ImageColumnName> is NULL" as the condition in the WHERE clause in SQL Server 2005 Q959016 KB959016 December 15, 2008
• 959013 FIX: The synchronization process is slow, and the CPU usage is high on the computer that is configured as the Distributor in SQL Server 2005 Q959013 KB959013 December 15, 2008
• 959010 FIX: Error message when an application that uses Service Broker sends messages in SQL Server 2005: "The conversation endpoint is not in a valid state for SEND" Q959010 KB959010 December 15, 2008
• 959009 FIX: Target endpoints in Service Broker of SQL Server 2005 leak in the valid message exchange pattern where the target sends only the end conversation message Q959009 KB959009 December 15, 2008
• 959008 FIX: Error message when you start database mirroring in SQL Server 2005 on a database that is restored or upgraded from SQL Server 2000: "The Service Broker ID for the remote copy of database "<DatabaseName>" does not match the ID on the principal server" Q959008 KB959008 December 15, 2008
• 959007 FIX: Error message when you use SQL Server Service Broker in SQL Server 2005: "Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE 589824" Q959007 KB959007 December 15, 2008
• 959006 FIX: Database mirroring sessions may stop intermittently in SQL Server 2005 Q959006 KB959006 December 15, 2008
• 953941 FIX: When you export a SQL Server 2005 Reporting Services report that contains an image to a .pdf format file, the .pdf file is displayed incorrectly Q953941 KB953941 December 5, 2008
• 951188 FIX: Error message when you connect to an instance of SQL Server 2005 by using a login for which you create a logon trigger: "The server failed to resume the transaction" Q951188 KB951188 November 19, 2008
• 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 or after you install SQL Server 2008 Q945127 KB945127 November 18, 2008
• 951093 FIX: Error message when you change the user access option of a database from restricted-user mode to multiple-user mode in SQL Server 2005: "Lock request time out period exceeded" Q951093 KB951093 October 29, 2008
• 956036 FIX: Error message when you process a partition from SQL Server 2005 Analysis Services Cumulative Update 7 or from the release version of SQL Server 2008 Analysis Services: "Detected inconsistency between User define slice and detected slice of partition" Q956036 KB956036 October 28, 2008
• 958548 FIX&#58; A query that performs multiple Clustered Index Seek operations or RID Lookup operations fails with an assertion in SQL Server 2005 Q958548 KB958548 October 20, 2008
• 957756 FIX&#58; An access violation occurs when you display the execution plan for a query that selects a computed column from a remote table in SQL Server 2005 Q957756 KB957756 October 20, 2008
• 956387 FIX&#58; Error message when you query the attribute members of a parent&#47;child dimension in SQL Server 2005 Analysis Services&#58; &#34;Either you do not have permission to access the specified member, or the specified member does not exist&#34; Q956387 KB956387 October 20, 2008
• 955971 FIX&#58; Error message when you run a query in SQL Server 2005 by using a linked server to SQL Server 2000 after you change the login password&#58; &#34;Communication link failure&#34; Q955971 KB955971 October 20, 2008
• 940545 FIX: The performance of INSERT operations against a table that contains an identity column may be slow in SQL Server 2005 Q940545 KB940545 October 17, 2008
• 957399 FIX&#58; When you specify cell permissions for a role in SQL Server 2005 Analysis Services Service Pack 2, the execution time for MDX queries is much longer than in SQL Server 2005 Analysis Services Service Pack 1 Q957399 KB957399 September 26, 2008
• 956039 FIX: Error message when you run an MDX query that uses the CREATE GLOBAL CUBE statement to create a local cube in SQL Server 2008 Analysis Services or in SQL Server 2005 Analysis Services: "The syntax for '<MDXFunctionName>' is incorrect" Q956039 KB956039 September 19, 2008
• 955975 FIX: Error message when you update a table at the subscriber in a transactional replication in SQL Server 2008: "Updateable Subscriptions: Rows do not match between Publisher and Subscriber" Q955975 KB955975 September 19, 2008
• 955958 FIX: No rows are returned when you use the sp_replqueuemonitor stored procedure to list the queued messages for a queue-updating subscription in SQL Server Q955958 KB955958 September 19, 2008
• 955896 FIX: You cannot edit a component that has multiple inputs in a SQL Server 2008 or SQL Server 2005 Integration Services package Q955896 KB955896 September 19, 2008
• 955372 FIX: An incorrect aggregate value is returned when you run an MDX query against a parent/child dimension that has the HideMemberIf property set to ParentIsBlankSelfOrMissing in SQL Server 2008 or in SQL Server 2005 Q955372 KB955372 September 19, 2008
• 954831 FIX: In SQL Server 2008 or in SQL Server 2005, the session that runs the TRUNCATE TABLE statement may stop responding, and you cannot end the session Q954831 KB954831 September 19, 2008
• 955686 FIX: Error message when you open a cursor for a very long cursor statement in SQL Server 2005: "Attempt to access expired blob handle" Q955686 KB955686 September 10, 2008
• 956274 FIX: Distribution Agent does not retry a command if an error occurs while Distribution Agent is running the command in a transactional replication of SQL Server 2005 Q956274 KB956274 August 26, 2008
• 955754 FIX: A deadlock occurs when you implement DDL statements against the partitions that are defined in a partitioned table in SQL Server 2005 Q955754 KB955754 August 26, 2008
• 956375 FIX: CPU utilization increases and throughput decreases when you run a heavy OLTP workload on an instance of SQL Server 2005 on a computer that has more than 32 processors Q956375 KB956375 August 25, 2008
• 940942 FIX: Error message when you run a stored procedure that references tables after you upgrade a database from SQL Server 2000 to SQL Server 2005: "A time-out occurred while waiting for buffer latch" Q940942 KB940942 August 19, 2008
• 956380 FIX: Error message when you process or deploy a cube that contains a calculation that references calculated members from a named set in SQL Server 2005 Analysis Services: "A set has been encountered that cannot contain calculated members" Q956380 KB956380 August 18, 2008
• 956273 FIX: Error message when you synchronize data for a transactional replication in SQL Server 2005: "Replication-Replication Transaction-Log Reader Subsystem: agent <AgentName> failed" Q956273 KB956273 August 18, 2008
• 956006 FIX: An access violation occurs when you run a query that uses the UNION operator to combine the results of three or more tables in SQL Server 2005 Q956006 KB956006 August 14, 2008
• 942906 FIX: When you run a stored procedure that uses some views in SQL Server 2005, the performance is slow compared to SQL Server 2000 if the views use the JOIN operator and contain subqueries Q942906 KB942906 August 8, 2008
• 954054 FIX: Some changes are not replicated to the subscribers when you synchronize data for a transactional replication in SQL Server 2005 Q954054 KB954054 July 18, 2008
• 953259 FIX: Error message when you run an SQL statement that uses the Charindex function in a database that uses the Czech locale in SQL Server 2005 Compact Edition: "The function is not recognized by SQL Server Compact Edition" Q953259 KB953259 July 17, 2008
• 954883 FIX&#58; Error message when SQL Server 2005 synchronizes a mirrored database&#58; &#34;Failed Assertion &#61; &#39;result &#61;&#61; LCK_OK&#39;&#34; Q954883 KB954883 July 14, 2008
• 954669 FIX: An ongoing MS DTC transaction is orphaned in SQL Server 2005 Q954669 KB954669 July 14, 2008
• 953950 FIX&#58; Error message when you run an INSERT statement in SQL Server 2005&#58; &#34;Cannot insert an explicit value into a timestamp column&#34; Q953950 KB953950 July 11, 2008
• 953853 FIX&#58; The Windows services may stop responding when the SQL Server WMI provider enumerates the Windows services on a local computer and the enumeration fails in SQL Server 2005 Q953853 KB953853 July 9, 2008
• 953550 FIX&#58; Error message when you run an MDX query in SQL Server 2005 Analysis Services&#58; &#34;The MDX function failed because the coordinate for the &#39;&#60;AttributeName&#62;&#39; attribute contains a set&#34; Q953550 KB953550 July 8, 2008
• 954734 FIX: Error message after you run the DBCC DBREINDEX Transact-SQL statement on a table that does not have a unique clustered index on a SQL Server 2005-based computer: "Msg 2511" Q954734 KB954734 July 3, 2008
• 953811 FIX: CPU utilization may be high when you configure more than one transactional replication on a computer that has multiple processors in SQL Server 2005 Q953811 KB953811 July 1, 2008
• 953627 FIX: When you update more than one row in a table that is joined to another table in SQL Server 2005, some rows are not added Q953627 KB953627 July 1, 2008
• 953970 FIX: SQL Server 2005 Express Edition cannot pass the Windows logo certification when you install an ISV application on a Windows Vista-based computer or on a Windows Server 2008-based computer Q953970 KB953970 June 30, 2008
• 953946 FIX: When you use SQL Native Client to retrieve data from a column of the sql_variant data type in SQL Server 2005, an incorrect data type is returned Q953946 KB953946 June 30, 2008
• 951194 FIX: The hatch patterns are not consistent for all the groups between the legend and the data in a chart in a SQL Server 2005 Reporting Services report Q951194 KB951194 June 26, 2008
• 951190 FIX: The transactional replication does not run the corresponding stored procedure at the subscriber when the stored procedure is run at the publisher in SQL Server 2005 Q951190 KB951190 June 26, 2008
• 953884 FIX: A query that joins two tables by using an equijoin on a computed column or on an expression may return incorrect results in SQL Server 2005 Q953884 KB953884 June 24, 2008
• 953626 FIX&#58; A full-text search query returns NULL when you run the query against a table that uses a collation of the traditional Chinese code page in SQL Server 2005 Q953626 KB953626 June 24, 2008
• 953854 FIX: Error message when you run a DELETE statement from a table that contains a nonclustered primary key in SQL Server 2005: "Internal Query Processor Error: The query processor could not produce a query plan" Q953854 KB953854 June 20, 2008
• 934246 FIX: Error message when you run a long stored procedure that is encrypted in SQL Server 2005: "A stack overflow occurred in the server while compiling the query" Q934246 KB934246 June 19, 2008
• 946032 FIX: A data source view that connects to an Oracle database generates incorrect relationships when you develop a Microsoft SQL Server 2005 Analysis Services project by using BIDS Q946032 KB946032 June 18, 2008
• 953625 FIX: Error message when SQL Server 2005 synchronizes a mirrored database: "Expression: result == LCK_OK" Q953625 KB953625 June 13, 2008
• 953497 FIX: Error message when you call a table valued function that uses a common language runtime (CLR) assembly in SQL Server 2005: "AppDomain <ApplicationDomain> is marked for unload due to memory pressure" Q953497 KB953497 June 13, 2008
• 953852 FIX: You cannot register a 64-bit local instance by clicking "Update Local Server Registration" in SQL Server Management Studio in SQL Server 2005 Q953852 KB953852 June 12, 2008
• 952624 FIX: Error message when you run a query that contains many OR clauses in SQL Server 2005: "There is insufficient system memory to run this query" Q952624 KB952624 June 12, 2008
• 953841 FIX: E-mail replies are sent to the sender address instead of to the address that is specified in the database mail profile in SQL Server 2005 after you install the .NET Framework 2.0 Service Pack 1 Q953841 KB953841 June 6, 2008
• 953548 FIX: An access violation occurs when you run two DMX queries against the same time series mining model at the same time in SQL Server 2005 Analysis Services Q953548 KB953548 June 6, 2008
• 933266 FIX: Error message when you run an MDX query by using the ADOMD.NET data provider in SQL Server 2005 Analysis Services: "Input string was not in a correct format" Q933266 KB933266 June 6, 2008
• 953116 FIX: In SQL Server 2005, no databases are selected in the Database(s) list in the "Back Up Database Task" dialog box after you install critical update 933508 Q953116 KB953116 June 5, 2008
• 953552 FIX: Error message when you run an UPDATE CUBE statement against a write-enabled cube in SQL Server 2005 Analysis Services: "Errors in the high-level relational engine" Q953552 KB953552 June 3, 2008
• 953491 FIX: Duplicate data is written to other flat files in an SSIS package that contains a Foreach Loop container Q953491 KB953491 June 3, 2008
• 953321 FIX: Error message when you restart the SQL Server service or the SQL Server Agent service in SQL Server 2005: "Unable to start mail session" Q953321 KB953321 June 3, 2008
• 952330 FIX: The Replication Log Reader Agent may fail intermittently when a transactional replication synchronizes data in SQL Server 2005 Q952330 KB952330 June 3, 2008
• 950467 FIX: An access violation may occur when you use a linked server to run a SELECT statement in SQL Server 2005 Q950467 KB950467 June 3, 2008
• 942980 FIX: Error message when you install the release version of SQL Server 2005 on a server that has Windows Internal Database SP2 installed: "The SQL Server service failed to start" Q942980 KB942980 May 29, 2008
• 952723 FIX: Error message when you use the bcp utility to run the sp_send_dbmail stored procedure in SQL Server 2005 Service Pack 2 Cumulative Update 5: "Error = [Microsoft][SQL Native Client]Function sequence error" Q952723 KB952723 May 23, 2008
• 952233 FIX: All the MDX queries that are running on an instance of SQL Server 2005 Analysis Services are canceled when you start or stop a SQL Server Profiler trace for the instance Q952233 KB952233 May 23, 2008
• 952135 FIX: When you connect to an instance of SQL Server 2005 by using the SQL Native Client ODBC driver, the SQL_PARAM_IGNORE setting has no effect Q952135 KB952135 May 23, 2008
• 952070 FIX: You cannot receive notification messages from all the existing subscriptions after you restart the SQL Server service in SQL Server 2005 Q952070 KB952070 May 23, 2008
• 951204 FIX: An access violation occurs when you update a table through a view by using a cursor in SQL Server 2005 Q951204 KB951204 May 21, 2008
• 951189 FIX: The SQL Server 2005 service may stop responding when you run multiple instances of the bcp utility or you run many BULK INSERT statements at the same time Q951189 KB951189 May 6, 2008
• 951185 FIX: The update operation is performed on incorrect rows when you update a column of the VARCHAR data type on a remote table by using a linked server in SQL Server 2005 Q951185 KB951185 May 6, 2008
• 951120 FIX&#58; A peer-to-peer transactional replication does not replicate rows if you rebuild the index for a published table at the same time as you insert data to the published table in SQL Server 2005 Q951120 KB951120 May 6, 2008
• 951095 FIX: Error message when you display a SQL Server 2005 Reporting Services report in Internet Explorer: "Error: 'parentNode' is null or not an object" Q951095 KB951095 May 6, 2008
• 950926 FIX: The SQL Server service may stop responding when you run a query that contains many OR clauses in SQL Server 2005 Q950926 KB950926 May 6, 2008
• 950875 FIX: Error message when you use the BULK INSERT statement to import data of the timestamp data type in SQL Server 2005: "An invalid datetime value was encountered" Q950875 KB950875 May 6, 2008
• 950189 FIX: The SQLGetData function may return zero for the actual size of the data that is to be copied when you use the function to retrieve data for a binary column in SQL Server 2005 Q950189 KB950189 May 6, 2008
• 949854 FIX: A query may take more time to finish in SQL Server 2005 if the query uses an inner join to join a derived table that uses the DISTINCT keyword Q949854 KB949854 May 6, 2008
• 949687 FIX: Error message when you run a transaction from a remote server by using a linked server in SQL Server 2005: "This operation conflicts with another pending operation on this transaction" Q949687 KB949687 May 6, 2008
• 949199 FIX: Error message when you run queries on a database that has the SNAPSHOT isolation level enabled in SQL Server 2005: "Unable to deallocate a kept page" Q949199 KB949199 May 6, 2008
• 949040 FIX: The execution fails when you try to run a SQL Server 2005 Integration Services package that contains an Aggregate transformation Q949040 KB949040 May 6, 2008
• 948657 FIX: The %TEMP% folder is not cleaned up after you use database mail to send an e-mail message that has an attachment in SQL Server 2005 Q948657 KB948657 May 6, 2008
• 951932 FIX: Error message when you create a subscription in SQL Server 2005 Compact Edition to a merge publication on SQL Server 2000: "The table name is not valid. [Token line number (if known) = 1,Token line offset (if known) = 22,Table name = <TableName>]" Q951932 KB951932 May 5, 2008
• 950991 FIX: Error message when you run an MDX query after you synchronize a SQL Server 2005 Analysis Services database between two instances: &quot;Current session is no longer valid due to structural changes in the database&quot; Q950991 KB950991 April 29, 2008
• 949075 FIX&#58; An ongoing MS DTC transaction is orphaned in SQL Server 2005 Q949075 KB949075 April 29, 2008
• 950636 FIX: SQL Server 2005 is not installed on a Windows Web Server 2008-based system Q950636 KB950636 April 23, 2008
• 947486 FIX: Error message when you run a stored procedure that references a linked server that is linked to the local server itself in SQL Server 2005: "Transaction context in use by another session" Q947486 KB947486 April 21, 2008
• 947462 FIX: Error message when you start a database mirroring session in SQL Server 2005: "Communications to the remote server instance 'TCP://<ComputerName>:<PortNumber>' failed before database mirroring was fully started" Q947462 KB947462 April 21, 2008
• 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 Q946127 KB946127 April 21, 2008
• 946036 FIX: Error message when you run a maintenance plan that contains a Back Up Database task in SQL Server 2005: "Failed:(-1073548784) Executing the query 'BACKUP DATABASE" Q946036 KB946036 April 21, 2008
• 946020 FIX: Error message when you run a complex query after you install Cumulative Update 3 or Cumulative Update 4 for SQL Server 2005 Service Pack 2: "The query processor ran out of internal resources and could not produce a query plan" Q946020 KB946020 April 21, 2008
• 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" Q945907 KB945907 April 21, 2008
• 945892 FIX: Error message when you run a query against a view in SQL Server 2005: "An error occurred while executing batch" Q945892 KB945892 April 21, 2008
• 943655 FIX: Error messages when you run a SQL Server 2005 Integration Services package after you install Cumulative Update 2 for SQL Server 2005 Service Pack 2: "Data conversion failed" and "SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR" Q943655 KB943655 April 21, 2008
• 942660 FIX: Error message when you run the BULK INSERT statement in Microsoft SQL Server 2005: "The bulk load failed. The column is too long in the data file for row <n>, column <n>" Q942660 KB942660 April 21, 2008
• 935789 FIX: On a computer that is running SQL Server 2005 and that has multiple processors, you may receive incorrect results when you run a query that contains an inner join Q935789 KB935789 April 21, 2008
• 951187 FIX: Error message when you run an MDX query in SQL Server 2005 Analysis Service build 3200 or later versions: "Internal error: An unexpected exception occured" Q951187 KB951187 April 17, 2008
• 950969 FIX: An MDX query may return the incorrect result if the MDX query contains a calculated member that uses the Aggregate function on a named set in SQL Server 2005 Analysis Services Q950969 KB950969 April 17, 2008
• 950993 FIX: The SQL Server 2005 Analysis Services service stops intermittently when you run an MDX query Q950993 KB950993 April 15, 2008
• 951075 FIX: An access violation may occur when you configure SQL Server 2005 Analysis Services to use query logging Q951075 KB951075 April 11, 2008
• 951001 FIX: An incorrect value is returned when you run an MDX query on a cube in SQL Server 2005 Analysis Services Q951001 KB951001 April 11, 2008
• 951073 FIX: A minidump file is generated in the SQL Server 2005 Analysis Services log folder when you run the ALTER XMLA command while an MDX query is running Q951073 KB951073 April 10, 2008
• 950968 FIX: Error message when you restore a database backup in SQL Server 2005 Analysis Services: "An error occurred when instantiating a metadata object from the file" Q950968 KB950968 April 10, 2008
• 950440 FIX: The application seems to stop responding when an application executes a large query that has parameters in predicates in SQL Server 2005 Compact Edition Q950440 KB950440 April 10, 2008
• 950992 FIX: Error message when you run an MDX query that uses the TopCount function in SQL Server 2005 Analysis Services: “File system error: The record ID is incorrect. Physical file: . Logical file: ” Q950992 KB950992 April 9, 2008
• 943281 FIX: Error message when you run the Merge Agent or Snapshot Agent for a merge publication in SQL Server 2005: "The Publisher failed to allocate a new set of identity ranges for the subscription" Q943281 KB943281 April 9, 2008
• 944929 FIX: The connection is closed or you receive an error message when you use SQL Native Client in SQL Server 2005 to obtain data that is stored in SQL Server 2008 collations Q944929 KB944929 April 2, 2008
• 811188 FIX: The merge replication agent stops responding when you perform merge replication between a SQL Server database and a SQL Server CE database, a SQL Server 2005 Compact Edition database, or a SQL Server 2005 Mobile Edition database Q811188 KB811188 March 27, 2008
• 944682 FIX: No results are returned when you run a stored procedure in Server Explorer in Business Intelligence Development Studio if the stored procedure returns a column of the uniqueidentifier data type in SQL Server 2005 Q944682 KB944682 March 26, 2008
• 947002 FIX: Error message when you try to delete the rows from the table in SQL Server 2005 Compact Edition or in SQL Server Compact 3.5: "Major Error 0x80004005, Minor Error 0. Attempted to divide by zero" Q947002 KB947002 March 24, 2008
• 948367 FIX: A query may return an incorrect result when the query contains a subquery and performs a Sort operation in SQL Server 2005 Q948367 KB948367 March 21, 2008
• 949631 FIX: Error message when you try to create a currency conversion against an Oracle data source in SQL Server 2005 Analysis Services: "The following statement executed when creating named query: SELECT 'Reporting Currency'" Q949631 KB949631 March 20, 2008
• 949959 FIX: Error message when you synchronize the data of a merge replication in SQL Server 2005: "The merge process is retrying a failed operation made to article 'ArticleName' - Reason: 'Invalid input parameter values. Check the status values for detail.'" Q949959 KB949959 March 19, 2008
• 949595 FIX: Error message when you run a query that uses a join condition in SQL Server 2005: "Non-yielding Scheduler" Q949595 KB949595 March 18, 2008
• 940379 FIX: Error message when you back up a database to a tape device in Microsoft SQL Server 2005 SP2: "Operation on device 'TAPE0(\\.\Tape0)' exceeded retry count" or "BackupTapeFile::UnloadTape: PrepareTape failure on backup device '\\.\Tape0'" Q940379 KB940379 March 11, 2008
• 949121 FIX: Internal parameter unexpectedly appears when you subscribe to a report that was deployed to a report server that runs in the SharePoint integrated mode Q949121 KB949121 March 5, 2008
• 949108 FIX: Additional rows are deleted at the publisher in a merge replication if the merge replication contains join filters in SQL Server 2005 Q949108 KB949108 March 5, 2008
• 944358 FIX: Complex script characters appear incorrectly when you display a SQL Server 2005 Reporting Services report in the PDF format Q944358 KB944358 March 4, 2008
• 942907 FIX&#58; The Wmiprvse.exe host process may stop unexpectedly when you run an application that uses the WMI provider to monitor an instance of SQL Server 2005 Q942907 KB942907 March 3, 2008
• 949116 FIX: Error message when you restore some databases from some backup files in SQL Server 2005 Analysis Services: “XML parsing failed at line 1, column 64914: '>' expected” Q949116 KB949116 February 29, 2008
• 948464 FIX: Some data on the publication may be lost when you set the @use_partition_groups parameter to false and you create subset filters and join filters for the tables in the publication in SQL Server 2005 Q948464 KB948464 February 27, 2008
• 949105 FIX: Error message when you run a query that uses the OUTER APPLY operator in SQL Server 2005: "An error occurred while executing batch. Error message is: Internal connection fatal error" Q949105 KB949105 February 26, 2008
• 948628 FIX: The columns of the XML data type are replicated as empty strings in a merge replication that uses a merge filter of the logical record relationship type in SQL Server 2005 Q948628 KB948628 February 26, 2008
• 947007 FIX: A report has a dual file name extension when you send the report though e-mail subscriptions in the Excel format or in the PDF format in the SQL Server 2005 Reporting Services SharePoint integrated mode Q947007 KB947007 February 26, 2008
• 942661 FIX: Error message in the SQL Server Errorlog file when you concurrently and repeatedly run stored procedures that create and delete many temporary tables or table variables in SQL Server 2005: "There is insufficient system memory to run this query" Q942661 KB942661 February 26, 2008
• 948920 FIX: Error message when you perform a processing operation or a query operation in SQL Server 2005 Analysis Services: "Error 0xC1020034. The following file is corrupted" Q948920 KB948920 February 20, 2008
• 948622 FIX: Error message when you run the sp_MSenum_distribution stored procedure for a transactional replication in SQL Server 2005 Q948622 KB948622 February 20, 2008
• 942908 FIX: The change may be undone during the later synchronizations when you change an article on the subscriber in SQL Server 2005 Q942908 KB942908 February 20, 2008
• 948754 FIX: Error message when you try to connect to a named instance of SQL Server 2005 Analysis Services: "The '<InstanceName>' instance was not found on the '<ServerName>' server" Q948754 KB948754 February 19, 2008
• 948248 FIX: A query performance issue occurs when you run a query against a column of the bigint data type in SQL Server 2005 Q948248 KB948248 February 19, 2008
• 945640 FIX: When you use the SUM function in a SCOPE statement in SQL Server 2005 Analysis Services, the SCOPE statement may return an incorrect result Q945640 KB945640 February 15, 2008
• 948445 FIX: A blocking issue occurs when you update rows in a table in SQL Server 2005 Q948445 KB948445 February 7, 2008
• 947414 FIX: The CONTEXT_INFO function returns the old value of the context information after you call a stored procedure that contains a TRY-CATCH block from a SQL Server CLR function Q947414 KB947414 February 5, 2008
• 946793 FIX: A query that you run by using a FORWARD_ONLY cursor takes a longer time to run in Microsoft SQL Server 2005 than in SQL Server 2000 Q946793 KB946793 February 5, 2008
• 318530 FIX: Reorder outer joins with filter criteria before non-selective joins and outer joins Q318530 KB318530 February 4, 2008
• 947008 FIX: A distribution database may grow continuously on one of the nodes when you configure a peer-to-peer transactional replication in SQL Server 2005 Service Pack 2 Q947008 KB947008 January 31, 2008
• 945909 FIX: The "SQLMoreResults" function returns incorrect results when you use it to retrieve a result set Q945909 KB945909 January 31, 2008
• 946022 FIX: Error message when you preview a SQL Server 2005 Reporting Services report that uses the Microsoft .NET Data Provider 1.0 for SAP NetWeaver Business Intelligence: "An error occurred during local report processing" Q946022 KB946022 January 22, 2008
• 945899 FIX: Incorrect data is inserted into a table when you run a 32-bit SQL Server 2005 Integration Services package on a 64-bit computer Q945899 KB945899 January 14, 2008
• 945916 FIX: Error messages when you delete some records of a table in a transaction or when you update some records of a table in a transaction in SQL Server 2005: "Msg 9002," "Msg 3314," and "Msg 9001" Q945916 KB945916 January 10, 2008
• 945864 FIX: Error message when a trigger that uses a cursor is fired in SQL Server 2005: "Could not complete cursor operation because the set options have changed since the cursor was declared" Q945864 KB945864 January 10, 2008
• 945903 FIX: The replication latency is high when you use transactional replication in a multiple-instance failover cluster environment of SQL Server 2005 Q945903 KB945903 January 9, 2008
• 945902 FIX: Error message when you run a query that uses query notification in SQL Server 2005: "Process <SPID> generated fatal exception c000001d EXCEPTION_ILLEGAL_INSTRUCTION. SQL Server is terminating this process" Q945902 KB945902 January 9, 2008
• 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 Q945897 KB945897 January 7, 2008
• 945901 FIX: A query that uses the FOR XML AUTO clause generates different results in SQL Server 2000 and in SQL Server 2005 Q945901 KB945901 January 3, 2008
• 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" Q945900 KB945900 January 3, 2008
• 942704 FIX: All later commands are ignored after the SQLDescribeParam function returns an error message in a SQL Server 2005-based application that uses the SQL Native Client ODBC provider Q942704 KB942704 January 2, 2008
• 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
• 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
• 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
• 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
• 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
• 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
• 945465 FIX: Error message when you synchronize the subscription of a transactional replication from SQL Server 2000 to SQL Server 2005: "Property AnsiNullsStatus is not available for UserDefinedFunction '<Function_Name>'" Q945465 KB945465 November 30, 2007
• 944678 FIX: SSIS stops responding when you run an SSIS package that uses a Flat File source in a Data Flow task after you install cumulative update package 2 for SQL Server 2005 Service Pack 2 Q944678 KB944678 November 30, 2007
• 944517 FIX: Error message when you create a WMI event alert by using the sp_add_alert stored procedure in SQL Server 2005: "The @wmi_query could not be executed in the @wmi_namespace provided" Q944517 KB944517 November 20, 2007
• 943284 FIX: Only the import operation of the first batch is minimally logged when you import the data in multiple batches in SQL Server 2005 Q943284 KB943284 November 20, 2007
• 943060 FIX: A query that has many outer joins takes a long time to compile in SQL Server 2005 Q943060 KB943060 November 20, 2007
• 942714 FIX: Error message when you use the "bcp_sendrow" function in a SQL Server 2005-based application that uses a SQL Native Client provider: "For BCP, all variable-length data must have either a length-prefix or a terminator specified" Q942714 KB942714 November 20, 2007
• 942668 FIX: High CPU usage occurs periodically on a subscriber when you synchronize a merge publication in SQL Server 2005 Q942668 KB942668 November 20, 2007
• 942656 FIX: Error message when you set up a snapshot publication on a database in SQL Server 2005: "Error 137, Must declare the scalar variable <VariableName>" Q942656 KB942656 November 20, 2007
• 942087 FIX: An access violation may occur intermittently in the DTSPipeline.dll file when you run an Integration Services package that contains a Data Flow task in SQL Server 2005 Q942087 KB942087 November 20, 2007
• 941689 FIX: You cannot connect to an instance of SQL Server 2005, and an error message is logged in the SQL Server error log Q941689 KB941689 November 20, 2007
• 941539 FIX: SQL Server 2005 may send error information for the same problem many times when a fatal error occurs Q941539 KB941539 November 20, 2007
• 940941 FIX: Some events are not logged correctly when you enable SQL Server event forwarding on a SQL Server Agent of SQL Server 2000 to forward events to SQL Server 2005 Q940941 KB940941 November 20, 2007
• 940933 FIX: Some changes from subscribers who use SQL Server 2005 Compact Edition or Web synchronization are not uploaded to the publisher when you use the republishing model in a merge publication in Microsoft SQL Server 2005 Q940933 KB940933 November 20, 2007
• 938825 FIX: A foreign key constraint that you drop on a table at the publisher is not dropped on the table at the subscriber in a SQL Server 2005 merge replication Q938825 KB938825 November 20, 2007
• 938050 FIX: Error message when you try to synchronize a SQL Server 2005 Compact Edition subscription again: "The common generation watermark is invalid at this replica since it does not exist" Q938050 KB938050 November 20, 2007
• 936894 FIX: Indexes that are rebuilt after you run a maintenance plan that contains the Rebuild Index task have the same Ignore Duplicate Key setting as the Ignore Duplicate Key setting of the Rebuild Index task Q936894 KB936894 November 20, 2007
• 934812 FIX: You cannot bring the SQL Server group online in a cluster environment after you rename the virtual server name of the default instance of SQL Server 2005 Q934812 KB934812 November 20, 2007
• 932557 FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 1399 Q932557 KB932557 November 20, 2007
• 928319 FIX: Error message when you run a .NET Framework 1.0 or .NET Framework 1.1 application on a computer that has SQL Server 2005 installed Q928319 KB928319 November 20, 2007
• 926613 FIX: You may receive inconsistent results when you query a table that is published in a transactional replication in SQL Server 2005 Q926613 KB926613 November 20, 2007
• 926106 FIX: You receive an error message when you use the Print Preview option on a large report in SQL Server 2005 Reporting Services Q926106 KB926106 November 20, 2007
• 329526 File allocation extension in SQL Server 2000 (64-bit) and SQL Server 2005 Q329526 KB329526 November 20, 2007
• 936262 FIX: When you run an MDX query for the second time, the query does not run faster than the first time that you ran the query in SQL Server 2005 Analysis Services Q936262 KB936262 November 16, 2007
• 942904 FIX: Error message when you run the DBCC CHECKTABLE statement or the DBCC CHECKDB statement in Microsoft SQL Server 2005: "Column '<ColumnName>' value is out of range for data type 'float'" Q942904 KB942904 November 14, 2007
• 942662 FIX: Message when you click the Back button in Internet Explorer 7 to return to a SQL Server 2005 Reporting Services report that contains one or more DateTime parameters: "Report is being generated" Q942662 KB942662 November 13, 2007
• 935831 FIX: The operation takes a long time to be completed when you process a partition that has proactive caching enabled in SQL Server 2005 Analysis Services Q935831 KB935831 November 8, 2007
• 936487 FIX: Managed applications that use SQL Server 2005 Compact Edition 3.1 may stop unexpectedly on Windows Mobile 5.0 ARMV4i-compatible devices if the location of the SQL Server Compact Edition DLLs changes Q936487 KB936487 November 4, 2007
• 932106 FIX: Error message when you run a DMX query that uses a linked server to query data from a Microsoft SQL Server 2005 Analysis Services server: "The following system error occurred: Logon failure: unknown user name or bad password" Q932106 KB932106 November 4, 2007
• 925843 FIX: Error message when you use the SQL Server Native Client provider to run queries between two linked servers in SQL Server 2005 Service Pack 1: "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'" Q925843 KB925843 November 4, 2007
• 940387 FIX: The direction of the string in a text box is incorrect when you open a SQL Server 2005 Reporting Services report in Internet Explorer 7 Q940387 KB940387 October 31, 2007
• 942665 FIX: You cannot run some SQL Server 2005 Integration Services packages in Business Intelligence Development Studio if you also run the same packages by using the Dtexec.exe utility Q942665 KB942665 October 26, 2007
• 942905 FIX: Error message when you run a DML statement against a table in a SQL Server 2005 Integration Services package: "Msg 6549, Level 16, State 1, Procedure sp_FuzzyLookupTableMaintenanceInvoke, Line 0" Q942905 KB942905 October 22, 2007
• 941989 FIX: Error message when you synchronize a merge replication in a replication topology that contains two or more re-publishers in SQL Server 2005: "21997 Failed to allocate new identity range" Q941989 KB941989 October 22, 2007
• 942664 FIX: Error message when you try to build or to deploy a report server project of SQL Server 2005 Reporting Services: "This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms" Q942664 KB942664 October 19, 2007
• 942659 FIX: The query performance is slower when you run the query in SQL Server 2005 than when you run the query in SQL Server 2000 Q942659 KB942659 October 19, 2007
• 941695 FIX: After you enable the Address Windowing Extensions (AWE) feature in SQL Server 2005, access violations may occur, and SQL Server 2005 may stop responding Q941695 KB941695 October 19, 2007
• 941233 FIX: Error message when you use the SQL Server Native Client OLE DB provider to connect to an instance of SQL Server 2005: "Conversions not allowed using bcp_moretext" Q941233 KB941233 October 15, 2007
• 940870 FIX: Error message when you process the index for a partition in a cube in SQL Server 2005 Analysis Services: “Internal error: An unexpected error occurred (file 'pffilestore.cpp', line 3311, function 'PFFileStore::HandleDataPageFault')” Q940870 KB940870 October 15, 2007
• 941792 FIX: The content of a group is displayed incorrectly when you change a parameter and then you click a toggle image in SQL Server 2005 Reporting Services Q941792 KB941792 October 12, 2007
• 938786 FIX: A .NET Compact Framework 2.0-based device application that calls the SqlCeEngine.Verify method against a SQL Server 2005 Compact Edition database stops responding Q938786 KB938786 October 12, 2007
• 937792 FIX: The data mining model that you build by using the association algorithms contains only one rule in SQL Server 2005 Analysis Services Q937792 KB937792 October 12, 2007
• 942667 FIX: The Analysis Services service stops unexpectedly when you run a Multidimensional Expressions query that uses unary operators on a dimension in SQL Server 2005 Analysis Services Q942667 KB942667 October 9, 2007
• 942654 FIX: A Multidimensional Expressions query that contains a FILTER function returns an incorrect result in SQL Server 2005 Analysis Services Q942654 KB942654 October 9, 2007
• 938916 FIX: The status of the shared schedule appears as Paused after you click Resume when you use Report Manager in SQL Server 2005 Reporting Services SP2 Q938916 KB938916 October 6, 2007
• 942715 FIX: In Reporting Services together with SQL Server 2005 Service Pack 2, the "Save As Report" dialog box stops responding, or the "Open Report" dialog box stops responding in Report Builder Q942715 KB942715 October 3, 2007
• 941176 FIX: Error message when you run a query that references a column of the XML data type in SQL Server 2005: "The XML data type is damaged" Q941176 KB941176 October 3, 2007
• 941256 FIX: Error message when you run the CREATE ASSEMBLY statement to register a CLR assembly in SQL Server 2005: "An error occurred while gathering metadata from assembly '<AssemblyName>' with HRESULT 0x80131" Q941256 KB941256 October 1, 2007
• 940281 FIX: An access violation may occur, and you may receive an error message, when you query the sys.dm_exec_sessions dynamic management view in SQL Server 2005 Q940281 KB940281 September 10, 2007
• 941611 FIX: The performance of the MDX queries may be very slow when you run many MDX queries in SQL Server 2005 Analysis Services Q941611 KB941611 September 4, 2007
• 940389 FIX: Error message when you display a report that uses SAP Business Information Warehouse 3.5 as the data source in SQL Server 2005 Service Pack 2 Reporting Services: “Can't find object <Object ID>” Q940389 KB940389 August 31, 2007
• 941184 FIX: An application that is included in SQL Server 2005 may stop responding when you specify a network protocol that is not valid in the application Q941184 KB941184 August 30, 2007
• 940376 FIX: Error message when you use the Bcp.exe utility together with the queryout option in Microsoft SQL Server 2005: “BCP host-files must contain at least one column” Q940376 KB940376 August 30, 2007
• 940371 FIX: Error message when you run a query that selects many columns and that joins many tables in SQL Server 2005 Service Pack 2: "The query processor could not produce a query plan" Q940371 KB940371 August 30, 2007
• 940149 FIX: In SQL Server 2005 Service Pack 2, the toolbar of a Reporting Services report turns gray when you click "View Report" Q940149 KB940149 August 30, 2007
• 938363 FIX: Data is not replicated to a subscriber in a different partition by using parameterized row filters in SQL Server 2005 Q938363 KB938363 August 30, 2007
• 940943 FIX: The performance of a query that performs an insert operation or an update operation is much slower in SQL Server 2005 SP2 than in earlier versions of SQL Server 2005 Q940943 KB940943 August 29, 2007
• 940372 FIX: The performance of an MDX query that contains subselect queries and calculated members is much slower in SQL Server 2005 Analysis Services Service Pack 2 than in the earlier versions of SQL Server 2005 Analysis Services Q940372 KB940372 August 27, 2007
• 940378 FIX: A cursor uses the incorrect transaction isolation level after you change the transaction isolation level for the cursor in SQL Server 2005 Q940378 KB940378 August 24, 2007
• 940937 FIX: Error message when you try to update the index key columns of a non-unique clustered index in SQL Server 2005: "Cannot insert duplicate key row in object 'ObjectName' with unique index 'IndexName'" Q940937 KB940937 August 21, 2007
• 940375 FIX: Error message when you use the Copy Database Wizard to move a database from SQL Server 2000 to SQL Server 2005 Q940375 KB940375 August 20, 2007
• 937100 FIX: Error message when you run a SQL Server 2005 Integration Services package that contains a Script Component transformation:”Insufficient memory to continue the execution of the program” Q937100 KB937100 August 20, 2007
• 940935 FIX: Error message when you run a query that is associated with a parallel execution plan in SQL Server 2005: "SQL Server Assertion: File: <lckmgr.cpp>, line=10850 Failed Assertion = 'GetLocalLockPartition () == xactLockInfo->GetLocalLockPartition ()'" Q940935 KB940935 August 17, 2007
• 940223 FIX: Error message when you synchronize a subscription by using Windows Synchronization Manager in SQL Server 2005: "The merge process failed to get correct information about the Interactive Resolver component from the Registry" Q940223 KB940223 August 16, 2007
• 940220 FIX: Error message when you run a SQL Server 2005 Integration Services package that contains an FTP task: "An error occurred in the requested FTP operation" Q940220 KB940220 August 16, 2007
• 940370 FIX: The event information that is generated by a child package does not have a "User:" prefix in Integration Services in SQL Server 2005 Service Pack 2 Q940370 KB940370 August 15, 2007
• 285100 FIX: A SQL Server installation fails when Windows computer name is mixed or lowercase Q285100 KB285100 August 13, 2007
• 940160 FIX: Error message when you deploy a SQL Server 2005 Analysis Service project that contains many cubes, and the cubes contain linked measure groups: "Unexpected internal error" Q940160 KB940160 August 10, 2007
• 915189 FIX: Error message when you try to edit the connection manager for a migrated package in SQL Server 2005: "The specified provider is not supported" Q915189 KB915189 August 8, 2007
• 938671 FIX: The Distribution Agent may skip some rows when you configure a transactional replication that uses the "-SkipErrors" parameter in SQL Server 2005 Q938671 KB938671 August 1, 2007
• 938049 FIX: An SSIS package stops responding when you run the package and the package contains a data flow task that contains one or more MergeJoin transformations in SQL Server 2005 Q938049 KB938049 June 28, 2007
• 938087 FIX: You experience problems when you use SQL Server Business Intelligence Development Studio to create an SSIS package after you install SQL Server 2005 Service Pack 2 Q938087 KB938087 June 27, 2007
• 938077 FIX: The client application stops responding, and the Msmdsrv.exe process uses all the available memory after you perform the filtering operation and the browsing operation against an instance of SQL Server 2005 Analysis Services Q938077 KB938077 June 22, 2007
• 936253 FIX: Error messages are logged, and some threads may not sort the data successfully if many threads are displaying a report in SQL Server 2005 Reporting Services Q936253 KB936253 June 22, 2007
• 937149 FIX: Rows in a table are not aligned correctly in a SQL Server 2005 Reporting Services report when you view the deployed report in a browser Q937149 KB937149 June 21, 2007
• 936080 FIX: Some values of measures in a cube unexpectedly appear as "#N/A" when you enable the "Enable read-contingent permissions" option for the cube in SQL Server 2005 Analysis Services Service Pack 2 Q936080 KB936080 June 21, 2007
• 934434 FIX: You do not receive an error message when an error occurs while you use the dialog boxes of SQL Server 2005 Compact Edition Q934434 KB934434 April 6, 2007
• 933697 FIX: A SELECT query unexpectedly returns an incorrect number of rows in SQL Server 2005 Mobile Edition and in SQL Server 2005 Compact Edition Q933697 KB933697 March 13, 2007
• 910375 FIX: No table headers appear in the Excel report when you use SQL Server 2005 Reporting Services to export information to Excel Q910375 KB910375 June 1, 2006