SQL Server 2005 articles, fixes and updates - April 2009

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 April 2009. The list is daily updated.

• 968951 FIX: A SQL Server 2005-based application cannot connect to a mirrored database by using the JDBC driver 1.2 after the first successful connection Q968951 KB968951 April 30, 2009
• 329204 General guidelines to use to configure the MAXDOP option Q329204 KB329204 April 28, 2009
• 970669 SQL Server 2008 specific folders are created on systems with SQL Server 2005 starting SP3 and above to prevent upgrade failures to SQL Server 2008 at a later time Q970669 KB970669 April 27, 2009
• 962003 FIX: Error message when you synchronize data for a SQL Server Compact Edition subscriber in SQL Server 2005 and in SQL Server 2008: "A call to SQL Server Reconciler failed. Try to resynchronize. HRESULT 0x80004005 (29006)" Q962003 KB962003 April 22, 2009
• 961935 FIX: A query notification is not fired correctly if the query contains inner joins and the IS NULL clause in SQL Server 2005 and in SQL Server 2008 Q961935 KB961935 April 22, 2009
• 961648 FIX: You receive an error message when you try to query or update a column of large object (LOB) data in SQL Server 2005 and in SQL Server 2008 Q961648 KB961648 April 22, 2009
• 969466 FIX: Error message when you run a query that uses the CASE function in SQL Server 2005: "Conversion failed when converting the <DateType> value '<Value>' to data type <DataType>" Q969466 KB969466 April 20, 2009
• 969123 FIX: Error message occurs unexpectedly at different times in a SQL Server 2005 Analysis Services database that uses user-defined functions: "The <Function Name> function does not exist" Q969123 KB969123 April 20, 2009
• 969021 FIX: A query that contains the IS NOT NULL clause returns an incorrect result in SQL Server 2005 Q969021 KB969021 April 20, 2009
• 968914 FIX: When you convert a TEXT column to a VARCHAR(MAX) column, an NTEXT column to a NVARCHAR(MAX) column, or an IMAGE column to a VARBINARY(MAX) column, the original NULL values in these columns may become empty strings in SQL Server 2005 Q968914 KB968914 April 20, 2009
• 968906 FIX: An access violation occurs when a peer-to-peer transactional replication is under stress in SQL Server 2005 Q968906 KB968906 April 20, 2009
• 968233 FIX: A SQL Server 2005 database becomes offline unexpectedly when you run an application that uses service broker on this database Q968233 KB968233 April 20, 2009
• 968079 FIX: Error message after you configure a peer-to-peer transactional replication and then apply SQL Server 2005 Service Pack 3: "The process could not allocate memory. (Source: MSSQL_REPL, Error number: MSSQL_REPL20001)" Q968079 KB968079 April 20, 2009
• 967984 FIX&#58; When you process a full-text catalog in SQL Server 2005 and in SQL Server 2008, the operation stops responding Q967984 KB967984 April 20, 2009
• 967625 FIX: Error message when you synchronize a database in SQL Server 2005 Analysis Services: "Errors in the metadata manager. The dimension with ID of '<Dimension ID>', Name of '<Dimension Name>' referenced by the '<Cube Name>' cube, does not exist" Q967625 KB967625 April 20, 2009
• 967618 FIX: Error message when you try to export a report to a PDF file in SQL Server 2005 Reporting Services: "Non-negative number required" Q967618 KB967618 April 20, 2009
• 967570 FIX: An empty result set is returned when you run an SSIS package that contains an Execute SQL task in SQL Server 2005 Service Pack 2 Q967570 KB967570 April 20, 2009
• 967527 FIX: Error message when you apply a snapshot file that is exactly divisible by 1 MB in SQL Server 2005: "The process could not bulk copy into table dbo.<tablename>. (Source: MSSQLServer, Error number: 20253)" Q967527 KB967527 April 20, 2009
• 967316 FIX: The values of some SQL Server 2005 SSIS pipeline counters are always 0 when you try to view them in a terminal session Q967316 KB967316 April 20, 2009
• 967169 FIX: When you run an UPDATE statement against a table that has a FOR UPDATE trigger that joins the DELETED and INSERTED tables, the query takes a long time to finish Q967169 KB967169 April 20, 2009
• 967101 FIX: The performance of database mirroring decreases when you run a database maintenance job that generates a large number of transaction log activities in SQL Server 2005 Q967101 KB967101 April 20, 2009
• 962903 FIX: The population process stops responding when you create an additional full-text catalog in SQL Server 2005 Q962903 KB962903 April 20, 2009
• 961396 FIX: When you insert a string to a table by using the SQL Native Client (SNAC) OLE DB provider or the SNAC ODBC provider in a SQL Server 2005-based application, the string is truncated Q961396 KB961396 April 20, 2009
• 960543 FIX: SQL Server 2005 or SQL Server 2008 may stop responding when you are performing a backup Q960543 KB960543 April 10, 2009
• 959026 FIX: Error message when you run a DB2 query that uses the WITH UR query hint in SQL Server 2005 Analysis Services and in SQL Server 2008 Analysis Services: "OLE DB error: OLE DB or ODBC error: An unexpected token "WITH" was found following "<Query>"" Q959026 KB959026 April 7, 2009
• 959025 FIX: Error message when you call a stored procedure that returns a rowset which has the DBPROP_MAXROWS rowset property or the SSPROP_MAXBLOBLENGTH rowset property specified: "The incoming tabular data stream (TDS) protocol stream is incorrect" Q959025 KB959025 April 7, 2009
• 968398 FIX&#58; The SQL Server 2005 Analysis Services service crashes when you process dimensions in a cube that contains a calculation script by using the Process Update option Q968398 KB968398 April 3, 2009
• 961073 FIX: Error message when you run a DML statement in a LINQ to SQL application in SQL Server 2008: "The target table '<Table Name>' of the DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause" Q961073 KB961073 April 2, 2009