1981) 12/8/2001 Q306853Q306853  Q306853.html">FIX: SQL Server Enterprise Manager Restore Database Wizard Restores Database to Different Location or Name (Q306853)
If you use the SQL Server Enterprise Manager

1982) 12/8/2001 Q300478Q300478  Q300478.html">BUG: Print Jobs from Query Analyzer Fail to Complete Spooling (Q300478)
Print jobs from Query Analyzer may not successfully complete the spooling process in the Print Spooler. Moreover, you may be unable to cancel or delete these print jobs in the Print Spooler.

1983) 12/8/2001 Q306908Q306908  Q306908.html">INF: List of Bugs Fixed by SQL Server 2000 Service Packs (Q306908)
This article provides information about the bugs fixed by SQL Server 2000 service packs. Because service packs are cumulative, subsequent service packs also fix the bugs fixed by previous service packs. For example, SQL Server 2000 Service

1984) 12/8/2001 Q295589Q295589  Q295589.html">BUG: Node in SQL Server 2000 SP1 Clustered Virtual Server Contains Mismatched Binaries (Q295589)
If either of the following conditions is true

1985) 12/8/2001 Q308843Q308843  Q308843.html">PRB: Non-Unique Clustered Index on a Published Table Causes Incorrect Data to Replicate to Subscribers (Q308843)
In a transactional publication, if you add a non-unique index on a table that you have defined as an article, incorrect data may replicate to Subscribers. For example, blank spaces might be included for the variable length columns.

1986) 12/8/2001 Q301913Q301913  Q301913.html">BUG: Error "There is not enough space on drive" When Extracting SQL Server 2000 SP1 (Q301913)
When you attempt to extract SQL Server 2000 Service Pack 1 (SP1) (Sql2ksp1.exe) or Service Pack 2 (SP2) (Sql2ksp2.exe), if the free disk space on your computer is approximately between 12 GB and 13 GB, you may encounter the following error

1987) 12/8/2001 Q300516Q300516  Q300516.html">INF: Readme.txt Files for SQL Server 2000 Service Packs (Q300516)
The Readme.txt file for SQL Server 2000 Service Pack 2 (SP2) is available at the following Microsoft Web site:

1988) 12/8/2001 Q300447Q300447  Q300447.html">FIX: Snapshot Delivery Failure During BCP IN Not Recognized by Merge Agent (Q300447)
When any error occurs during a BCP IN operation while a snapshot is being delivered by the Merge Agent, the Merge Agent reports an error message similar to:

1989) 12/8/2001 Q296186Q296186  Q296186.html">FIX: Incorrect Results In Cube Editor When You Edit a Dependent Calculated Member or Calculated Cell (Q296186)
When you edit a calculated member or a calculated cell that has a dependent calculated member or calculated cell, either #ERR appears in the browser of the Cube Editor or incorrect values and the order of the calculated members are incorrec

1990) 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

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

1992) 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

1993) 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

1994) 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

1995) 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.