SQL Server 7.0 articles, fixes and updates - Year 2007

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

• 273673 Description of SQL Virtual Server client connections Q273673 KB273673 December 4, 2007
• 320454 Microsoft Baseline Security Analyzer (MBSA) version 1.2.1 is available Q320454 KB320454 December 3, 2007
• 840473 An "Event ID ( 19011 ) in Source ( MSSQL$MSFW ) cannot be found" message may be logged in the event log after you install ISA Server 2006 or ISA Server 2004 on a computer that is part of a workgroup Q840473 KB840473 November 30, 2007
• 309450 FIX: Inconsistent Results Reported by TOP N Using Full-Text CONTAINSTABLE Q309450 KB309450 November 30, 2007
• 298725 PRB: Scheduled DTS Package Fails With "Permission Denied: CreateObject" Q298725 KB298725 November 30, 2007
• 295743 PRB: SQL Server Local Temp Tables Aren't Created When Parameterized ADO Query Is Used Q295743 KB295743 November 30, 2007
• 294160 BUG: Update of Newly Inserted Row Causes DB_E_ERRORSOCCURRED Q294160 KB294160 November 30, 2007
• 283860 FIX: "Cannot Open Database Requested" Error Connecting to Remote SQL Server Q283860 KB283860 November 30, 2007
• 279113 FILE: Use Xpvmlog to Dump the Layout of Virtual Memory in SQL Server Q279113 KB279113 November 30, 2007
• 242953 SMS: "Table Corrupt" When Running DBCC Checkcatalog Against SMS Database Q242953 KB242953 November 30, 2007
• 240867 How to move, copy, and back up full-text catalog folders and files Q240867 KB240867 November 30, 2007
• 113136 BUG: EXAMPLE8.C in Prog. Ref. Does Not Match Sample Program Q113136 KB113136 November 30, 2007
• 820788 FIX: Delayed domain authentication may cause SQL Server to stop responding Q820788 KB820788 November 27, 2007
• 298897 SAMPLE Stored Procedures That Helps Map SIDs Between User and Master Databases When A Database Is Moved Q298897 KB298897 November 26, 2007
• 241397 How to back up a Microsoft Data Engine database by using Transact-SQL Q241397 KB241397 November 14, 2007
• 320499 How to manually synchronize replication subscriptions by using backup or restore Q320499 KB320499 November 12, 2007
• 831801 FIX: SQLStatistics function returns incorrect sort order sequence Q831801 KB831801 November 5, 2007
• 910401 How to use Microsoft System Center Data Protection Manager 2006 to help protect a SQL Server database Q910401 KB910401 November 2, 2007
• 842960 Description of the 32-bit SQL Server 7.0 and SQL Server 2000 hotfix installer Q842960 KB842960 November 2, 2007
• 317989 FIX: Sqlakw32.dll May Corrupt SQL Statements Q317989 KB317989 November 2, 2007
• 288095 Stack overflow occurs when you run a query that contains a large number of arguments inside an IN or a NOT IN clause in SQL Server Q288095 KB288095 November 2, 2007
• 278667 BUG: Sqlmaint Does Not Delete Expired Backup Files on Windows 95, 98 or ME Computers Q278667 KB278667 November 2, 2007
• 273833 BUG: Restore of a Large Database on Windows 98 May Fail with 3257 Error Message Q273833 KB273833 November 2, 2007
• 273586 The behavior of the IDENTITY function when used with SELECT INTO or INSERT .. SELECT queries that contain an ORDER BY clause Q273586 KB273586 November 2, 2007
• 243586 Troubleshooting stored procedure recompilation Q243586 KB243586 November 2, 2007
• 319507 FIX: SQL Extended Procedure Functions Contain Unchecked Buffers Q319507 KB319507 October 29, 2007
• 307775 INF: Disaster Recovery Articles for Microsoft SQL Server Q307775 KB307775 October 29, 2007
• 841249 How to configure Windows XP Service Pack 2 (SP2) for use with SQL Server Q841249 KB841249 October 26, 2007
• 297105 FIX: Potential English Query Security Issue Q297105 KB297105 October 26, 2007
• 275474 How To Rebuild an MSMQ Site Controller on a Computer Running MSCS and SQL Server 7.0 Q275474 KB275474 October 26, 2007
• 239473 FIX: 70rebind.exe for Windows 2000 and MDAC upgrades on clustered SQL Server 7.0 servers Q239473 KB239473 October 26, 2007
• 237458 How To Install an MSMQ Independent Client on a Cluster After SQL Server 7.0 Q237458 KB237458 October 26, 2007
• 224587 HOW TO: Troubleshoot Application Performance with SQL Server Q224587 KB224587 October 26, 2007
• 192710 INF: Basic Guidelines for Installing SQL Server Version 6.5 or 7.0 Q192710 KB192710 October 26, 2007
• 219264 INF: Order of Installation for SQL Server 7.0 Clustering Setup Q219264 KB219264 September 28, 2007
• 285996 Cost of using non-clustered indexes may be incorrect if data correlation exists Q285996 KB285996 September 5, 2007
• 280380 FIX: Buffer Overflow Exploit Possible with Extended Stored Procedures Q280380 KB280380 September 5, 2007
• 261225 PRB: TSQL PRINT Statement Breaks Lines Longer Than 255 Characters When You Use OSQL to Create a Flat File Q261225 KB261225 August 8, 2007
• 214820 INF: How to Use the SQL Server DMO Objects from VBScript Q214820 KB214820 August 8, 2007
• 257657 FIX: Edit/Update Fails for SQL 7.0 for Column of Type Text When CursorDriver Is Set to rdUseODBC Q257657 KB257657 August 7, 2007
• 317821 BUG: Parallel query may stop responding or fail with 8650 error message Q317821 KB317821 July 26, 2007
• 274314 FIX: SQL Server 7.0 SP2 Unattended Client Setup Results in "MMC Snap-In Failed to Initialize" Error Message Q274314 KB274314 July 18, 2007
• 232570 INF: How to Obtain Service Pack 1 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0 Q232570 KB232570 July 18, 2007
• 811030 PRB: Log Reader Agent Does Not Function and You Receive an Error Message During Transaction Replication Q811030 KB811030 May 30, 2007
• 274798 INF: Readme.txt for SQL Server 7.0 Service Pack 3 Q274798 KB274798 May 28, 2007
• 322742 INFO: Content Management Server Supports SQL Server Log Shipping for Failover Q322742 KB322742 May 23, 2007
• 824421 BUG: You receive an error message that contains a decimal representation of the SQL Server version number Q824421 KB824421 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
• 311348 Error message occurs in SQL Server 7.0 when you call the Command.Prepare method before you add parameters by using Visual C# .NET: "An unhandled exception of type" Q311348 KB311348 May 13, 2007
• 310368 Error when you try to call the Prepare method before you add parameters: "An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll" Q310368 KB310368 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
• 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
• 875285 TechNet Support WebCast: Known connectivity issues related to "General Network Error" error messages Q875285 KB875285 April 29, 2007
• 818714 Support WebCast: Microsoft SQL Server 2000: The Types of Replication and When to Implement Each Q818714 KB818714 April 29, 2007
• 321698 You cannot connect to MSDE 2000 by using ADO.NET with SQL Server Authentication Q321698 KB321698 April 28, 2007
• 290820 BUG: SQL Desktop Edition: Shared memory fails to connect after you install MDAC 2.6 Q290820 KB290820 April 25, 2007
• 285077 PRB: SQL Server 7.0 Setup Fails When ODBC Components on Your System Need Updating Q285077 KB285077 April 25, 2007
• 829028 Description of the Microsoft application blocks for .NET topic: "Data Access Application Block Overview" Q829028 KB829028 April 19, 2007
• 254369 INF: SQL Server 7.0 Service Pack 2 Fixlist Q254369 KB254369 April 12, 2007
• 883724 Information about the SQL Server edition of the MPS Reporting tool Q883724 KB883724 April 10, 2007
• 327068 INF: SQL Server 7.0 Security Update for Service Pack 4 Q327068 KB327068 March 29, 2007
• 289573 PRB: Configuring DSNs with SQL Server Net-Libraries Q289573 KB289573 March 27, 2007
• 325022 MSDE security and authentication Q325022 KB325022 March 22, 2007
• 837938 You may receive an error message when you try to restore a SQL Server 7.0 database backup on an instance of SQL Server 2000 Q837938 KB837938 March 19, 2007
• 834849 You may receive error message 8525 when you try to run a distributed transaction on an instance of SQL Server Q834849 KB834849 March 19, 2007
• 242929 How to install MSDE by using the Windows Installer Q242929 KB242929 March 19, 2007
• 274098 Adding a linked server causes error 15028 in SQL Server Q274098 KB274098 March 16, 2007
• 311021 HOW TO: Manage Quotation Marks in Concatenated SQL Literals by Using ADO.NET and Visual C# .NET Q311021 KB311021 March 9, 2007
• 266650 Information About BackOffice Program Support on Windows 2000 Datacenter Server-Based Computers Q266650 KB266650 March 1, 2007
• 815337 Support WebCast: Microsoft SQL Server 2000: Reading Execution Plans in SQL Server 2000 Q815337 KB815337 February 27, 2007
• 814324 Support WebCast: Microsoft SQL Server 7.0 and SQL Server 2000 Indexes Q814324 KB814324 February 27, 2007
• 280084 PRB: Parameters.Refresh Fails Using Parameter Token in Nested SQL Q280084 KB280084 February 23, 2007
• 325338 FIX: OLE DB Provider for SQL Server Does Not Cancel a Batch Statement When You Call the Cancel() Method Q325338 KB325338 February 22, 2007
• 287737 How to enumerate available instances of SQL Server by using the SQLDMO components Q287737 KB287737 February 22, 2007
• 286280 Description of the effect to database recovery after you add or remove database files Q286280 KB286280 February 22, 2007
• 259561 You receive a "Cannot open user default database <ID>. Using master database instead." error message when you connect to a SQL Server database Q259561 KB259561 February 22, 2007
• 239530 You must precede all Unicode strings with a prefix N when you deal with Unicode string constants in SQL Server Q239530 KB239530 February 22, 2007
• 152801 Examples of how to use Sp_OA pocedures and the SQLOLE.Transfer (or SQLDMO.Transfer) object Q152801 KB152801 February 22, 2007
• 137637 Microsoft ODBC SQL Server Driver is not certified for use against Sybase SQL Servers Q137637 KB137637 February 22, 2007
• 829015 FIX: An attention signal that is sent from a SQL Server client application because of a query time-out may cause the SQL Server service to quit unexpectedly Q829015 KB829015 February 21, 2007
• 163449 Use of Thread Local Storage in an extended stored procedure Q163449 KB163449 February 21, 2007
• 162294 How to schedule SQL Server backup or DBCC commands by using AT scheduler command Q162294 KB162294 February 21, 2007
• 62866 Description of the reasons that the SQL Server transaction log is not being truncated Q62866 KB62866 February 19, 2007
• 300519 FIX: Problems occur when connecting to SQL Server from ADO application Q300519 KB300519 February 15, 2007
• 245543 INFO: ODBC Connection Pooling Counters in Performance Monitor and ADO Q245543 KB245543 February 15, 2007
• 240166 INFO: MDAC 2.1 Sets Session Pooling ON by Default Q240166 KB240166 February 15, 2007
• 229564 SQL application role errors with OLE DB resource pooling Q229564 KB229564 February 15, 2007
• 279760 FIX: MDAC 2.6 SQLOLEDB Provider Running on Windows 2000 Returns No Error Text Description Q279760 KB279760 February 12, 2007
• 267550 BUG: "Assertion Failed" When You Connect to a SQL Server Through TCP/IP Q267550 KB267550 February 12, 2007
• 257767 PRB: Cannot Open Pubs Table Image Data Through Microsoft Access Link Q257767 KB257767 February 12, 2007
• 246255 How To Use a SQL Server 7.0 Distributed Query with a Linked Server to Secured Access Databases Q246255 KB246255 February 12, 2007
• 243053 How to create an application role on SQL Server 2000 from within Visual FoxPro Q243053 KB243053 February 12, 2007
• 321190 SQL Server cluster supportability with MCMS 2002 and with MCMS 2001 Q321190 KB321190 February 10, 2007
• 326839 Support WebCast&#58; Microsoft SQL Server&#58; How to Configure, Manage, Use, and Troubleshoot Linked Servers Q326839 KB326839 February 1, 2007
• 305385 Frequently asked questions about the Microsoft Network Security Hotfix Checker &#40;HFNetChk&#41; functionality that is integrated into the Microsoft Baseline Security Analyzer &#40;MBSA&#41; Q305385 KB305385 January 31, 2007
• 324362 Subqueries that you define on merge articles are not re-evaluated Q324362 KB324362 January 29, 2007
• 301511 How to obtain the latest SQL Server 7.0 service pack Q301511 KB301511 January 29, 2007
• 235432 ACC2000: Microsoft Data Engine Setup Stops Responding While Connecting to Server Q235432 KB235432 January 24, 2007
• 811480 BUG: You Receive Error Message: "There Is Not Enough Space on Drive" When You Extract SQL Server 2000 Service Pack 1 Q811480 KB811480 January 10, 2007