Summary
Following is part 1 of a list of fixes and other various improvements that have been made in Service Pack 1 (SP1) for Microsoft SQL Server 2000. For more information, contact your primary support provider. For additional listings, click the article numbers below to view the articles in the Microsoft Knowledge Base:
300538 INF: List of Bugs Fixed in SQL Server 2000 Service Pack 1 (2 of 2)
300634 INFO: List of Bugs Fixed in MDAC 2.6 Service Pack 1To determine which Service Pack level your SQL Server server is currently running, run the following statement from the SQL Server Query Analyzer window:
SELECT @@version
The result of this query is: 8.00.194 if SQL Server 2000 with no service pack applied 8.00.384 if SQL Server 2000 Service Pack 1 Please note that the workarounds described in these articles are provided for information only. You do not need to implement these workarounds if you have the updated software.For more information about each corrected problem in Service Pack 1 for Microsoft SQL Server 2000 (build 8.00.384), either click the link or use the Qxxxxxx number to query for the article in the Microsoft Knowledge Base.To view the Service Pack 1 Readme.txt file that accompanies the Service Pack 1, see the following article in the Microsoft Knowledge Base:
300516 INF: Readme.txt File for SQL Server 2000 Service Pack 1For additional information on obtaining SQL Server 2000 Service Pack 1, click the article number below to view the article in the Microsoft Knowledge Base:
290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
More Information
Service Pack 1
SQL Server 2000Bug ID:135046
288188 FIX: DTS Package Reports Success When FTP Task Doesn't Transfer All FilesBug ID:201136
290915 FIX: CREATE for Existing Object with IDENTITY Column Causes Duplicate IDENTITY ValuesBug ID:203148
285544 FIX: Dividing 0 by a Negative Decimal or Numeric Number Results in -0Bug ID:217586
293849 FIX: Statistics Maintenance Creates Significant Bottleneck on SQL Servers that Use 16 or More CPUsBug ID:218543
275618 FIX: Cannot Set SQLServerAgent Password to More Than 16 Characters in Enterprise ManagerBug ID:218599
279015 FIX: SQL Server Does Not Run RESTOREVERIFYONLY When Scheduling a Back Up in SQL Enterprise ManagerBug ID:230243
295378 FIX: SQLAgent Job with Recurring Schedule Is Disabled Upon Completion of the Schedule for the DayBug ID:234529
299649 FIX: Merge Replication Agent Fails with Error Message: "Unable to replicate a view or function"Bug ID:234551, 235869
281287 FIX: Msg 8964 on Index with IGNORE_DUP_KEY and Row Has a Text ColumnBug ID:234619
295120 FIX: OK Button for Changing the Recovery Model or the Compatibility Level in SQL Enterprise Manager is DisabledBug ID:234633
280747 FIX: UPDATE Statement on a Clustered Index Key Fails with Error 547Bug ID:234652
295936 FIX: Error Removing Log Shipping on Secondary Database When Database Name Has a QuoteBug ID:234705
286119 FIX: Incorrect Behavior in SQL Server Profiler Event GenerationBug ID:234858
295047 FIX: Full-Text Indexes Are Scripted Before Table Indexes Causing DB Creation Script FailureBug ID:234864
295048 FIX: Cannot Script Full-Text Indexes for Tables with No Primary Keys Even if Another Unique Index ExistsBug ID:234991
291277 FIX: ServerNet II Library Does Not Display if Giganet Driver is Not AvailableBug ID:235019
290916 FIX: fn_virtualfilestats Skips the Last FileBug ID:235027
298923 FIX: sp_MsHelpmergeconflictcounts Returns No Row Against the Chinese Name Table on English Windows 2000Bug ID:235040
290128 FIX: SQL Server Resource DLL May Fail to Log to the Event Viewer in a ClusterBug ID:235056
300380 FIX: Intense Database Backup Stress Causes BackupSync to Generate an Assertion when Releasing MemoryBug ID:235060
294985 FIX: SQL Server Agent Proxy Account Not Cleaned Up When Instance Is UninstalledBug ID:235085
289851 FIX: Creating a New Unique Named Pipe Alias Displays the Default Pipe Value Instead of the Entered ValueBug ID:235091
303228 FIX: Queue Reader Agent Fails if the Distributor is a Clustered SQL ServerBug ID:235118
290414 FIX: Index Tuning Wizard Fails to Remove Hypothetical Clustered IndexesBug ID:235175
295668 FIX: Transaction Replication to DB2 Subscribers Incorrectly Map Tinyint Data Type if You Use DTS to Transform Published DataBug ID:235210
300388 FIX: SQL Server Profiler Stops Responding When Saving Output to Hard Disk That Is Out of SpaceBug ID:235253
300391 FIX: Profiler Replay Output File Does not Show Events When Looking at PropertiesBug ID:235295
287234 FIX: No Vertical Scroll Bar in DTS Dynamic Properties Task Properties Dialog BoxBug ID:235326
299543 FIX: ActiveX Transformation Function Not Triggered if LastRow Option in DTS Transform Data Task Is Less Than or Equal to Actual Number of Source Table RowsBug ID:235343, 353327, 353326
272737 FIX: SQL Server Profiler Generates Error when Reading Trace Files that Exceed 1023 SPIDsBug ID:235348
290369 FIX: Updates to New Column Added to Merge Publication Article are not ReplicatedBug ID:235377
301579 FIX: "Unspecified error" Raised When Working with DTS Packages on Localized SQL Server 2000Bug ID:235391
299323 FIX : DBCC CHECKTABLE May Fail if Corruption Exists in IndexesBug ID:235394
299362 FIX: Failover of a SQL Virtual Server Causes Problems with Active Directory IntegrationBug ID:235408
295051 FIX: Changing SQL Server Account to Non-Admin for Full-Text Search Makes Existing Catalogs UnusableBug ID:235412
295461 FIX: Profiler Fails To Start New Trace When User Environment Variable Has Been ChangedBug ID:235435
292237 FIX: xp_startmail Does Not Start Default Profile on Nondefault InstanceBug ID:235489
271945 FIX: SQL Agent Appends Garbled Characters to Output FileBug ID:235494
287405 FIX: Access Violation Occurs When You Use the Server Network Utility Without Administrator Privileges on ComputerBug ID:235501
290055 FIX: Error Message: "The process can not add message to message queue. The step failed"Bug ID:235508
285290 FIX: Complex ANSI Join Query with Distributed Queries May Cause Handled Access ViolationBug ID:235565
298835 FIX: Delete From Partition View that Contains Text or Image Data May Cause ErrorBug ID:235577
299857 FIX: Trigger May Not Fire if Query Plan Uses CONSTANT SCAN OperatorBug ID:235592
284440 FIX: UPDATE with CASE Statement That Uses NEWID() Function Causes Errors 8951, 8952, 8955 and 8956Bug ID:235596
286503 FIX: Publication Options Disabled When Create Publication Wizard Launched from DTS Import/Export WizardBug ID:235696
295114 FIX: SELECT * FROM SYSINDEXES On a Database Upgraded From SQL Server 7.0 May Cause an Access ViolationBug ID:235700
287167 FIX: Some Full-Text Search Failures Do Not Set @@ERRORBug ID:235701
291276 FIX: Startup Stored Procedures Don't Execute with AWE Support EnabledBug ID:235717
297369 FIX: Incorrect Error Occurs When You Add Merge Article to a Publication with NO SYNC SubscriberBug ID:235751
289878 FIX: Locking on File Header Pages Is Reported IncorrectlyBug ID:235754
291001 INF: How to Use sp_scriptdynamicupdproc to Improve the Performance of Update Custom Procedures in SQL Server 2000 Transactional ReplicationBug ID:235838
278978 FIX: SELECT May Not Return All Rows if It Contains a Large Number of Values in an IN Clause on a NUMERIC ColumnBug ID:235843
286750 FIX: Data Transfer Using ODBC Driver for SQL Server FailsBug ID:235865
295002 FIX: SQL Server 2000 Setup Does Not Install Jet Drivers Help FileBug ID:235883
286773 FIX: DTS FTP Task Does Not Behave as Expected if Destination Is Out of Space or the Destination File ExistsBug ID:235884
293223 FIX: Problems Saving DTS Packages to Visual Basic Files Using the DTS User InterfaceBug ID:235895
287713 FIX: Problems with DTS UI Help TopicsBug ID:235974
295027 INF: Limited Support for Savepoint in Distributed Transactions in SQL Server 2000 Service Pack 1Bug ID:236001
276043 FIX: Error Message 5180 May Occur When You Retrieve Text or Image Data
Bug ID:236010
300172 FIX: sp_addmergearticle May Fail with Error 20009 if Article Added Is Vertically FilteredBug ID:236030
299462 FIX: Dump of Internal Structures while Users Connect or Disconnect May Cause Access ViolationBug ID:236045
295466 FIX: Affinity Mask Option in sp_configure Does Not Support 32 ProcessorsBug ID:236046
299466 FIX: Running Stack Dumper Causes Memory Leak of Virtual BytesBug ID:236053
294311 FIX: Trigger Does Not Return Expected Duplicate Key Insert Error to ClientBug ID:236072
292454 FIX: Update Queries with OpenXML Table Aliases Cause Access ViolationBug ID:236087
274224 FIX: Using SQL Server 2000 Merge Modules May Result in Confusing MessageBug ID:236107
274329 FIX: Optimizer Slow to Generate Query Plan for Complex Queries that have Many Joins and Semi-JoinsBug ID:236111
294388 FIX: Reading Perflib Registry Values Terminates SQL Server Startup with Fatal ExceptionBug ID:236112
274330 FIX: Sending Open Files as Attachment in SQL Mail Fails with Error 18025 Bug ID:236115
290082 FIX: Failed Server-Side Retail Assertion in Merge Replication with SQL Server CE ClientsBug ID:236124
286268 FIX: User and Owner Passwords are Dimmed When You Save a Package as a File By Using DTSWIZBug ID:236129
295551 FIX: Text Pasted in Query Analyzer Result Window Is Not VisibleBug ID:236137
286234 FIX: Suboptimal Execution Plan on an Indirect UPDATE to an Indexed ViewBug ID:236142
285006 FIX: XML Parsing Error 6603 or Truncated Text Data with OPENXMLBug ID:236167
274266 FIX: Data Modification Query with a Distinct Subquery on a View May Cause Error 3624Bug ID:236173
298830 FIX: Error Message: "Cannot Start 'Config XML support in IIS for SQL Server'"Bug ID:236178
275900 FIX: Linked Server Query with Hyphen in LIKE Clause May Run SlowlyBug ID:236191
280744 FIX: Update Query Returns Error 1903 if Temporary Composite Index Over 900 BytesBug ID:236195
300500 FIX: Server Name is not Being Populated on the Client Side (UI or File) in SQL Server Profiler Bug ID:236220
288340 FIX: Errors in Transform Failure Function Are Logged When They Should Be IgnoredBug ID:236230
290080 FIX: Assert Occurs When You Try to Alter a Database and Trace Flag 902 is EnabledBug ID:236233
290083 FIX: FOR XML EXPLICIT: Conflict Attribute in xmltext Is Not Overwritten if xmltext Contains DBCSBug ID:236274
293155 FIX: BCP with Format File and -R Parameter Ignores Regional SettingsBug ID:236293
278509 FIX: Distribution Agent Ignores Quoted Identifier Option on Initial Sync to Oracle SubscribersBug ID:236309
274773 FIX: If You Change Windows Security to Windows/SQL Security the SA Password is BlankBug ID:236325
276329 FIX: Complex Distinct or Group By Query Can Return Unexpected Results with Parallel Execution PlanBug ID:236329
290415 FIX: Use of the Jet Provider to Query a Linked Server Text File from SQL Server May Be Very SlowBug ID:236374
290351 FIX: SQL Server Assertion During Distributed TransactionBug ID:236375
289893 FIX: Current Row's Time if Empty Is Replaced by Previous Row's Time in Bulk CopyBug ID:236394
293464 FIX: Merge Replication Does Not Log Conflicts after Successively Adding and Dropping ColumnsBug ID:236400
275901 FIX: SQL RPC That Raises Error Will Mask @@ERROR with Msg 7221Bug ID:236421
300183 FIX: SQL Server Cluster Resource Fails to Come Online Until Cluster Service Is RestartedBug ID:236443
279296 FIX: Using ALTER TABLE to Change Column Type Can Result in Unexpected NULL Values on INSERTBug ID:236453
280294 FIX: SQL Server ODBC Driver Reuses Incorrect Parameter LengthBug ID:236456
294420 FIX: Logreader Fails to Select Text Data that is Inserted by SQL Server 6.5 Bcp UtilityBug ID:236457
277640 FIX: Denial of Service Attack with NULL Bytes in RPC Request
298012 Malformed RPC Request Can Cause Service ProblemsBug ID:236561
295373 FIX: Creating Indexes in Parallel May Fail with Deadlock on SysindexesBug ID:236588
279659 FIX: SQL Server 2000 Takes Much Longer to Compile the Query Against Local Partitioned View Than SQL Server 7.0Bug ID:236595
288957 FIX: Multiple Calls To a User Defined Function Within an Aggregate Function May Return Incorrect ResultsBug ID:236625
267953 FIX: Interleaving Prepare And Adhoc Execute of Query May Cause Recompile LoopBug ID:236630
290353 FIX: Updating View Based on Partitioned View May Result in AssertionBug ID:236633
293329 FIX: Attaching Database Files Saved In Different Disk Folders Through SQL Enterprise ManagerBug ID:236658
301627 FIX: Error Message: "ICE03 Invalid template string" Reported by MSIVal2 Bug ID:236652
281293 FIX: SQL Mail 2000 Needs Microsoft Outlook 2000 ClientBug ID:236682
297104 FIX: Backup or Restore Using Large Transaction Logs May Return Error 3241Bug ID:236752
293784 FIX: Unable to Drop a Catalog When Disk Is FullBug ID:236753
278698 FIX: Exception Access Violation Encountered During Compile of Hash Match Team PlanBug ID:236765
279295 FIX: Parallel Index Creation on Large SMP Hardware Can Cause Handled Access ViolationBug ID:300104
286775 FIX: Creating a Publication From Within DTSWIZ Fails with "Error 496: General Error" Error MessageBug ID:300108
293489 FIX: Merge Replication with Dynamic Filters May Cause MMC to FailBug ID:350775
279183 FIX: Scripting Object with Several Extended Properties May Cause ExceptionBug ID:350799
279293 FIX: CASE Using LIKE with Empty String Can Result in Access Violation or Abnormal Server ShutdownBug ID:350879
279123 FIX: SQL Server 2000 Uninstallation May Break SQL Server CE ReplicationBug ID:350886, 236168
292456 FIX: GetColumnInfo Returns Incorrect Column InformationBug ID:350894
294783 FIX: Addition of a Column to an Incrementally Added Article Prior to Snapshot Generation FailsBug ID:350896
299914 FIX: Executing MAX or MIN Aggregate Functions on Column with Hypothetical Clustered Index May Result in CPU SPINBug ID:350899
299470 FIX: SELECT with Distinct and Self Loop Join May Cause 1203 Error MessageBug ID:350911
292637 FIX: Unicode Character String Longer Than Seven Bytes in a LIKE Clause Is Truncated in Execution PlanBug ID:350912
288174 FIX: Modifying a Table with DRI Cascade That Is Involved in an Indexed View May Cause Msg 8624Bug ID:350933
287401 FIX: Unable to Use GOTO in an Execute SQL Task of a DTS PackageBug ID:350958
297156 FIX: Snapshot Agent Error Occurs While Adding Table with a Space in Name to an Existing Merge PublicationBug ID:350970
300217 FIX: "Update Index in Background" Option in Change Tracking May Not Work if Very Low Disk Space DetectedBug ID:350984
300037 FIX: Error 229 "EXECUTE permission denied on object xp_mapdown_bitmap" on Merge Published TableBug ID:351022
285979 FIX: Changing Autostart Options for Named Instances Change Autostart Settings for the Default InstanceBug ID:351023
303119 FIX: Upgrade to SQL Server 2000 Cluster Does Not Add All SQL Server Resource DependenciesBug ID:351025
279338 FIX: DBCC CHECKCONSTRAINTS Does Not Handle Names with Special CharactersBug ID:351080
291275 FIX: sp_replsetoriginator May Generate Access Violation in Bidirectional Transactional ReplicationBug ID:351081
290592 FIX: Full-Text Rows Missing After Crawl Due to Full DiskBug ID:351097
295030 FIX: Index Tuning Wizard Execution May Generate Floating Point ExceptionBug ID:351119
299382 FIX: Zeros Incorrectly Removed from the Binary Column in SQL ProfilerBug ID:351128
279804 FIX: INSERT Statement Incorrectly Conflicts with ConstraintBug ID:351140
279867 FIX: Sending Maintenance Report by E-mail to Operator Fails in Maintenance PlanBug ID:351147
282416 FIX: Opening the Database Folder in SQL Server Enterprise Manager 2000 Takes a Long TimeBug ID:351185
293345 FIX: ANSI Script from Profiler Cannot be Opened in Query AnalyzerBug ID:351188, 351189
280380 FIX: Buffer Overflow Exploit Possible with Extended Stored ProceduresBug ID:351196
280846 FIX: Merge Snapshot Agent May Fail With Syntax Error Message When Published Table Contains Computed ColumnsBug ID:351222
282455 FIX: SQL Server Fails to Start When Computer Binds 48 or More Socket AddressesBug ID:351225
282243 FIX: Incorrect Results with Join of Column Converted to BinaryBug ID:351229
295039 FIX: Assertion Raised When DELETE Is Performed on a Table Joined with a ViewBug ID:351230
288996 FIX: System View Sysopentapes Can Be DroppedBug ID:351235
289551 FIX: Generate SQL Script in Enterprise Manager Generates Scripts in Wrong Sequence if the Table has User-Defined Function as Computed ColumnBug ID:351242
293761 FIX: Dynamic Filtered Tables Do Not Replicate Data From Joined Tables to SQL Server CE SubscribersBug ID:351243
287606 FIX: Enterprise Manager Reports Table Sizes That Are Inconsistent as Compared to sp_spaceusedBug ID:351259
286255 FIX: UNION Query Returns Internal Query Processor Error Message 8623Bug ID:351266
290642 FIX: Exists with Full Outer Join May Generate Access ViolationBug ID:351268, 351286
281843 FIX: SQLDMO GetProcessInputBuffer Returns Incorrect ResultBug ID:351300
294970 FIX: Distribution Agent Fails with Syntax Error with Compensating Commands for Queued Updating SubscribersBug ID:351305
286249 FIX: Complex Update Statement Returns 8624 Internal SQL Server ErrorBug ID:351307
299366 FIX: Calling Remote Stored Procedure Inside Local Stored Procedure While Passing Text Parameter Causes AVBug ID:351327
294415 FIX: Resource Does Not Failover Immediately if an Error is Encountered by the Resource DLLBug ID:351328
295032 FIX: Job Step Fails if First INSERT of Batch Job Encounters a Msg 3604 ErrorBug ID:351337
295325 FIX: Replication in Turkish Collation Fails with Error Message: "Error 21112: '-PollingInterval' is not a valid parameter for the Log Reader Agent"Bug ID:351342
281238 FIX: xp_findnextmsg Does Not Return a Value for @msg_id Parameter on OutputBug ID:351343
281239 FIX: xp_findnextmsg Returns Multiple Rows When No Parameters Are SpecifiedBug ID:351363
282229 FIX: SP_OA Procedures Leak Memory and Cause Various ErrorsBug ID:351373
284228 INF: New Trace Flag to Enhance Stored Procedure ReplicationBug ID:351375
282279 FIX: Execution of sp_OACreate on COM Object Without Type Information Causes Server Shut DownBug ID:351376
286565 FIX: SQL Server Process Terminates Attempting to Reset from an sp_OA Based BatchBug ID:351394, 352221
288122 FIX: Lock Monitor Uses Excessive CPUBug ID:351407
288189 FIX: DTS FTP Task May Fail to Download Files After a Network ProblemBug ID:351431
299361 FIX: Timestamp Column Truncated When Replicating with Sybase Using Merant OLEDB ProviderBug ID:351441
283825 FIX: DBCC DBREINDEX Does Not Keep Original FillfactorBug ID:351450, 352729
293328 FIX: Update Query Does Not Execute CorrectlyBug ID:351471
292455 FIX: OSQL Does Not Display Column Names for QueryBug ID:351474
289149 FIX: A Query That Uses Hash Match Teams May Fail with 8630 Error MessageBug ID:351486
299865 FIX: DMO BulkCopy fails to copy data when column names contain the space characterBug ID:351502
286253 FIX: Multiple SQL Agent Jobs Launched At The Same Time May Fail With Primary Key Error MessageBug ID:351513
286788 FIX: Server Side Cursor May Return Incorrect ResultsBug ID:351566
282982 FIX: Suboptimal Performance Using a Cursor to Update a Heap Involved in an Indexed ViewBug ID:351620
291780 FIX: DTS Transfer Objects May Fail if Dependent Objects Are Not in Alphabetical OrderBug ID:351634, 351180
290917 FIX: Incorrect Identity Values After Failed Unique Index CreationBug ID:351653
290643 FIX: Microsoft Search Service Cannot be Stopped During Large PopulationBug ID:351658
299544 FIX: Correlated Subquery Containing UNION ALL May Cause Access ViolationBug ID:351669
294459 FIX: Can't Use Four-Part Name to Query Oracle Table if Name Contains Lowercase CharactersBug ID:351682
290058 FIX: SQL Mail Procedures May Intermittently Fail with Error 0x8004010fBug ID:351686
286774 FIX: SQL Server 2000 Cluster Setup Fails with "Entry Point for DllCNVREM.dll not found" Error MessageBug ID:351698
293758 FIX: Nullability Changes not Handled by SQL Server with Linked Server Queries to DB2Bug ID:351714
285952 FIX: NO_TRUNCATE May Be Added to Backup Log Statement when You Perform a Log Backup from SEMBug ID:351729
291376 FIX: Cannot Use Dynamic SQL Statements Within OPENQUERYBug ID:351736
295053 FIX: OPENXML May Leak Worktables in MemoryBug ID:351754
289880 FIX: SQL Server Assertion Failure Occurs if Recovery Model of TempDB is not SIMPLEBug ID:351761
285870 FIX: Update With Self Join May Update Incorrect Number Of RowsBug ID:351773
292755 FIX: Full-Text Queries May Return "Unspecified Error" Error MessageBug ID:351791
290921 FIX: UPPER and LOWER Functions Return Metadata Length as if DBCS Were UsedBug ID:351797
289739 FIX: Distributed Query with Optika Provider May Return Incorrect ResultsBug ID:351829
275145 FIX: Only One SQL Server Performance Condition Alert Is Treated As ActiveBug ID:351866, 351704
295034 FIX: Microsoft Search Service May Cause 100% CPU Usage if BUILTIN\Administrators Login Is RemovedBug ID:351892
286737 FIX: FetchBufferSize Greater than Certain Number Fails to Transfer all Rows and Does Not Return an ErrorBug ID:351894
280720 FIX: xp_sendmail Generates UNICODE CSV File FormatBug ID:351901
289475 FIX: SQLAgent Incorrectly Uses TLSAlloc for Transact-SQL Jobs Causing all TLS Slots to be ExhaustedBug ID:351918
295037 FIX: MERGE UNION Is Not Used with Large Number of UNION ClausesBug ID:351920
290085 FIX: Extended Stored Procedure "xp_logevent" Generates an Access Violation when Given Too Large a ParameterBug ID:351927
294338 FIX: xp_enumgroups Generates an Access Violation when Passed a Large ParameterBug ID:351939
286749 FIX: Table Creation, Row Insertion, and Index Creation Inside Transaction, Followed By Addition of Constraint May Result in Consistency ErrorsBug ID:351941
293292 FIX: DBCC CHECKDB May Produce an Access Violation When Database Is in UseBug ID:351948
290644 FIX: DTSRun.exe Causes Access Violation on SMP ComputersBug ID:351952
290739 FIX: Iterating Through SQL Mail Messages Using Extended Procedures Takes Longer in SQL Server 2000Bug ID:351953
290210 FIX: Removal of Full-Text Index May Incorrectly Remove Rows From sysdepends System TableBug ID:351984
299448 FIX: Subquery That References Table with No Statistics and Returns Empty Result Set May Cause AVBug ID:351990
291851 FIX: Merge Replication Stored Procedures May Be Scripted Incorrectly When an Article is in Two PublicationsBug ID:352016
299937 FIX: Changes to Indexed View Article of a Transactional Publication Are Not SavedBug ID:352024
298402 INF: Understanding How to Set the SQL Server I/O Affinity OptionBug ID:352036
289691 FIX: Sysprocesses Is Incorrectly Showing Rollback Status Even Though the Transaction Is Not Rolling BackBug ID:352038
303224 FIX: Use of the Copy Database Wizard to Copy a Database Disables Full-Text Indexing on the Source DatabaseBug ID:352051
299787 FIX: Skewed Replication Statistics in Output File When Running Agent ContinuouslyBug ID:352074
290077 FIX: DTS Scheduled Job Does Not Complete After First RunBug ID:352077
291540 FIX: Instead of Triggers that Use Work Tables Cause a Memory LeakBug ID:352081
300272 FIX: Transfer of a View that Contains a UDF by Using DTS Export Data Fails with Error 208Bug ID:352082
300194 FIX: Error 644 Using Two Indexes on a Column with Uppercase Preference Sort OrderBug ID:352091
288426 FIX: Alerts Triggered Incorrectly When Security Auditing is EnabledBug ID:352092
295045 FIX: SELECT DISTINCT Returns Incorrect Results in SQL_Latin1_General_Pref_Cp1_CI_AS CollationBug ID:352098
290918 FIX: Incorrect Behavior of LIKE [-] When Using an IndexBug ID:352099
294929 FIX: MSDE Installation Contains the Wrong Icon for the Service ManagerBug ID:352114
299889 FIX: Full Population May Not Complete if Microsoft Search Service Is Stopped and RestartedBug ID:352142
289472 FIX: SQLAgent Exception Occurs when the System Maintains 613, 2661 or 4709 JobsBug ID:352148
290413 FIX: DB-Library sp_cursor Fails with Error Message 16933 if Bracketed Identifiers are Passed with the Tablename ParameterBug ID:352211
290645 FIX: SQL Server Active Directory Registration Always Reports SuccessBug ID:352213
300180 FIX: sp_MSexpandnotbelongs May Be Called at Publisher Due to Invalid Evaluation of Join FilterBug ID:352217
292761 FIX: xp_startmail Error Message Does Not Indicate ProblemBug ID:352230
302421 FIX: Query Issued Against Two Instances of the Same Table May Cause an Access ViolationBug ID:352255
292737 FIX: Drag and Drop Object Type Node to the Editor in Query Analyzer Returns Error MessageBug ID:352264
291274 FIX: Correlated Subquery on Partitioned Views with Text Operations May Cause Access ViolationBug ID:352271
291273 FIX: SQLMail Incorrectly Uses Default Mail ProfileBug ID:352297
293166 FIX: Parallel Modification Operation May Spin Trying to Release LocksBug ID:352303
294999 FIX: SQL Server Fails to Start with \f Option on Computers with Many CPUsBug ID:352312
290814 FIX: xp_readmail Leaks Memory if Message Contains AttachmentBug ID:352320
293430 FIX: SEM New SQL Server Registration Using Long Server Name Fails with Access ViolationBug ID:352326
298803 FIX: Coalesce with Subquery May Generate an Access ViolationBug ID:352345
291566 FIX: Parallel Plan for Index Creation of Non-Clustered Index May Result in Use of Pages That are not AllocatedBug ID:352358
300056 FIX: Merge Metadata Cleanup May Cause Subscriber Transaction Log to Grow QuicklyBug ID:352372
292753 FIX: Some Object Browser Folders Cannot Be ScriptedBug ID:352404
291235 FIX: Query Analyzer Hangs After You Drag && Drop Files Into the Query Editor and You Close One of the Newly Created WindowsBug ID:352492
296685 FIX: Cannot Execute SELECT COUNT(*) Against DB2 on Mainframe Using Four-Part NameBug ID:352500, 351440
288330 FIX: FTP Task in DTS Deletes File from the Destination Folder After the Package Completes ExecutionBug ID:352501
294902 FIX : Rollback to Savepoint Causes Assertion and ErrorsBug ID:352555
295022 FIX: Sqlmaint.exe Is Not Available with MSDE 2000Bug ID:352575, 352695
293232 FIX: Undetected Deadlock Occurs When Lock Owner Is Waiting on CXPACKETBug ID:352606
299602 FIX: Extended Stored Procedure xp_sendmail Does Not Handle DBCS CorrectlyBug ID:352608
295459 FIX: sp_helptext Fails with Invalid Length Parameter ErrorBug ID:352640
286286 FIX: LOCK_TIMEOUT Causes Transaction to Roll Back and @@error Does Not Capture Error 1222Bug ID:352700
294874 FIX: Combination of Multiple EXIST, OR, and Subquery Clauses May Give a Sub-Optimal PlanBug ID:352705
294787 FIX: Update Plan with User Defined Function May Fail to Find a PlanBug ID:352735
293632 FIX: EventSubClass Column Incorrect for Deadlock Chain EventsBug ID:352765, 353201
298951 FIX: Snapshot Agent for Merge Publication May Fail with 107 ErrorBug ID:352793
293484 FIX: Incorrect Record is Deleted or Updated When a Clustered Index is in Descending OrderBug ID:352799
295644 FIX: Transaction Log Restores May Fail with 3456 ErrorBug ID:352807
295046 FIX: OLE Automation Fails When Calling ADODB.Connection MethodsBug ID:352826
299285 FIX: Query with Complex Correlated Subquery May Cause Unexpected Results in Aggregate FunctionsBug ID:352830
295055 FIX: sp_OAMethod Does Not Convert Numeric Datatype CorrectlyBug ID:352839
294872 FIX: Update on a Table with INT and BIT Columns May Zero Out INT ColumnsBug ID:352847
302409 FIX: Unable to Connect to SQL Server 2000 When Certificate Authority Name Is the Same As the Host Name of the Windows 2000 ComputerBug ID:352867
295023 FIX: "SET ROWCOUNT" May Cause Data to be UnreadableBug ID:352935
295113 FIX: Corrupted TDS Packets Cause Access Violation in SQL ServerBug ID:352963
299903 FIX: sp_scriptpublicationcustomprocs Generates Replication Stored ProceduresBug ID:353011, 353081
294828 FIX: Passing a Large Command Line String to Query Analyzer Results in Assertion FailedBug ID:353031
294839 FIX: No Error Message Generated by Query Analyzer When You Try to Open a Database with a Name Greater Than 128 CharactersBug ID:353107
295006 FIX : OSQL Utility Returns Incorrect Error MessageBug ID:353170
294412 FIX: SQLAgent T-SQL Job Does Not Respect SET NOCOUNT ON When Sending Output to FileBug ID:353206, 352955
294860 FIX: Modification Queries May Take Too Long to Compile if Halloween Protection is Required for Multiple TablesBug ID:353275
295193 FIX: Merge Module Sqlsvr.msm Fails Validation with ICE03Bug ID:353324
295627 FIX: Xp_readmail May Cause System to Stop Responding in Windows 95 or Windows 98Bug ID:353326
272737 FIX: SQL Server Profiler Generates Error when Reading Trace Files that Exceed 1023 SPIDs Bug ID:353344
299620 FIX: Cannot Use a Profile Name Longer Than 32 Characters with SQL MailBug ID:353394
296098 FIX: xp_sendmail Fails with the @attach_results Parameter on SQL Server 2000 Personal EditionBug ID:353405
299351 FIX: MSDE Installation Fails on Systems That Have SQL Server 2000 Service Pack 1 InstalledBug ID:353492
300145 FIX: Merge Replication Conflict Viewer Resolves Data Conflicts IncorrectlyBug ID:353641
296465 FIX: Mssearch.exe Memory Leak Occurs when Results are not Completely ProcessedBug ID:354039, 353802
299717 FIX: Query Method Used to Access Data May Allow Rights that the Login Might Not Normally HaveBug ID:354604
301060 FIX: Import of Text File Results in Error "Column Delimiter not found"Bug ID:46409
290646 FIX: SQLColAttribute Returns Incorrect Table Attributes When Table Name Contains a Period
