SQL Server 2005 articles, fixes and updates

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.

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 *new
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 Q970823 KB970823 June 23, 2009
970058 FIX: Error message when you open a report by specifying multiple values for a multivalued parameter in a URL in SQL Server 2005 Reporting Services: "Default value or value provided for the report parameter '<Parameter>' is not a valid value" Q970058 KB970058 June 23, 2009
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 June 19, 2009
969844 FIX: You receive inconsistent results when you run index-related DMVs to return statistical information about missing indexes in SQL Server 2005 Q969844 KB969844 June 19, 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
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 June 16, 2009
971402 FIX: Error message when you send an e-mail by using a private Database Mail profile in SQL Server 2005: "profile name is not valid" Q971402 KB971402 June 16, 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 June 16, 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 Q970966 KB970966 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
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 Q970551 KB970551 June 16, 2009
970349 FIX: 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
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 June 16, 2009
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 June 16, 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 Q969528 KB969528 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
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 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
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 June 16, 2009
956574 FIX: Data results are inconsistent when you run a search query that uses the NEAR operator against an XML type data that contains the xml:lang attribute Q956574 KB956574 June 16, 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 Q948567 KB948567 June 16, 2009
969845 FIX: Error message when you run a SQL Server 2005 or SQL Server 2008 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 June 9, 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
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 May 18, 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
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 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
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 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
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 May 14, 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
941105 FIX: Error messages after SQL Server 2005 or SQL Server 2000 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 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
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 May 6, 2009
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 April 28, 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 23, 2009
910070 FIX: The SQL Server 2005 Setup program may take much longer than expected to finish running Q910070 KB910070 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
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 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
968381 FIX: All records in the query log table are truncated when you synchronize a database in SQL Server 2005 Q968381 KB968381 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: 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
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 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
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 April 20, 2009
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 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
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 April 20, 2009
934749 FIX: Error message when you try to install SQL Server 2005 Service Pack 1 or SQL Server 2005 Service Pack 2 from the existing active node: "The product instance <InstanceName> has been patched with more recent updates" Q934749 KB934749 April 20, 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 16, 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 16, 2009
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 April 16, 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 16, 2009
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 April 16, 2009
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 April 16, 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 April 15, 2009
960543 FIX: SQL Server 2005 or SQL Server 2008 may stop responding when you are performing a backup Q960543 KB960543 April 10, 2009
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 8, 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
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 April 7, 2009
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 April 7, 2009
968398 FIX: 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
968171 FIX: Error message when you try to create an encrypted database of SQL Server 2005 Compact Edition: "The operating system does not support encryption" Q968171 KB968171 April 2, 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
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 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
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 13, 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 17, 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
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 17, 2009
961479 FIX: An unresolved deadlock occurs when you perform an online reindex operation that runs on parallel threads in SQL Server 2005 Q961479 KB961479 February 17, 2009
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 February 17, 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 17, 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 17, 2009
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 February 12, 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
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 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
959012 FIX: When you shrink a database that has the SNAPSHOT transaction isolation level enabled in SQL Server 2005, the shrink operation is not completed successfully Q959012 KB959012 January 6, 2009
960611 FIX: An incorrect result is returned when you run a Multidimensional Expressions (MDX) query in Microsoft SQL Server 2005 Analysis Services Q960611 KB960611 December 29, 2008
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 December 29, 2008
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
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 20, 2008
960559 FIX: Error message when you visit an ASP page that connects to an instance of SQL Server 2005 Analysis Services by using the MSOLAP90 provider: "The system cannot find the file specified" Q960559 KB960559 December 20, 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 20, 2008
960545 FIX: Error message when you run an MDX query in SQL Server 2005 Analysis Services: "An unexpected error occurred (file 'mdpropertyset.cpp', line 1032, function 'MDRangePropertySet::Init'" 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
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 20, 2008
959032 FIX: 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 in the published table in SQL Server 2005 or in SQL Server 2008 Q959032 KB959032 December 20, 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 20, 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 20, 2008
958684 FIX: Log Reader Agent fails with error code 18834 in SQL Server 2005 Q958684 KB958684 December 20, 2008
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 December 20, 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 20, 2008
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 December 20, 2008
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 December 20, 2008
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 December 20, 2008
958006 FIX: The size of the SQL Server 2005 error log file or of the SQL Server 2008 error log file grows very quickly when query notifications are created and destroyed in a high ratio Q958006 KB958006 December 20, 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 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
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 20, 2008
956686 FIX: When you run a query that contains a JOIN operation in SQL Server 2005, 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
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 December 20, 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
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 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 16, 2008
959023 FIX: A blocking issue occurs when you run the Merge Agent in SQL Server 2005 Q959023 KB959023 December 16, 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 16, 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 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
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 16, 2008
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 December 16, 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 16, 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 16, 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 16, 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 16, 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 16, 2008
959006 FIX: Database mirroring sessions may stop intermittently in SQL Server 2005 Q959006 KB959006 December 16, 2008
959004 FIX: 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
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 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
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 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
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
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: 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: 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: Error message when you query the attribute members of a parent/child dimension in SQL Server 2005 Analysis Services: "Either you do not have permission to access the specified member, or the specified member does not exist" Q956387 KB956387 October 20, 2008
955971 FIX: 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: "Communication link failure" 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
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 October 16, 2008
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 15, 2008
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 October 15, 2008
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 October 15, 2008
957399 FIX: 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
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 September 19, 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
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 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
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 September 10, 2008
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 September 10, 2008
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 August 29, 2008
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 August 27, 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
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 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
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 August 18, 2008
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 mode" Q956381 KB956381 August 18, 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
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 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
955695 FIX: When you run a Transact-SQL script in a step of a SQL Server Agent job in SQL Server 2005, the result of the Transact-SQL script may be truncated Q955695 KB955695 August 18, 2008
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 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
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 July 14, 2008
954883 FIX: Error message when SQL Server 2005 synchronizes a mirrored database: "Failed Assertion = 'result == LCK_OK'" Q954883 KB954883 July 14, 2008
954669 FIX: An ongoing MS DTC transaction is orphaned in SQL Server 2005 Q954669 KB954669 July 14, 2008
953568 FIX: The synchronization operation of a merge replication times out in Microsoft SQL Server 2005 Q953568 KB953568 July 14, 2008
953950 FIX: Error message when you run an INSERT statement in SQL Server 2005: "Cannot insert an explicit value into a timestamp column" Q953950 KB953950 July 11, 2008
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 July 11, 2008
953853 FIX: 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: Error message when you run an MDX query in SQL Server 2005 Analysis Services: "The MDX function failed because the coordinate for the '<AttributeName>' attribute contains a set" 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
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 June 24, 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: 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
953496 FIX: CPU utilization is high when you run a trace that contains a text filter in SQL Server 2005 Q953496 KB953496 June 16, 2008
953721 FIX: The performance of a query in SQL Server 2005 Service Pack 2 Cumulative Update 6 is slow Q953721 KB953721 June 13, 2008
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 June 13, 2008
953625 FIX: Error message when SQL Server 2005 synchronizes a mirrored database: "Expression: result == LCK_OK" Q953625 KB953625 June 13, 2008
953569 FIX: The compilation time of some queries is very long in an x64-based version of SQL Server 2005 Q953569 KB953569 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
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 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
953553 FIX: An access violation occurs when you run an XMLA query in SQL Server 2005 Analysis Services Q953553 KB953553 June 3, 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
953547 FIX: A time series prediction query takes a long time to run in SQL Server 2005 Analysis Services Q953547 KB953547 June 2, 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
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 May 20, 2008
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 May 14, 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
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 May 6, 2008
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 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
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 May 6, 2008
951120 FIX: 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
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 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
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 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
950467 FIX: An access violation may occur when you use a linked server to run a SELECT statement in SQL Server 2005 Q950467 KB950467 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
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 May 6, 2008
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 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
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 April 30, 2008
950991 FIX: Error message when you run an MDX query after you synchronize a SQL Server 2005 Analysis Services database between two instances: "Current session is no longer valid due to structural changes in the database" Q950991 KB950991 April 29, 2008
949075 FIX: An ongoing MS DTC transaction is orphaned in SQL Server 2005 Q949075 KB949075 April 29, 2008
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 April 28, 2008
950636 FIX: SQL Server 2005 is not installed on a Windows Web Server 2008-based system Q950636 KB950636 April 23, 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
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 April 14, 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
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 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
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 April 8, 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
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 March 12, 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
949200 FIX: SQL Server 2005 requests columns that you do not expect when you run a SELECT statement Q949200 KB949200 March 10, 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 March 10, 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: 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
945892 FIX: Error message when you run a query against a view in SQL Server 2005: "An error occurred while executing batch" Q945892 KB945892 February 28, 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
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 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
948578 FIX: Some changes are not synchronized between subscribers of a merge publication in SQL Server 2005 Q948578 KB948578 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
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 February 20, 2008
947179 FIX: An MDX query that uses the VisualTotals function returns an incorrect empty value in SQL Server 2005 Analysis Services Q947179 KB947179 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
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 February 19, 2008
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 February 18, 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
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 February 7, 2008
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 February 7, 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
947463 FIX: A stored procedure cannot finish its execution in SQL Server 2005 Q947463 KB947463 February 4, 2008
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 February 4, 2008
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 Workgroup edition" Q935922 KB935922 February 4, 2008
318530 FIX: Reorder outer joins with filter criteria before non-selective joins and outer joins Q318530 KB318530 February 4, 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 February 2, 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 February 1, 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
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 28, 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
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 January 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 January 21, 2008
937343 FIX: SQL Server 2005 stops and then restarts unexpectedly, and errors occur in the tempdb database Q937343 KB937343 January 16, 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
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 January 11, 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
928537 FIX: The full-text index population for the indexed view is very slow in SQL Server 2005 Q928537 KB928537 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
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 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
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 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
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 December 20, 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
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 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
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 December 13, 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
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 December 11, 2007
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 December 11, 2007
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 December 11, 2007
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 December 11, 2007
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 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
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 December 3, 2007
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 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
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 November 30, 2007
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 November 27, 2007
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 November 26, 2007
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 November 22, 2007
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 November 21, 2007
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 November 21, 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
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 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
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 Q942712 KB942712 November 20, 2007
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 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
942444 FIX: A query that involves an outer join operation runs very slowly in Microsoft SQL Server 2005 Q942444 KB942444 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
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 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
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 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
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 November 20, 2007
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 November 20, 2007
940286 FIX: A Service Broker endpoint stops passing messages in a database mirroring session of SQL Server 2005 Q940286 KB940286 November 20, 2007
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 November 20, 2007
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 November 20, 2007
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 November 20, 2007
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 November 20, 2007
938962 FIX: You may receive an access violation or error 942 when you drop a database in SQL Server 2005 Q938962 KB938962 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
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 November 20, 2007
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 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
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 November 20, 2007
937544 FIX: You may receive error 3456 when you try to restore a transaction log for a SQL Server 2005 database Q937544 KB937544 November 20, 2007
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 November 20, 2007
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 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
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 November 20, 2007
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 November 20, 2007
935446 FIX: You receive error messages when you use the BULK INSERT statement in SQL Server 2005 to import data in bulk Q935446 KB935446 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
934734 FIX: A database is marked as suspect when you update a table that contains a nonclustered index in SQL Server 2005 Q934734 KB934734 November 20, 2007
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 November 20, 2007
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 November 20, 2007
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 November 20, 2007
934106 FIX: SQL Server 2005 database engine generates failed assertion errors when you use the Replication Monitor to monitor the distribution database Q934106 KB934106 November 20, 2007
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 November 20, 2007
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 November 20, 2007
933831 FIX: A schema change that is made to a published table may not be propagated to subscriptions in SQL Server 2005 Q933831 KB933831 November 20, 2007
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 November 20, 2007
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 November 20, 2007
933762 FIX: You receive error 18815 when the Log Reader Agent runs for a transactional publication in SQL Server 2005 Q933762 KB933762 November 20, 2007
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 November 20, 2007
933564 FIX: A gradual increase in memory consumption for the USERSTORE_TOKENPERM cache store occurs in SQL Server 2005 Q933564 KB933564 November 20, 2007
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 November 20, 2007
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 November 20, 2007
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 November 20, 2007
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 November 20, 2007
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 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
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 November 20, 2007
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 November 20, 2007
932393 FIX: You may experience poor performance after you install SQL Server 2005 Service Pack 1 Q932393 KB932393 November 20, 2007
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 November 20, 2007
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 November 20, 2007
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 November 20, 2007
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 November 20, 2007
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 November 20, 2007
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 November 20, 2007
930284 FIX: You receive error 1456 when you try to add a witness to a DBM session in SQL Server 2005 Q930284 KB930284 November 20, 2007
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 Q930283 KB930283 November 20, 2007
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 November 20, 2007
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 November 20, 2007
929278 FIX: SQL Server 2005 may not perform histogram amendments when you use trace flags 2389 and 2390 Q929278 KB929278 November 20, 2007
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 November 20, 2007
928792 FIX: The output rows of the Aggregate transformation are divided into multiple rows in SQL Server 2005 Integration Services Q928792 KB928792 November 20, 2007
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 November 20, 2007
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 November 20, 2007
928394 FIX: The changes are not reflected in the publication database after you reinitialize the subscriptions in SQL Server 2005 Q928394 KB928394 November 20, 2007
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 November 20, 2007
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, 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
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, 2007
927289 FIX: Updates to the SQL Server Mobile subscriber may not be reflected in the SQL Server 2005 merge publication Q927289 KB927289 November 20, 2007
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 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
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 November 20, 2007
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 November 20, 2007
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 November 20, 2007
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 November 20, 2007
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 November 20, 2007
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 November 20, 2007
926240 FIX: SQL Server 2005 may stop responding when you use the SqlBulkCopy class to import data from another data source Q926240 KB926240 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
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 November 20, 2007
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 November 20, 2007
925335 FIX: Error message when you use a label after a Transact-SQL query in SQL Server 2005: "Incorrect syntax near 'X'" Q925335 KB925335 November 20, 2007
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 November 20, 2007
925227 FIX: Error message when you call the SQLTables function against an instance of SQL Server 2005: "Invalid cursor state (0)" Q925227 KB925227 November 20, 2007
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 November 20, 2007
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 November 20, 2007
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 November 20, 2007
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 November 20, 2007
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 November 20, 2007
924807 FIX: The restore operation may take a long time to finish when you restore a database in SQL Server 2005 Q924807 KB924807 November 20, 2007
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 November 20, 2007
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 November 20, 2007
924346 FIX: An access violation may intermittently occur when you run a SQL Server Integration Services package in SQL Server 2005 Q924346 KB924346 November 20, 2007
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 November 20, 2007
923849 FIX: When you run a query that references a partitioned table in SQL Server 2005, query performance may decrease Q923849 KB923849 November 20, 2007
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 November 20, 2007
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 November 20, 2007
923473 FIX: SQL Server 2005 Analysis Services may stop responding when you try to process a ROLAP dimension two times Q923473 KB923473 November 20, 2007
923296 FIX: Log Reader Agent fails, and an assertion error message is logged when you use transactional replication in SQL Server 2005 Q923296 KB923296 November 20, 2007
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 November 20, 2007
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 November 20, 2007
922638 FIX: An EXCEPTION_STACK_OVERFLOW exception may occur when you try to run a Transact-SQL query in SQL Server 2005 Q922638 KB922638 November 20, 2007
922594 FIX: Error message when you use SQL Server 2005: "High priority system task thread Operating system error Exception 0xAE encountered" Q922594 KB922594 November 20, 2007
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 November 20, 2007
922578 FIX: Lots of messages that have message ID 19030 and message ID 19031 are logged in the SQL Server 2005 Errorlog file when you use SQL Server Profile in SQL Server 2005 Q922578 KB922578 November 20, 2007
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 November 20, 2007
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 November 20, 2007
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 November 20, 2007
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 November 20, 2007
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 November 20, 2007
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 November 20, 2007
921106 FIX: You receive an error message when you try to create a differential database backup in SQL Server 2005 Q921106 KB921106 November 20, 2007
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 November 20, 2007
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 November 20, 2007
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 November 20, 2007
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 November 20, 2007
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 November 20, 2007
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 November 20, 2007
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 November 20, 2007
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 November 20, 2007
919949 FIX: The sp_MSinitDynamicSubscriber stored procedure is called more than one time by using the same parameters in SQL Server 2005 Q919949 KB919949 November 20, 2007
919929 FIX: Error message when the Replication Merge Agent runs in SQL Server 2005: "Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199402" Q919929 KB919929 November 20, 2007
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 November 20, 2007
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 November 20, 2007
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 November 20, 2007
919636 FIX: Memory usage of the compiled query plan may unexpectedly increase in SQL Server 2005 Q919636 KB919636 November 20, 2007
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 November 20, 2007
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 November 20, 2007
919193 FIX: A forward-only cursor may be implicitly converted to a keyset cursor in SQL Server 2005 Q919193 KB919193 November 20, 2007
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 November 20, 2007
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 November 20, 2007
918882 FIX: A query plan is not cached in SQL Server 2005 when the text of the hint is a large object Q918882 KB918882 November 20, 2007
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 November 20, 2007
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 November 20, 2007
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 November 20, 2007
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 November 20, 2007
918091 FIX: You may receive an error message when you try to run an SSIS package in SQL Server 2005 Q918091 KB918091 November 20, 2007
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 November 20, 2007
917905 FIX: SQL Server 2005 performance may be slower than SQL Server 2000 performance when you use an API server cursor Q917905 KB917905 November 20, 2007
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 November 20, 2007
917887 FIX: The value of the automatic growth increment of a database file may be very large in SQL Server 2005 Q917887 KB917887 November 20, 2007
917872 FIX: Error message when you try to connect to SQL Server 2005 Analysis Services from Object Explorer: "System.OutOfMemoryException" Q917872 KB917872 November 20, 2007
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 November 20, 2007
917738 FIX: SQL Server 2005 system performance may be slow when you use a keyset-driven cursor to execute a FETCH statement Q917738 KB917738 November 20, 2007
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 November 20, 2007
917035 FIX: Query performance may decrease after SQL Server 2005 has been running for a while Q917035 KB917035 November 20, 2007
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 November 20, 2007
916795 FIX: Error message when you run a query inside a stored procedure in SQL Server 2005: "Internal query processor error" Q916795 KB916795 November 20, 2007
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 November 20, 2007
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 November 20, 2007
915918 FIX: The internal deadlock monitor may not detect a deadlock between two or more sessions in SQL Server 2005 Q915918 KB915918 November 20, 2007
915763 FIX: The Permissions column for the Audit Schema Object Access event does not populate in SQL Server 2005 Q915763 KB915763 November 20, 2007
915308 FIX: The CPU usage of the server reaches 100% when many DML activities occur in SQL Server 2005 Q915308 KB915308 November 20, 2007
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 November 20, 2007
914233 FIX: SQL Server 2005 Analysis Services may close unexpectedly when you create and then delete a subcube in the same session Q914233 KB914233 November 20, 2007
914019 FIX: Problems may occur when you use the SQLdiag utility in SQL Server 2005 Q914019 KB914019 November 20, 2007
913941 FIX: A SQL Server login may have more permissions when you log on to an instance of SQL Server 2005 Q913941 KB913941 November 20, 2007
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 November 20, 2007
913849 FIX: No result set is returned when you run an MDX query that uses an unnatural hierarchy in SQL Server 2005 Q913849 KB913849 November 20, 2007
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 November 20, 2007
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 November 20, 2007
912885 FIX: You may receive an access violation error message when you run a parallel execution plan in SQL Server 2005 Q912885 KB912885 November 20, 2007
912702 FIX: Error message when you run an MDX query in SQL Server 2005 Analysis Services: "Dimension attribute was not found" Q912702 KB912702 November 20, 2007
912423 FIX: Memory leaks occur when you use Fuzzy Lookup and Fuzzy Grouping to transform a SQL Server 2005 Integration Services package Q912423 KB912423 November 20, 2007
911912 FIX: You experience low CPU spikes at set intervals even when there is no user activity in SQL Server 2005 Q911912 KB911912 November 20, 2007
911662 FIX: You may receive an access violation error message when you run a SELECT query in SQL Server 2005 Q911662 KB911662 November 20, 2007
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 November 20, 2007
329526 File allocation extension in SQL Server 2000 (64-bit) and SQL Server 2005 Q329526 KB329526 November 20, 2007
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 November 19, 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
908915 FIX: You receive an error message when you use Microsoft OLE DB Provider for Visual FoxPro in SQL Server Q908915 KB908915 November 15, 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
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
936697 FIX: The getTime method returns an incorrect date in the SQL Server 2005 JDBC Driver 1.1 Q936697 KB936697 November 4, 2007
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 November 4, 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
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 November 4, 2007
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 November 4, 2007
935832 FIX: You cannot cancel an MDX query that runs for a long time in SQL Server 2005 Analysis Services Q935832 KB935832 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
933549 FIX: You may receive an access violation when you perform a bulk copy operation in SQL Server 2005 Q933549 KB933549 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 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
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
929179 FIX: A memory leak may occur every time that you synchronize a SQL Server Mobile subscriber in SQL Server 2005 Q929179 KB929179 November 4, 2007
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 November 4, 2007
928243 FIX: When you run a SQL Server 2005 Integration Services package, the package may stop responding Q928243 KB928243 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
927179 FIX: Processing is never completed and cannot be stopped when you process a cube in SQL Server 2005 Analysis Services Q927179 KB927179 November 4, 2007
927109 FIX: Many query notifications are sent to the data warehouse when proactive caching is enabled in SQL Server 2005 Analysis Services Q927109 KB927109 November 4, 2007
926967 FIX: You obtain an incorrect result when you run a Multidimensional Expressions (MDX) query in SQL Server 2005 Service Pack 1 Q926967 KB926967 November 4, 2007
926962 FIX: The user can see all the data in a cube, and SQL Server 2005 Analysis Services may crash Q926962 KB926962 November 4, 2007
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 November 4, 2007
926515 FIX: You may receive unexpected results when you run an MDX query in SQL Server 2005 Analysis Services Q926515 KB926515 November 4, 2007
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 November 4, 2007
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 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
925058 FIX: Error message when you create a new subscription to a report in SQL Server 2005 Reporting Services: "Error: Object expected" Q925058 KB925058 November 4, 2007
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 November 4, 2007
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 November 4, 2007
924811 FIX: You cannot use SQL Server 2005 Mobile Edition on Windows CE .NET 4.2-based devices Q924811 KB924811 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
920116 FIX: A SELECT query that uses the LIKE clause may return incorrect results in SQL Server 2005 Compact Edition Q920116 KB920116 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
919150 FIX: Error message when you run SQL Server 2005 Mobile Edition: "80004005 unspecified error" Q919150 KB919150 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
918747 FIX: You receive an access violation error message when you try to restore a SQL Server 2005 Analysis Services database Q918747 KB918747 November 4, 2007
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 November 4, 2007
918251 FIX: You receive an incorrect grand total for a measure when you browse a cube in SQL Server 2005 Analysis Services Q918251 KB918251 November 4, 2007
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 November 4, 2007
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 November 4, 2007
917886 FIX: Error message after you roll back transactions on a table in SQL Server 2005: "Error: 3315, Severity: 21, State: 1" Q917886 KB917886 November 4, 2007
917870 FIX: An MDX query returns no results and you cannot cancel the operation in SQL Server 2005 Analysis Services Q917870 KB917870 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 November 4, 2007
914595 FIX: Dimension processing may fail, and you may receive an error message in SQL Server 2005 Analysis Services Q914595 KB914595 November 4, 2007
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 November 4, 2007
913859 FIX: Multiple problems occur when you run a SQL Server 2005 Analysis Services MDX query that uses the DrillDownMember function Q913859 KB913859 November 4, 2007
913552 FIX: You cannot drill down a dimension from the (All) level in SQL Server 2005 Analysis Services build 1507 Q913552 KB913552 November 4, 2007
913494 FIX: The merge agent does not use a specified custom user update to handle conflicting UPDATE statements in SQL Server 2005 Q913494 KB913494 November 4, 2007
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 November 4, 2007
913061 FIX: Transferred data is not compressed when you connect to a SQL Server 2005 Analysis Services server by using HTTP Q913061 KB913061 November 4, 2007
912335 FIX: SQL Server 2005 Analysis Services may stop responding because a deadlock condition occurs Q912335 KB912335 November 4, 2007
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 November 4, 2007
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 November 4, 2007
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 November 3, 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
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 October 24, 2007
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 October 23, 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
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 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
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 October 19, 2007
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 October 18, 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
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 October 12, 2007
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 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
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 12, 2007
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 October 12, 2007
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 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
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 5, 2007
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 October 4, 2007
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 October 4, 2007
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 October 4, 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
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 October 2, 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
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 September 18, 2007
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 September 18, 2007
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 September 18, 2007
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 September 18, 2007
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 September 18, 2007
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 September 11, 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
940382 FIX: The calendar control in a SQL Server 2005 Reporting Services report may display incorrect values Q940382 KB940382 September 4, 2007
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 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
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 August 29, 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
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 August 24, 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
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 August 23, 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
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 August 21, 2007
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 August 20, 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
940126 FIX: Error 9003 is logged in the SQL Server error log file when you use log shipping in SQL Server 2005 Q940126 KB940126 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
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 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
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 August 17, 2007
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 August 17, 2007
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 August 16, 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
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 August 14, 2007
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 August 13, 2007
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 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
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 August 8, 2007
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 August 8, 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
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 July 24, 2007
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 July 24, 2007
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 July 24, 2007
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 July 24, 2007
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 July 24, 2007
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 July 24, 2007
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 July 24, 2007
923301 FIX: SQL Server 2005 Analysis Services continually generates minidump files when you try to deploy a new cube Q923301 KB923301 July 24, 2007
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 July 24, 2007
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 July 24, 2007
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 July 24, 2007
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 July 24, 2007
921405 FIX: An image placeholder that contains a red X appears when you run a report in SQL Server 2005 Reporting Services Q921405 KB921405 July 24, 2007
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 July 24, 2007
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 July 24, 2007
920340 FIX: A query may return incorrect results when you run the query against a SQL Server 2005 Analysis Services cube Q920340 KB920340 July 24, 2007
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 July 24, 2007
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 July 24, 2007
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 July 24, 2007
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 July 24, 2007
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 July 24, 2007
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 July 24, 2007
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 July 24, 2007
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 July 24, 2007
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 July 24, 2007
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 July 24, 2007
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 July 24, 2007
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 July 24, 2007
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 July 24, 2007
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 July 24, 2007
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 July 17, 2007
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 July 5, 2007
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 July 3, 2007
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 July 3, 2007
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 June 29, 2007
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 June 29, 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
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 used in the query" Q936223 KB936223 June 27, 2007
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 June 26, 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
938068 FIX: Hebrew characters are incorrectly converted when you synchronize a replication subscription in SQL Server 2005 Q938068 KB938068 June 22, 2007
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 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
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 June 20, 2007
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 June 20, 2007
835185 Failover cluster resource dependencies in SQL Server Q835185 KB835185 May 7, 2007
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 April 9, 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
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 December 21, 2006
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 10, 2006
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 October 9, 2006
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 September 22, 2006
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 September 19, 2006
906532 FIX: Error message when you run the SQLDiag utility or the PSSDiag utility: "Exception creating Perfmon log" Q906532 KB906532 August 16, 2006
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 July 26, 2006
917355 FIX: You receive an error message when you try to connect to a cube that contains a parent-child dimension Q917355 KB917355 July 26, 2006
917100 FIX: The YTD calculation is incorrect when you use the Business Intelligence Wizard to automatically generate a YTD calculation Q917100 KB917100 July 26, 2006
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 July 26, 2006
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 July 26, 2006
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 July 26, 2006
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 July 26, 2006
914398 FIX: Error message when you try to export SQL Server 2005 reports to Excel: "Index out of range" Q914398 KB914398 July 26, 2006
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 July 26, 2006
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 July 26, 2006
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 July 26, 2006
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 July 26, 2006
912471 FIX: The replication on the server does not work any longer when you manually fail over databases in SQL Server 2005 Q912471 KB912471 July 26, 2006
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 July 26, 2006
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 July 26, 2006
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 July 26, 2006
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 July 26, 2006
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 July 26, 2006
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 July 26, 2006
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 July 26, 2006
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 July 26, 2006
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 July 26, 2006
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 July 26, 2006
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 July 26, 2006
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 July 26, 2006
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 July 26, 2006
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 June 29, 2006
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 June 9, 2006
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 June 1, 2006
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
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 April 19, 2006
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 April 17, 2006
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 April 6, 2006

SQL Server 2005 articles, fixes and updates - letter F