SQL Server 2005 articles, fixes and updates - May 2008

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

• 952734 Error message when you run the bcp utility to copy a result set of a stored procedure that contains a dynamic query in SQL Server 2005: "BCP host-files must contain at least one column" Q952734 KB952734 May 30, 2008
• 953118 Changes to a SQL Server Agent job are lost when the job corresponds to a subplan in a maintenance plan that you created in SQL Server 2005 Service Pack 2 Q953118 KB953118 May 29, 2008
• 953119 A CROSS JOIN clause is automatically inserted into an UPDATE statement that uses an INNER JOIN clause when you execute the statement in the SQL pane of SQL Server Management Studio Q953119 KB953119 May 27, 2008
• 953117 A maintenance plan that contains an Update Statistics task runs slowly after you install SQL Server 2005 Service Pack 2 Q953117 KB953117 May 27, 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
• 925869 Error message when you run a Multidimensional Expressions (MDX) query from a linked server in SQL Server 2005 against a SQL Server 2005 Analysis Services database: "Msg 7341, Level 16, State 2, Line 1 Cannot get the current row value of column" Q925869 KB925869 May 22, 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
• 842423 A call to the AuthzInitializeContextFromSid API function fails during the delivery of an e-mail subscription in SQL Server Reporting Services Q842423 KB842423 May 19, 2008
• 952114 How the impersonation information option of a SQL Server 2005 Analysis Services database affects deployment and synchronization Q952114 KB952114 May 14, 2008
• 952113 When you use dynamic security, SQL Server 2005 Analysis Services does not reevaluate the permissions of the user after the permissions change Q952113 KB952113 May 14, 2008
• 238254 UPDATE Statements May be Replicated as DELETE/INSERT Pairs Q238254 KB238254 May 12, 2008
• 952217 A query that references a nondeterministic user-defined function may run slower in SQL Server 2005 than in SQL Server 2000 Q952217 KB952217 May 8, 2008
• 952112 When you use Business Intelligence Development Studio to create a report model project in SQL Server 2005 Reporting Services, the isolation mode that you click in the Isolation list is not used Q952112 KB952112 May 6, 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
• 952111 The identity column of the destination table does not contain the same identity values as the source table after you use SQL Server Management Studio to import data or to export data in Microsoft SQL Server 2005 Q952111 KB952111 May 5, 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 = ]" Q951932 KB951932 May 5, 2008
• 952110 Error message when you save a SQL Server 2005 Integration Services package in SQL Server Business Intelligence Development Studio: "Exception of type 'System.OutOfMemoryException' was thrown" Q952110 KB952110 May 1, 2008
• 941151 How to enable the Sqldumper.exe utility to generate dump files for processes that are related to SQL Server 2005 Integration Services with Service Pack 2 Q941151 KB941151 May 1, 2008