SQL Server 2000 articles, fixes and updates - May 2007

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

• 823871 BUG: Error Message "Either BOF or EOF is True, or the current record has been deleted." Occurs When You Archive an OLAP Database Q823871 KB823871 May 31, 2007
• 814574 Error message when you shrink the transaction log file of a database in SQL Server: "Cannot shrink log file ..." Q814574 KB814574 May 31, 2007
• 811030 PRB: Log Reader Agent Does Not Function and You Receive an Error Message During Transaction Replication Q811030 KB811030 May 30, 2007
• 322742 INFO: Content Management Server Supports SQL Server Log Shipping for Failover Q322742 KB322742 May 23, 2007
• 890263 SQL Server 2000 stops responding when you query lots of data with a large packet size connected over a VIA protocol Q890263 KB890263 May 18, 2007
• 886839 Description of two approaches for a disaster recovery plan for transactional replication Q886839 KB886839 May 18, 2007
• 885712 BUG: An 8144 error occurs when you try to attach a database to an instance of SQL Server by using SQL Server Enterprise Manager Q885712 KB885712 May 18, 2007
• 828089 INFO: Migrating from Microsoft Office XP Developer Q828089 KB828089 May 18, 2007
• 816755 PRB: Error 5074 occurs when you try to drop a column from a published table Q816755 KB816755 May 18, 2007
• 317241 Renaming a host computer for SQL Server causes stored procedure debug to fail Q317241 KB317241 May 18, 2007
• 824421 BUG: You receive an error message that contains a decimal representation of the SQL Server version number Q824421 KB824421 May 16, 2007
• 822853 How To: Stop a Server-Side Trace in SQL Server 2000 Q822853 KB822853 May 16, 2007
• 820209 Why the SQL Server Optimizer Uses a Nonclustered Index Instead of a Clustered Index Q820209 KB820209 May 16, 2007
• 819953 PRB: Auto Created Statistics Are Sampled by Using a Specified Sampling Rate Q819953 KB819953 May 16, 2007
• 819264 BUG: Error Message: "Could not find database ID..." Occurs When a User Defined Function is Referenced in the JOIN Condition of a Subquery Q819264 KB819264 May 16, 2007
• 819260 BUG: The Transfer of a File by Using an FTP Task in a DTS Package Returns a Success Message Even When the Source File is Not Available Q819260 KB819260 May 16, 2007
• 818202 A "Database log truncated" error is logged in the Event Log when you try to back up the transaction log Q818202 KB818202 May 16, 2007
• 814850 Compacting a SQL Server 2000 CE 2.0 database or a SQL Server 2005 Compact Edition database by using Visual Basic .NET Q814850 KB814850 May 16, 2007
• 311540 A "COMPUTE BY statements not supported" exception occurs when you use the COMPUTE BY clause in SQL Server Q311540 KB311540 May 16, 2007
• 815671 How to use XML in connected and disconnected ADO.NET applications in Visual C++ Q815671 KB815671 May 13, 2007
• 822852 An instance of SQL Server may not start successfully after you restore the model database by using the WITH NORECOVERY option Q822852 KB822852 May 12, 2007
• 814581 Error 7306 when updating or deleting data using a linked server in SQL Server 2000 Q814581 KB814581 May 11, 2007
• 811326 How To Upgrade the Master and the Target Servers (MSX/TSX) to SQL Server 2000 Service Pack 3 Q811326 KB811326 May 10, 2007
• 811034 PRB: Inconsistent Error Handling Behavior Occurs with @@ERROR in SQL Server Q811034 KB811034 May 10, 2007
• 811031 SQL Server Agent job fails when the job uses a linked server and the job owner is not a system administrator Q811031 KB811031 May 10, 2007