2941) 12/8/2001 Q290211Q290211  Q290211.html">INF: How to Obtain the Latest SQL Server 2000 Service Pack (Q290211)
Service packs are the means by which Microsoft distributes bug fixes. Service packs keep a product current. Service packs include updates and may include system administration tools, drivers, and additional components, which are convenientl

2942) 12/8/2001 Q280720Q280720  Q280720.html">FIX: xp_sendmail Generates UNICODE CSV File Format (Q280720)
If you execute the

2943) 12/8/2001 Q306865Q306865  Q306865.html">BUG: SQL Server May Not Listen on TCP/IP Sockets When TCP/IP is the Only Protocol (Q306865)
In a SQL Server 2000 custom installation, if TCP/IP is the only selected protocol and all other protocols are disabled, SQL Server may not initialize and listen on TCP/IP sockets. The Server Network Utility shows that it is listening only o

2944) 12/8/2001 Q312637Q312637  Q312637.html">PRB: SQL Server 2000 Service Pack 2 Setup Fails on a Server That Has Certificates Installed and Force Protocol Encryption Set ON (Q312637)
If you apply SQL Server 2000 Service Pack 2 (SP2) to a server that has certificates installed and the

2945) 12/8/2001 Q301217Q301217  Q301217.html">HOW TO: Prebuild a SQL Server CE Database (Q301217)
If you have a large quantity of data in your back-end Microsoft SQL Server database, it can be resource-intensive to have every Microsoft Windows CE device download all of the data by using a replication synchronization process. You can "pr

2946) 12/8/2001 Q260758Q260758  Q260758.html">INF: Frequently Asked Questions - SQL Server 2000 - Failover Clustering (Q260758)
This article covers some of the most frequently asked questions about failover clustering in Microsoft SQL Server 2000 Enterprise Edition, version 8.0.

2947) 12/8/2001 Q195761Q195761  Q195761.html">INF: Frequently Asked Questions - Failover (Q195761)
This article is meant to address frequently asked questions regarding SQL Server 7.0 failover support.

2948) 12/8/2001 Q296438Q296438  Q296438.html">FIX: Error Message 1205 Is Not Returned with the Localized Message Text (Q296438)
If a deadlock occurs, SQL Server chooses one of the deadlocking system process IDs (SPIDs) as the deadlock victim, terminates the SPID, and then notifies the client application by returning error number 1205.

2949) 12/8/2001 Q308401Q308401  Q308401.html">FIX: SQLExecute on a Prepared Statement with SQL_NOSCAN_ON Causes Client-Side AV (Q308401)
When you execute a statement that was prepared with the SQL_ATTR_NOSCAN attribute, you may receive an access violation (AV) as follows:

2950) 12/8/2001 Q301953Q301953  Q301953.html">SQLOLEDB: Unenlisting From Active Transaction Against SQL Server 7.0 Causes Hang and Drain Abort Entry (Q301953)
When using the SQL Server native provider (SQLOLEDB) against a SQL Server 7.0 database, and when running in a transactional context such as MTS or COM+, directly or indirectly releasing an OLE DB session object that is enlisted in a distrib

2951) 12/8/2001 Q302248Q302248  Q302248.html">FIX: SQLOLEDB Does Not Work with DBACCESSOR_OPTIMIZED Flag and SSPROP_ENABLEFASTLOAD (Q302248)
Using the Microsoft OLEDB Provider for SQL Server (SQLOLEDB) that comes with Microsoft Data Access Components (MDAC) version 2.6 or 2.6 SP1, when you set the value of the SSPROP_ENABLEFASTLOAD property to true in the SQLSERVERDATASOURCE pro

2952) 12/8/2001 Q303446Q303446  Q303446.html">FIX: SQLOLEDB Returns No Data When Using AutoFetch Option with Fast Forward Cursors (Q303446)
The SQL Server native provider (SQLOLEDB) may return no data for a VARCHAR field that is larger than 255 characters under the following conditions:

2953) 12/8/2001 Q300420Q300420  Q300420.html">FIX: Connection to SQL Server Database Using IP Address Is Unusually Slow (Q300420)
When Microsoft Data Access Components (MDAC) version 2.6 is installed, each attempt to connect to a SQL Server 7.0 or SQL Server 2000 database using an IP address (rather than the server name) may take longer than anticipated. In certain re

2954) 12/8/2001 Q297035Q297035  Q297035.html">FIX: Correlation Error Using Parameters.Refresh with SQLOLEDB (Q297035)
When executing a parameterized UNION query with the SQLOLEDB OLEDB Provider, the following error may be reported:

2955) 12/8/2001 Q299717Q299717  Q299717.html">FIX: Query Method Used to Access Data May Allow Rights that the Login Might Not Normally Have (Q299717)
Logins that use the SQL Server Authentication (Standard) security mode with a particular query method used to access data from an OLE-DB data source may allow rights that the login might not normally have.