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.

• 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
• 942980 FIX: Error message when you install the release version of SQL Server 2005 on a server that has Windows Internal Database SP2 installed: "The SQL Server service failed to start" Q942980 KB942980 May 29, 2008
• 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
• 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
• 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
• 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
• 951185 FIX: The update operation is performed on incorrect rows when you update a column of the VARCHAR data type on a remote table by using a linked server in SQL Server 2005 Q951185 KB951185 May 6, 2008
• 951120 FIX: A peer-to-peer transactional replication does not replicate rows if you rebuild the index for a published table at the same time as you insert data to the published table in SQL Server 2005 Q951120 KB951120 May 6, 2008
• 951095 FIX: Error message when you display a SQL Server 2005 Reporting Services report in Internet Explorer: "Error: 'parentNode' is null or not an object" Q951095 KB951095 May 6, 2008
• 950926 FIX: The SQL Server service may stop responding when you run a query that contains many OR clauses in SQL Server 2005 Q950926 KB950926 May 6, 2008
• 950875 FIX: Error message when you use the BULK INSERT statement to import data of the timestamp data type in SQL Server 2005: "An invalid datetime value was encountered" Q950875 KB950875 May 6, 2008
• 950189 FIX: The SQLGetData function may return zero for the actual size of the data that is to be copied when you use the function to retrieve data for a binary column in SQL Server 2005 Q950189 KB950189 May 6, 2008
• 949854 FIX: A query may take more time to finish in SQL Server 2005 if the query uses an inner join to join a derived table that uses the DISTINCT keyword Q949854 KB949854 May 6, 2008
• 949687 FIX: Error message when you run a transaction from a remote server by using a linked server in SQL Server 2005: "This operation conflicts with another pending operation on this transaction" Q949687 KB949687 May 6, 2008
• 949199 FIX: Error message when you run queries on a database that has the SNAPSHOT isolation level enabled in SQL Server 2005: "Unable to deallocate a kept page" Q949199 KB949199 May 6, 2008
• 949040 FIX: The execution fails when you try to run a SQL Server 2005 Integration Services package that contains an Aggregate transformation Q949040 KB949040 May 6, 2008
• 948657 FIX: The %TEMP% folder is not cleaned up after you use database mail to send an e-mail message that has an attachment in SQL Server 2005 Q948657 KB948657 May 6, 2008
• 951932 FIX: Error message when you create a subscription in SQL Server 2005 Compact Edition to a merge publication on SQL Server 2000: "The table name is not valid. [Token line number (if known) = 1,Token line offset (if known) = 22,Table name = <TableName>]" Q951932 KB951932 May 5, 2008
• 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