SQL Server 2005 articles, fixes and updates - July 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 July 2009. The list is daily updated.

• 935897 An Incremental Servicing Model is available from the SQL Server team to deliver hotfixes for reported problems Q935897 KB935897 July 29, 2009
• 927396 Queries take a longer time to finish running when the size of the TokenAndPermUserStore cache grows in SQL Server 2005 Q927396 KB927396 July 28, 2009
• 910708 You must specify the domain groups for the clustered SQL Server services when you install a SQL Server failover cluster Q910708 KB910708 July 28, 2009
• 2000471 You may notice a continuous growth in tempdb data file size with a corresponding increase in mixed_extent_page_count after upgrading SQL server Q2000471 KB2000471 July 24, 2009
• 967963 FIX: Some rows are deleted when you repair a database by using the Repair method together with the RepairOption.RecoverCorruptedRows option in SQL Server 2005 Compact Edition and in SQL Server Compact 3.5 Q967963 KB967963 July 24, 2009
• 972767 FIX: The SQL Server database engine and SQL Server Reporting Services may consume more power on Windows client computers than expected Q972767 KB972767 July 22, 2009
• 938245 How to install and how to configure SQL Server 2005 Reporting Services on a computer that is running Windows Server 2008 Q938245 KB938245 July 22, 2009
• 819546 SQL Server support for mounted volumes Q819546 KB819546 July 22, 2009
• 971402 FIX: Error message when you send an e-mail by using a private Database Mail profile in SQL Server 2005 or in SQL Server 2008: "profile name is not valid" Q971402 KB971402 July 21, 2009
• 970966 FIX: An MDX query that uses the NON EMPTY clause and the DrillDownLevel function returns null values in SQL Server 2005 Analysis Services or SQL Server 2008 Analysis Services Q970966 KB970966 July 21, 2009
• 970823 FIX: CPU usage increases when you run a query that uses a string comparison function on a computer that has many processors after you upgrade to SQL Server 2005 Service Pack 3 or to SQL Server 2008 Q970823 KB970823 July 21, 2009
• 970551 FIX: Error message when you run an MDX query that requests a dimension property on a parent-child hierarchy in Microsoft SQL Server 2005 Analysis Services or in SQL Server 2008 Analysis Services Q970551 KB970551 July 21, 2009
• 970058 FIX: Error message when you open a report by specifying a multivalued parameter in a URL in SQL Server 2005 or SQL Server 2008 Reporting Services: "Default value or value provided for the report parameter '<Parameter>' is not a valid value" Q970058 KB970058 July 21, 2009
• 969997 FIX: You receive an incorrect result when you query data from a linked server that is created by using an index OLE DB provider in SQL Server 2005 or in SQL Server 2008 Q969997 KB969997 July 21, 2009
• 969844 FIX: You receive inconsistent results when you run index-related DMVs to return statistical information about missing indexes in SQL Server 2005 or in SQL Server 2008 Q969844 KB969844 July 21, 2009
• 969611 FIX: Error message when you run a job whose owner is a Windows user account after SQL Server 2005 Agent or SQL Server 2008 Agent is restarted: "The job failed. The owner () of job <Job Name> does not have server access" Q969611 KB969611 July 21, 2009
• 969528 FIX: An assertion failure occurs when you switch the schedule of a report subscription between a shared schedule and a custom schedule in SQL Server 2005 Report Services or SQL Server 2008 Reporting Services Q969528 KB969528 July 21, 2009
• 969086 FIX: The SQL Server service stops responding, and event ID 2019 is logged in the System log in SQL Server 2005 or in SQL Server 2008 Q969086 KB969086 July 21, 2009
• 968834 FIX: Error message when you send an e-mail by using Database Mail in SQL Server 2005 or in SQL Server 2008: "The operation has timed out" Q968834 KB968834 July 21, 2009
• 968615 FIX: SQL Server Integration Services Import and Export Wizard does not provide the ConnectionString property for the .NET Framework Data Provider for ODBC Q968615 KB968615 July 21, 2009
• 967522 FIX: The SQL Server engine in SQL Server 2005 and in SQL Server 2008 may consume large amounts of memory during the setup configuration phase Q967522 KB967522 July 21, 2009
• 956574 FIX: Data results are inconsistent in SQL Server 2005 and in SQL Server 2008 when you run a search query that uses the NEAR operator against an XML type data that contains the xml:lang attribute Q956574 KB956574 July 21, 2009
• 948567 FIX: When you run a query against a table that contains Traditional Chinese characters, the incorrect result is returned in SQL Server 2005 or SQL Server 2008 Q948567 KB948567 July 21, 2009
• 971970 FIX: You cannot insert rows or upload changes into the SQL Server 2005 Compact Edition subscriber tables after you run the "sp_changemergearticle" stored procedure or you add a new merge publication article when another article has an IDENTITY column Q971970 KB971970 July 14, 2009
• 327270 SQL Server is not supported on Windows Server 2003 or Windows Server 2008 Terminal Server application server Q327270 KB327270 July 14, 2009
• 314546 How to move databases between computers that are running SQL Server Q314546 KB314546 July 13, 2009
• 2000524 SQL Reporting services always passes string parameters as Unicode Q2000524 KB2000524 July 10, 2009
• 923355 Error message when you perform a full backup of a database in SQL Server 2005: "Backup failed for Server 'ComputerName\SQLInstanceName' " or "The backup of the file or filegroup 'sysft_FullTextCatalog' is not permitted because it is not online" Q923355 KB923355 July 9, 2009
• 970915 FIX: Error message when you synchronize a merge replication with SQL Server 2005 Compact Edition subscribers: "A column ID occurred more than once in the specification. HRESULT 0x80040E3E (0)" Q970915 KB970915 July 3, 2009
• 910070 FIX: The SQL Server 2005 Setup program may take much longer than expected to finish running Q910070 KB910070 July 1, 2009