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.

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
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 November 3, 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 October 31, 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 October 22, 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 October 20, 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 October 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 October 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 October 20, 2008
958684 FIX: Log Reader Agent fails with error code 18834 in SQL Server 2005 Q958684 KB958684 October 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 October 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 October 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 October 20, 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
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 October 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 October 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 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
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 October 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 October 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 October 20, 2008
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 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
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 October 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 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
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 October 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 October 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 October 17, 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
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 October 10, 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 October 10, 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
956036 FIX: Error message when you process a partition from SQL Server 2008 Analysis Services Cumulative Update 7: "Detected inconsistency between User define slice and detected slice of partition. The slice specified for the %{Property/} attribute is incorrect" Q956036 KB956036 September 18, 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
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
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 September 2, 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
910070 FIX: The SQL Server 2005 Setup program may take a very long time to be completed Q910070 KB910070 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
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 July 8, 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
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 July 1, 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
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 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
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> been patched with more recent updates" Q934749 KB934749 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
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 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
941105 FIX: Error messages after SQL Server 2005 has been running for some time on Windows Server 2003: "Failed to load FileName.dll" and "Attempts to load any type of dll might fail within the SQL Server process with errors pointing to LoadLibrary failure" Q941105 KB941105 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
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 possible database corruption" Q923979 KB923979 December 12, 2007
945842 FIX: The setMaxRows method unexpectedly applies to DELETE statements when you use the SQL Server 2005 JDBC Driver version 1.2 to connect to a database Q945842 KB945842 December 11, 2007
945770 FIX: The DBCC CHECKDB statement takes longer to run on an x64-based computer than the statement takes to run on a 32-bit computer when you run the statement against a database in SQL Server 2005 Q945770 KB945770 December 11, 2007
945600 FIX: You receive an exception error message when you try to display a Reporting Services report on a server that uses the AMD Cool'n'Quiet technology Q945600 KB945600 December 11, 2007
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
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 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

SQL Server 2005 articles, fixes and updates - letter F