Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Articles for product: Microsoft SQL Server 2000 Standard Edition

Article ID Article Title Hidden
140696 INF: RAISERROR, PRINT, and the MS SQL Server ODBC Driver
221465 INF: Using the WITH MOVE Option with the RESTORE Statement
229564 SQL application role errors with OLE DB resource pooling
230590 How to archive more than six SQL Server error logs
247070 BUG: Opening a Long-Running View from SQL Server Enterprise Manager Gets ODBC Timeout
253673 PRB: Recordset Based on SQL Server View Updates Base Tables
253817 How to back up the last transaction log when the master and the database files are damaged in SQL Server
260249 DSN network library shown as "Other" in ODBC Administrator
266277 PRB: Using the Visual Studio 6.0 and Access 2000 Visual Database Tools with SQL Server 2000
271619 How To Retrieve XML Data by Using an XPath Query in a Visual Basic Client
271620 How To Retrieve XML Data by Using a SQL XML Query in a Visual Basic Client
271621 How To Retrieve XML Data with a Template File from a Visual Basic Client
271689 How To Run Singleton SELECT Queries in a Visual Basic Client
271775 SAMPLE: How To Retrieve Relational Data Using OpenXML with ADO in Visual C++
271780 SAMPLE: How To Retrieve XML Data Using an SQL XML Query with ADO in Visual C++
271782 SAMPLE: How To Retrieve XML Data Using an XPath Query with ADO in Visual C++
272176 SAMPLE: How to Run Singleton SELECT Queries in Visual C++
272177 SAMPLE: Using OLEDB Templates to Retrieve XML Data Through XPath Query
272180 SAMPLE: How to Retrieve XML Data Using a Template File with ADO in Visual C++
272181 SAMPLE: How to Retrieve Data Using a Template File in ATL OLE DB
272185 SAMPLE: How to Retrieve Data Using a SQL XML Query in ATL OLE DB
272269 How To Retrieve XML Data by Using a SQL XML Query in an ASP Client
273791 XADM: MDAC 2.6 Breaks ADO MoveNext() Function with Exchange 2000
273813 FIX: "Incorrect Syntax near the Keyword 'by' " Error Message with Column Names of "C", "CA" or "CAS"
274773 FIX: If You Change Windows Security to Windows/SQL Security the SA Password is Blank
276426 FIX: Msxml2.dll Fails to Register on 32-Processor Computer During MDAC 2.6 Installation
278636 Application errors occur after you run Xmlinst.exe on production servers
278872 How To Specify Parameters for an XML Template Query from Visual Basic
279526 FIX: SQL Server ODBC Driver Ignores Authentication Setting
280067 PRB: Retrieving very large XML Documents from SQL Server 2000 by using ReadText method of ADO stream object may be slow
280294 FIX: SQL Server ODBC Driver reuses incorrect parameter length
281633 FIX: SQLOLEDB Provider incorrectly leaves transaction open
285006 FIX: You receive error message 6603 or text data may be truncated when you select a text data type through the OPENXML provider in SQL Server 2000
285295 SQL Server 2000 changes name of RETURN_VALUE to @RETURN_VALUE
286359 FIX: SQL Server ODBC Driver Generates Error When Executing a Stored Procedure on SQL Server 2000
286370 PRB: OpenQuery Function Fails with Queries That Exceed 8000 Characters
286442 PRB: MDAC 2.6/2.7 Roll Back Installation or Get Error on Install
287753 PRB: ExOleDB Provider Doesn't Work with SQL Server 2000 DTS Tool
288054 SAMPLE: RLockMFC.exe Demonstrates Row-Level Locking Using MFC and SQL Server
289573 PRB: Configuring DSNs with SQL Server Net-Libraries
290175 FIX: SQL Server ODBC Driver Does Not Transfer Return Values from Stored Procedures
291838 FIX: Crash in SQLXMLX Hangs Web Service Threads
293107 Clients cannot communicate to SQL Server through port 1433 or the port SQL Server is listening on
294160 BUG: Update of Newly Inserted Row Causes DB_E_ERRORSOCCURRED
295054 FIX: Insert with OPENXML Statement Generates Duplicate Key Error
295757 FIX: Second SQLExecute on Prepared Statement with SQL_NOSCAN_ON Causes Client-Side AV
297502 PRB: Error -2147217887 "No Error Description" When You Send SQL Text Field to Output Stream
300420 FIX: Connection to SQL Server Database Using IP Address Is Unusually Slow
302248 FIX: SQLOLEDB Does Not Work with DBACCESSOR_OPTIMIZED Flag and SSPROP_ENABLEFASTLOAD
303446 FIX: SQLOLEDB Returns No Data When Using AutoFetch Option with Fast Forward Cursors