kbupdate.info ›
Daily Updated!
SQL Server 2005 articles, fixes and updates - August 2009
Daily Updated!
chronological list: 2012 | ... 3 2 1 | 2009/12 11 10 9 8 7 6 5 4 3 2 ... 2003
alphabetical list: A B C D E F G H I K L M N O P Q R S T U V W Y
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 August 2009. The list is daily updated.
- 942444 FIX: A query that involves an outer join operation runs very slowly in Microsoft SQL Server 2005 Q942444 KB942444 August 31, 2009
- 940971 An error message is logged in the Summary.txt file when a SQL Server 2005 service pack, cumulative update or cluster hotfix installation fails: "The Transaction Manager is not available" Q940971 KB940971 August 25, 2009
- 971409 FIX: Error message when you run a query that contains duplicate join conditions in SQL Server 2005: "Internal Query Processor Error: The query processor could not produce a query plan" Q971409 KB971409 August 24, 2009
- 960142 FIX: An error message is logged, and the synchronization may take a long time to finish when you use an application to synchronize a merge replication that contains a SQL Server 2005 Compact Edition subscriber Q960142 KB960142 August 24, 2009
- 970939 FIX: Error message when you run a query that queries the sys.sysindexes view in SQL Server 2005: "Error: 701, Severity: 17, State: 123. There is insufficient system memory to run this query" Q970939 KB970939 August 21, 2009
- 959823 How to customize the quota for the TokenAndPermUserStore cache store in SQL Server 2005 Service Pack 3 Q959823 KB959823 August 21, 2009
- 973877 FIX: A performance issue in which you run a query by using a Fast Forward cursor in SQL Server 2005 or SQL Server 2008 Q973877 KB973877 August 17, 2009
- 973578 FIX: An incorrect result is returned when you run a query against an XML column that contains XML data that is generated by the FOR XML clause and contains nested data sections in SQL Server 2005 Q973578 KB973578 August 17, 2009
- 973524 FIX: The execution of the xp_readerrorlog command in SQL Server 2005 and in SQL Server 2008 stops responding and the usage of the CPU that is running the command increases to 100 percent Q973524 KB973524 August 17, 2009
- 973103 FIX: Error message when you run the Distribution Agent to synchronize the subscribers with the publisher in Microsoft SQL Server 2005 or SQL Server 2008:" The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect" Q973103 KB973103 August 17, 2009
- 972694 FIX: SQL Server 2008 Reporting Services Add-in for SharePoint removes the "Microsoft.SqlServer.Smo" assembly for SQL Server 2005 from the GAC Q972694 KB972694 August 17, 2009
- 972681 FIX: The removal of a transaction log file of the database on the principal server breaks a database mirroring session in SQL Server 2005 or in SQL Server 2008 Q972681 KB972681 August 17, 2009
- 972637 FIX: An access violation occurs when you run a query that uses a string matching function in SQL Server 2005 Q972637 KB972637 August 17, 2009
- 972498 FIX: You receive error messages or data is damaged after you run an SSIS package that contains a data flow task in a low memory situation in SQL Server 2005 or in SQL Server 2008 Q972498 KB972498 August 17, 2009
- 972365 FIX: Error message when you run a SQL Server 2005 Integration Services package that contains a column of a BLOB data type in a data flow task: "The buffer manager could not get a temporary file name. The call to GetTempFileName failed" Q972365 KB972365 August 17, 2009
- 972271 FIX: Error message when you run a "BULK INSERT" statement on a table that does not have a clustered index in SQL Server 2005 or SQL Server 2008: "spid1005 Error: 5243, Severity: 22, State: 1 An inconsistency was detected during an internal operation" Q972271 KB972271 August 17, 2009
- 971114 FIX: Error message when you run a report in SQL Server 2005 SP2 Reporting Services by using a URL from a subscription: "Object reference not set to an instance of an object" Q971114 KB971114 August 17, 2009
- 971057 FIX: An INSERT INTO
EXEC
statement generates error messages even if you set the ANSI_WARNINGS option to "OFF" in SQL Server 2005 and SQL Server 2008 Q971057 KB971057 August 17, 2009 - 970726 FIX: Error message when you try to rebuild one partition of an index on an indexed view in SQL Server 2005: "A system assertion check has failed. Check the SQL Server error log for details." Q970726 KB970726 August 17, 2009
- 970307 An index corruption occurs when you crawl the content sources on a computer that is running Windows SharePoint Services 3.0 or Office SharePoint Server 2007, and a power outage occurs on the computer Q970307 KB970307 August 17, 2009
- 2000380 SQL Server 2005 and SQL Server 2008 reports 701 errors with large batch sizes Q2000380 KB2000380 August 16, 2009
- 910230 How to install SQL Server 2005 Analysis Services on a failover cluster Q910230 KB910230 August 14, 2009
- 907284 Changes to the readme file for SQL Server 2005 Q907284 KB907284 August 11, 2009
- 919224 On a computer that has a 64-bit processor, you receive an error message in SQL Server Management Studio when you connect to SQL Server 2005 Integration Services or when you create or edit a maintenance plan Q919224 KB919224 August 10, 2009
- 2000373 You may not be able to make a remote connection to SQL Server from a CLR trigger Q2000373 KB2000373 August 6, 2009
- 927797 You cannot specify a USB-based tape drive as a backup device in SQL Server Q927797 KB927797 August 6, 2009
- 897284 Diagnostics in SQL Server 2000 SP4 and in later versions help detect stalled and stuck I/O operations Q897284 KB897284 August 5, 2009
- 973993 Some nodes are not updated as expected when you apply Service Pack 3 or a post-Service Pack 3 update in a SQL Server 2005 cluster that is based on Windows Server 2008 R2 failover clustering Q973993 KB973993 August 4, 2009