INF: List of Bugs Fixed in SQL Server 2000 Service Pack 1 (1 of 2)
This article was previously published under Q290212 On This PageSUMMARY
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 (http://support.microsoft.com/kb/300538/EN-US/) INF: List of Bugs Fixed in SQL Server 2000 Service Pack 1 (2 of 2)
300634 (http://support.microsoft.com/kb/300634/EN-US/) INFO: List of Bugs Fixed in MDAC 2.6 Service Pack 1
To determine which Service Pack level your SQL Server server is currently running, run the following statement from the SQL Server Query Analyzer window:
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 1Please 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 (http://support.microsoft.com/kb/300516/EN-US/) INF: Readme.txt File for SQL Server 2000 Service Pack 1
For 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 (http://support.microsoft.com/kb/290211/EN-US/) INF: How to Obtain the Latest SQL Server 2000 Service Pack
MORE INFORMATIONService Pack 1SQL Server 2000Bug ID:135046 288188 (http://support.microsoft.com/kb/288188/EN-US/) FIX: DTS Package Reports Success When FTP Task Doesn't Transfer All Files
Bug ID:201136290915 (http://support.microsoft.com/kb/290915/EN-US/) FIX: CREATE for Existing Object with IDENTITY Column Causes Duplicate IDENTITY Values
Bug ID:203148285544 (http://support.microsoft.com/kb/285544/EN-US/) FIX: Dividing 0 by a Negative Decimal or Numeric Number Results in -0
Bug ID:217586293849 (http://support.microsoft.com/kb/293849/EN-US/) FIX: Statistics Maintenance Creates Significant Bottleneck on SQL Servers that Use 16 or More CPUs
Bug ID:218543275618 (http://support.microsoft.com/kb/275618/EN-US/) FIX: Cannot Set SQLServerAgent Password to More Than 16 Characters in Enterprise Manager
Bug ID:218599279015 (http://support.microsoft.com/kb/279015/EN-US/) FIX: SQL Server Does Not Run RESTOREVERIFYONLY When Scheduling a Back Up in SQL Enterprise Manager
Bug ID:230243295378 (http://support.microsoft.com/kb/295378/EN-US/) FIX: SQLAgent Job with Recurring Schedule Is Disabled Upon Completion of the Schedule for the Day
Bug ID:234529299649 (http://support.microsoft.com/kb/299649/EN-US/) FIX: Merge Replication Agent Fails with Error Message: "Unable to replicate a view or function"
Bug ID:234551, 235869281287 (http://support.microsoft.com/kb/281287/EN-US/) FIX: Msg 8964 on Index with IGNORE_DUP_KEY and Row Has a Text Column
Bug ID:234619295120 (http://support.microsoft.com/kb/295120/EN-US/) FIX: OK Button for Changing the Recovery Model or the Compatibility Level in SQL Enterprise Manager is Disabled
Bug ID:234633280747 (http://support.microsoft.com/kb/280747/EN-US/) FIX: UPDATE Statement on a Clustered Index Key Fails with Error 547
Bug ID:234652295936 (http://support.microsoft.com/kb/295936/EN-US/) FIX: Error Removing Log Shipping on Secondary Database When Database Name Has a Quote
Bug ID:234705286119 (http://support.microsoft.com/kb/286119/EN-US/) FIX: Incorrect Behavior in SQL Server Profiler Event Generation
Bug ID:234858295047 (http://support.microsoft.com/kb/295047/EN-US/) FIX: Full-Text Indexes Are Scripted Before Table Indexes Causing DB Creation Script Failure
Bug ID:234864295048 (http://support.microsoft.com/kb/295048/EN-US/) FIX: Cannot Script Full-Text Indexes for Tables with No Primary Keys Even if Another Unique Index Exists
Bug ID:234991291277 (http://support.microsoft.com/kb/291277/EN-US/) FIX: ServerNet II Library Does Not Display if Giganet Driver is Not Available
Bug ID:235019290916 (http://support.microsoft.com/kb/290916/EN-US/) FIX: fn_virtualfilestats Skips the Last File
Bug ID:235027298923 (http://support.microsoft.com/kb/298923/EN-US/) FIX: sp_MsHelpmergeconflictcounts Returns No Row Against the Chinese Name Table on English Windows 2000
Bug ID:235040290128 (http://support.microsoft.com/kb/290128/EN-US/) FIX: SQL Server Resource DLL May Fail to Log to the Event Viewer in a Cluster
Bug ID:235056300380 (http://support.microsoft.com/kb/300380/EN-US/) FIX: Intense Database Backup Stress Causes BackupSync to Generate an Assertion when Releasing Memory
Bug ID:235060294985 (http://support.microsoft.com/kb/294985/EN-US/) FIX: SQL Server Agent Proxy Account Not Cleaned Up When Instance Is Uninstalled
Bug ID:235085289851 (http://support.microsoft.com/kb/289851/EN-US/) FIX: Creating a New Unique Named Pipe Alias Displays the Default Pipe Value Instead of the Entered Value
Bug ID:235091303228 (http://support.microsoft.com/kb/303228/EN-US/) FIX: Queue Reader Agent Fails if the Distributor is a Clustered SQL Server
Bug ID:235118290414 (http://support.microsoft.com/kb/290414/EN-US/) FIX: Index Tuning Wizard Fails to Remove Hypothetical Clustered Indexes
Bug ID:235175295668 (http://support.microsoft.com/kb/295668/EN-US/) FIX: Transaction Replication to DB2 Subscribers Incorrectly Map Tinyint Data Type if You Use DTS to Transform Published Data
Bug ID:235210300388 (http://support.microsoft.com/kb/300388/EN-US/) FIX: SQL Server Profiler Stops Responding When Saving Output to Hard Disk That Is Out of Space
Bug ID:235241291223 (http://support.microsoft.com/kb/291223/EN-US/) FIX: sql_variant Data Replicates Incorrectly After Conflict Is Resolved in a Queued Updating Subscriber Scenario
Bug ID:235253300391 (http://support.microsoft.com/kb/300391/EN-US/) FIX: Profiler Replay Output File Does not Show Events When Looking at Properties
Bug ID:235295287234 (http://support.microsoft.com/kb/287234/EN-US/) FIX: No Vertical Scroll Bar in DTS Dynamic Properties Task Properties Dialog Box
Bug ID:235326299543 (http://support.microsoft.com/kb/299543/EN-US/) 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 Rows
Bug ID:235343, 353327, 353326272737 (http://support.microsoft.com/kb/272737/EN-US/) FIX: SQL Server Profiler Generates Error when Reading Trace Files that Exceed 1023 SPIDs
Bug ID:235348290369 (http://support.microsoft.com/kb/290369/EN-US/) FIX: Updates to New Column Added to Merge Publication Article are not Replicated
Bug ID:235377301579 (http://support.microsoft.com/kb/301579/EN-US/) FIX: "Unspecified error" Raised When Working with DTS Packages on Localized SQL Server 2000
Bug ID:235391299323 (http://support.microsoft.com/kb/299323/EN-US/) FIX : DBCC CHECKTABLE May Fail if Corruption Exists in Indexes
Bug ID:235394299362 (http://support.microsoft.com/kb/299362/EN-US/) FIX: Failover of a SQL Virtual Server Causes Problems with Active Directory Integration
Bug ID:235408295051 (http://support.microsoft.com/kb/295051/EN-US/) FIX: Changing SQL Server Account to Non-Admin for Full-Text Search Makes Existing Catalogs Unusable
Bug ID:235412295461 (http://support.microsoft.com/kb/295461/EN-US/) FIX: Profiler Fails To Start New Trace When User Environment Variable Has Been Changed
Bug ID:235435292237 (http://support.microsoft.com/kb/292237/EN-US/) FIX: xp_startmail Does Not Start Default Profile on Nondefault Instance
Bug ID:235489271945 (http://support.microsoft.com/kb/271945/EN-US/) FIX: SQL Agent Appends Garbled Characters to Output File
Bug ID:235494287405 (http://support.microsoft.com/kb/287405/EN-US/) FIX: Access Violation Occurs When You Use the Server Network Utility Without Administrator Privileges on Computer
Bug ID:235501290055 (http://support.microsoft.com/kb/290055/EN-US/) FIX: Error Message: "The process can not add message to message queue. The step failed"
Bug ID:235508285290 (http://support.microsoft.com/kb/285290/EN-US/) FIX: Complex ANSI Join Query with Distributed Queries May Cause Handled Access Violation
Bug ID:235565298835 (http://support.microsoft.com/kb/298835/EN-US/) FIX: Delete From Partition View that Contains Text or Image Data May Cause Error
Bug ID:235577299857 (http://support.microsoft.com/kb/299857/EN-US/) FIX: Trigger May Not Fire if Query Plan Uses CONSTANT SCAN Operator
Bug ID:235592284440 (http://support.microsoft.com/kb/284440/EN-US/) FIX: UPDATE with CASE Statement That Uses NEWID() Function Causes Errors 8951, 8952, 8955 and 8956
Bug ID:235596286503 (http://support.microsoft.com/kb/286503/EN-US/) FIX: Publication Options Disabled When Create Publication Wizard Launched from DTS Import/Export Wizard
Bug ID:235696295114 (http://support.microsoft.com/kb/295114/EN-US/) FIX: SELECT * FROM SYSINDEXES On a Database Upgraded From SQL Server 7.0 May Cause an Access Violation
Bug ID:235700287167 (http://support.microsoft.com/kb/287167/EN-US/) FIX: Some Full-Text Search Failures Do Not Set @@ERROR
Bug ID:235701291276 (http://support.microsoft.com/kb/291276/EN-US/) FIX: Startup Stored Procedures Don't Execute with AWE Support Enabled
Bug ID:235717297369 (http://support.microsoft.com/kb/297369/EN-US/) FIX: Incorrect Error Occurs When You Add Merge Article to a Publication with NO SYNC Subscriber
Bug ID:235751289878 (http://support.microsoft.com/kb/289878/EN-US/) FIX: Locking on File Header Pages Is Reported Incorrectly
Bug ID:235754291001 (http://support.microsoft.com/kb/291001/EN-US/) INF: How to Use sp_scriptdynamicupdproc to Improve the Performance of Update Custom Procedures in SQL Server 2000 Transactional Replication
Bug ID:235838278978 (http://support.microsoft.com/kb/278978/EN-US/) FIX: SELECT May Not Return All Rows if It Contains a Large Number of Values in an IN Clause on a NUMERIC Column
Bug ID:235843286750 (http://support.microsoft.com/kb/286750/EN-US/) FIX: Data Transfer Using ODBC Driver for SQL Server Fails
Bug ID:235865295002 (http://support.microsoft.com/kb/295002/EN-US/) FIX: SQL Server 2000 Setup Does Not Install Jet Drivers Help File
Bug ID:235883286773 (http://support.microsoft.com/kb/286773/EN-US/) FIX: DTS FTP Task Does Not Behave as Expected if Destination Is Out of Space or the Destination File Exists
Bug ID:235884293223 (http://support.microsoft.com/kb/293223/EN-US/) FIX: Problems Saving DTS Packages to Visual Basic Files Using the DTS User Interface
Bug ID:235895287713 (http://support.microsoft.com/kb/287713/EN-US/) FIX: Problems with DTS UI Help Topics
Bug ID:235974295027 (http://support.microsoft.com/kb/295027/EN-US/) INF: Limited Support for Savepoint in Distributed Transactions in SQL Server 2000 Service Pack 1
Bug ID:236001276043 (http://support.microsoft.com/kb/276043/EN-US/) FIX: Error Message 5180 May Occur When You Retrieve Text or Image Data
Bug ID:236010300172 (http://support.microsoft.com/kb/300172/EN-US/) FIX: sp_addmergearticle May Fail with Error 20009 if Article Added Is Vertically Filtered
Bug ID:236030299462 (http://support.microsoft.com/kb/299462/EN-US/) FIX: Dump of Internal Structures while Users Connect or Disconnect May Cause Access Violation
Bug ID:236045295466 (http://support.microsoft.com/kb/295466/EN-US/) FIX: Affinity Mask Option in sp_configure Does Not Support 32 Processors
Bug ID:236046299466 (http://support.microsoft.com/kb/299466/EN-US/) FIX: Running Stack Dumper Causes Memory Leak of Virtual Bytes
Bug ID:236053294311 (http://support.microsoft.com/kb/294311/EN-US/) FIX: Trigger Does Not Return Expected Duplicate Key Insert Error to Client
Bug ID:236072292454 (http://support.microsoft.com/kb/292454/EN-US/) FIX: Update Queries with OpenXML Table Aliases Cause Access Violation
Bug ID:236087274224 (http://support.microsoft.com/kb/274224/EN-US/) FIX: Using SQL Server 2000 Merge Modules May Result in Confusing Message
Bug ID:236107274329 (http://support.microsoft.com/kb/274329/EN-US/) FIX: Optimizer Slow to Generate Query Plan for Complex Queries that have Many Joins and Semi-Joins
Bug ID:236111294388 (http://support.microsoft.com/kb/294388/EN-US/) FIX: Reading Perflib Registry Values Terminates SQL Server Startup with Fatal Exception
Bug ID:236112274330 (http://support.microsoft.com/kb/274330/EN-US/) FIX: Sending Open Files as Attachment in SQL Mail Fails with Error 18025
Bug ID:236115290082 (http://support.microsoft.com/kb/290082/EN-US/) FIX: Failed Server-Side Retail Assertion in Merge Replication with SQL Server CE Clients
Bug ID:236124286268 (http://support.microsoft.com/kb/286268/EN-US/) FIX: User and Owner Passwords are Dimmed When You Save a Package as a File By Using DTSWIZ
Bug ID:236129295551 (http://support.microsoft.com/kb/295551/EN-US/) FIX: Text Pasted in Query Analyzer Result Window Is Not Visible
Bug ID:236137286234 (http://support.microsoft.com/kb/286234/EN-US/) FIX: Suboptimal Execution Plan on an Indirect UPDATE to an Indexed View
Bug ID:236142285006 (http://support.microsoft.com/kb/285006/EN-US/) FIX: XML Parsing Error 6603 or Truncated Text Data with OPENXML
Bug ID:236167274266 (http://support.microsoft.com/kb/274266/EN-US/) FIX: Data Modification Query with a Distinct Subquery on a View May Cause Error 3624
Bug ID:236173298830 (http://support.microsoft.com/kb/298830/EN-US/) FIX: Error Message: "Cannot Start 'Config XML support in IIS for SQL Server'"
Bug ID:236178275900 (http://support.microsoft.com/kb/275900/EN-US/) FIX: Linked Server Query with Hyphen in LIKE Clause May Run Slowly
Bug ID:236191280744 (http://support.microsoft.com/kb/280744/EN-US/) FIX: Update Query Returns Error 1903 if Temporary Composite Index Over 900 Bytes
Bug ID:236195300500 (http://support.microsoft.com/kb/300500/EN-US/) FIX: Server Name is not Being Populated on the Client Side (UI or File) in SQL Server Profiler
Bug ID:236220288340 (http://support.microsoft.com/kb/288340/EN-US/) FIX: Errors in Transform Failure Function Are Logged When They Should Be Ignored
Bug ID:236230290080 (http://support.microsoft.com/kb/290080/EN-US/) FIX: Assert Occurs When You Try to Alter a Database and Trace Flag 902 is Enabled
Bug ID:236233290083 (http://support.microsoft.com/kb/290083/EN-US/) FIX: FOR XML EXPLICIT: Conflict Attribute in xmltext Is Not Overwritten if xmltext Contains DBCS
Bug ID:236274293155 (http://support.microsoft.com/kb/293155/EN-US/) FIX: BCP with Format File and -R Parameter Ignores Regional Settings
Bug ID:236293278509 (http://support.microsoft.com/kb/278509/EN-US/) FIX: Distribution Agent Ignores Quoted Identifier Option on Initial Sync to Oracle Subscribers
Bug ID:236309274773 (http://support.microsoft.com/kb/274773/EN-US/) FIX: If You Change Windows Security to Windows/SQL Security the SA Password is Blank
Bug ID:236325276329 (http://support.microsoft.com/kb/276329/EN-US/) FIX: Complex Distinct or Group By Query Can Return Unexpected Results with Parallel Execution Plan
Bug ID:236329290415 (http://support.microsoft.com/kb/290415/EN-US/) FIX: Use of the Jet Provider to Query a Linked Server Text File from SQL Server May Be Very Slow
Bug ID:236374290351 (http://support.microsoft.com/kb/290351/EN-US/) FIX: SQL Server Assertion During Distributed Transaction
Bug ID:236375289893 (http://support.microsoft.com/kb/289893/EN-US/) FIX: Current Row's Time if Empty Is Replaced by Previous Row's Time in Bulk Copy
Bug ID:236394293464 (http://support.microsoft.com/kb/293464/EN-US/) FIX: Merge Replication Does Not Log Conflicts after Successively Adding and Dropping Columns
Bug ID:236400275901 (http://support.microsoft.com/kb/275901/EN-US/) FIX: SQL RPC That Raises Error Will Mask @@ERROR with Msg 7221
Bug ID:236421300183 (http://support.microsoft.com/kb/300183/EN-US/) FIX: SQL Server Cluster Resource Fails to Come Online Until Cluster Service Is Restarted
Bug ID:236443279296 (http://support.microsoft.com/kb/279296/EN-US/) FIX: Using ALTER TABLE to Change Column Type Can Result in Unexpected NULL Values on INSERT
Bug ID:236453280294 (http://support.microsoft.com/kb/280294/EN-US/) FIX: SQL Server ODBC Driver Reuses Incorrect Parameter Length
Bug ID:236456294420 (http://support.microsoft.com/kb/294420/EN-US/) FIX: Logreader Fails to Select Text Data that is Inserted by SQL Server 6.5 Bcp Utility
Bug ID:236457277640 (http://support.microsoft.com/kb/277640/EN-US/) FIX: Denial of Service Attack with NULL Bytes in RPC Request
298012 (http://support.microsoft.com/kb/298012/EN-US/) Malformed RPC Request Can Cause Service Problems
Bug ID:236561295373 (http://support.microsoft.com/kb/295373/EN-US/) FIX: Creating Indexes in Parallel May Fail with Deadlock on Sysindexes
Bug ID:236588279659 (http://support.microsoft.com/kb/279659/EN-US/) FIX: SQL Server 2000 Takes Much Longer to Compile the Query Against Local Partitioned View Than SQL Server 7.0
Bug ID:236595288957 (http://support.microsoft.com/kb/288957/EN-US/) FIX: Multiple Calls To a User Defined Function Within an Aggregate Function May Return Incorrect Results
Bug ID:236625267953 (http://support.microsoft.com/kb/267953/EN-US/) FIX: Interleaving Prepare And Adhoc Execute of Query May Cause Recompile Loop
Bug ID:236630290353 (http://support.microsoft.com/kb/290353/EN-US/) FIX: Updating View Based on Partitioned View May Result in Assertion
Bug ID:236633293329 (http://support.microsoft.com/kb/293329/EN-US/) FIX: Attaching Database Files Saved In Different Disk Folders Through SQL Enterprise Manager
Bug ID:236658301627 (http://support.microsoft.com/kb/301627/EN-US/) FIX: Error Message: "ICE03 Invalid template string" Reported by MSIVal2
Bug ID:236652281293 (http://support.microsoft.com/kb/281293/EN-US/) FIX: SQL Mail 2000 Needs Microsoft Outlook 2000 Client
Bug ID:236682297104 (http://support.microsoft.com/kb/297104/EN-US/) FIX: Backup or Restore Using Large Transaction Logs May Return Error 3241
Bug ID:236752293784 (http://support.microsoft.com/kb/293784/EN-US/) FIX: Unable to Drop a Catalog When Disk Is Full
Bug ID:236753278698 (http://support.microsoft.com/kb/278698/EN-US/) FIX: Exception Access Violation Encountered During Compile of Hash Match Team Plan
Bug ID:236765279295 (http://support.microsoft.com/kb/279295/EN-US/) FIX: Parallel Index Creation on Large SMP Hardware Can Cause Handled Access Violation
Bug ID:300104286775 (http://support.microsoft.com/kb/286775/EN-US/) FIX: Creating a Publication From Within DTSWIZ Fails with "Error 496: General Error" Error Message
Bug ID:300108293489 (http://support.microsoft.com/kb/293489/EN-US/) FIX: Merge Replication with Dynamic Filters May Cause MMC to Fail
Bug ID:350775279183 (http://support.microsoft.com/kb/279183/EN-US/) FIX: Scripting Object with Several Extended Properties May Cause Exception
Bug ID:350799279293 (http://support.microsoft.com/kb/279293/EN-US/) FIX: CASE Using LIKE with Empty String Can Result in Access Violation or Abnormal Server Shutdown
Bug ID:350878286756 (http://support.microsoft.com/kb/286756/EN-US/) FIX: DTS Source Logging Fails if Source Contains Unmapped Columns
Bug ID:350879279123 (http://support.microsoft.com/kb/279123/EN-US/) FIX: SQL Server 2000 Uninstallation May Break SQL Server CE Replication
Bug ID:350886, 236168292456 (http://support.microsoft.com/kb/292456/EN-US/) FIX: GetColumnInfo Returns Incorrect Column Information
Bug ID:350894294783 (http://support.microsoft.com/kb/294783/EN-US/) FIX: Addition of a Column to an Incrementally Added Article Prior to Snapshot Generation Fails
Bug ID:350896299914 (http://support.microsoft.com/kb/299914/EN-US/) FIX: Executing MAX or MIN Aggregate Functions on Column with Hypothetical Clustered Index May Result in CPU SPIN
Bug ID:350899299470 (http://support.microsoft.com/kb/299470/EN-US/) FIX: SELECT with Distinct and Self Loop Join May Cause 1203 Error Message
Bug ID:350911292637 (http://support.microsoft.com/kb/292637/EN-US/) FIX: Unicode Character String Longer Than Seven Bytes in a LIKE Clause Is Truncated in Execution Plan
Bug ID:350912288174 (http://support.microsoft.com/kb/288174/EN-US/) FIX: Modifying a Table with DRI Cascade That Is Involved in an Indexed View May Cause Msg 8624
Bug ID:350933287401 (http://support.microsoft.com/kb/287401/EN-US/) FIX: Unable to Use GOTO in an Execute SQL Task of a DTS Package
Bug ID:350958297156 (http://support.microsoft.com/kb/297156/EN-US/) FIX: Snapshot Agent Error Occurs While Adding Table with a Space in Name to an Existing Merge Publication
Bug ID:350970300217 (http://support.microsoft.com/kb/300217/EN-US/) FIX: "Update Index in Background" Option in Change Tracking May Not Work if Very Low Disk Space Detected
Bug ID:350984300037 (http://support.microsoft.com/kb/300037/EN-US/) FIX: Error 229 "EXECUTE permission denied on object xp_mapdown_bitmap" on Merge Published Table
Bug ID:351022285979 (http://support.microsoft.com/kb/285979/EN-US/) FIX: Changing Autostart Options for Named Instances Change Autostart Settings for the Default Instance
Bug ID:351023303119 (http://support.microsoft.com/kb/303119/EN-US/) FIX: Upgrade to SQL Server 2000 Cluster Does Not Add All SQL Server Resource Dependencies
Bug ID:351025279338 (http://support.microsoft.com/kb/279338/EN-US/) FIX: DBCC CHECKCONSTRAINTS Does Not Handle Names with Special Characters
Bug ID:351080291275 (http://support.microsoft.com/kb/291275/EN-US/) FIX: sp_replsetoriginator May Generate Access Violation in Bidirectional Transactional Replication
Bug ID:351081290592 (http://support.microsoft.com/kb/290592/EN-US/) FIX: Full-Text Rows Missing After Crawl Due to Full Disk
Bug ID:351097295030 (http://support.microsoft.com/kb/295030/EN-US/) FIX: Index Tuning Wizard Execution May Generate Floating Point Exception
Bug ID:351119299382 (http://support.microsoft.com/kb/299382/EN-US/) FIX: Zeros Incorrectly Removed from the Binary Column in SQL Profiler
Bug ID:351128279804 (http://support.microsoft.com/kb/279804/EN-US/) FIX: INSERT Statement Incorrectly Conflicts with Constraint
Bug ID:351140279867 (http://support.microsoft.com/kb/279867/EN-US/) FIX: Sending Maintenance Report by E-mail to Operator Fails in Maintenance Plan
Bug ID:351147282416 (http://support.microsoft.com/kb/282416/EN-US/) FIX: Opening the Database Folder in SQL Server Enterprise Manager 2000 Takes a Long Time
Bug ID:351185293345 (http://support.microsoft.com/kb/293345/EN-US/) FIX: ANSI Script from Profiler Cannot be Opened in Query Analyzer
Bug ID:351188, 351189280380 (http://support.microsoft.com/kb/280380/EN-US/) FIX: Buffer Overflow Exploit Possible with Extended Stored Procedures
Bug ID:351196280846 (http://support.microsoft.com/kb/280846/EN-US/) FIX: Merge Snapshot Agent May Fail With Syntax Error Message When Published Table Contains Computed Columns
Bug ID:351222282455 (http://support.microsoft.com/kb/282455/EN-US/) FIX: SQL Server Fails to Start When Computer Binds 48 or More Socket Addresses
Bug ID:351225282243 (http://support.microsoft.com/kb/282243/EN-US/) FIX: Incorrect Results with Join of Column Converted to Binary
Bug ID:351229295039 (http://support.microsoft.com/kb/295039/EN-US/) FIX: Assertion Raised When DELETE Is Performed on a Table Joined with a View
Bug ID:351230288996 (http://support.microsoft.com/kb/288996/EN-US/) FIX: System View Sysopentapes Can Be Dropped
Bug ID:351235289551 (http://support.microsoft.com/kb/289551/EN-US/) FIX: Generate SQL Script in Enterprise Manager Generates Scripts in Wrong Sequence if the Table has User-Defined Function as Computed Column
Bug ID:351242293761 (http://support.microsoft.com/kb/293761/EN-US/) FIX: Dynamic Filtered Tables Do Not Replicate Data From Joined Tables to SQL Server CE Subscribers
Bug ID:351243287606 (http://support.microsoft.com/kb/287606/EN-US/) FIX: Enterprise Manager Reports Table Sizes That Are Inconsistent as Compared to sp_spaceused
Bug ID:351259286255 (http://support.microsoft.com/kb/286255/EN-US/) FIX: UNION Query Returns Internal Query Processor Error Message 8623
Bug ID:351266290642 (http://support.microsoft.com/kb/290642/EN-US/) FIX: Exists with Full Outer Join May Generate Access Violation
Bug ID:351268, 351286281843 (http://support.microsoft.com/kb/281843/EN-US/) FIX: SQLDMO GetProcessInputBuffer Returns Incorrect Result
Bug ID:351300294970 (http://support.microsoft.com/kb/294970/EN-US/) FIX: Distribution Agent Fails with Syntax Error with Compensating Commands for Queued Updating Subscribers
Bug ID:351305286249 (http://support.microsoft.com/kb/286249/EN-US/) FIX: Complex Update Statement Returns 8624 Internal SQL Server Error
Bug ID:351307299366 (http://support.microsoft.com/kb/299366/EN-US/) FIX: Calling Remote Stored Procedure Inside Local Stored Procedure While Passing Text Parameter Causes AV
Bug ID:351327294415 (http://support.microsoft.com/kb/294415/EN-US/) FIX: Resource Does Not Failover Immediately if an Error is Encountered by the Resource DLL
Bug ID:351328295032 (http://support.microsoft.com/kb/295032/EN-US/) FIX: Job Step Fails if First INSERT of Batch Job Encounters a Msg 3604 Error
Bug ID:351337295325 (http://support.microsoft.com/kb/295325/EN-US/) FIX: Replication in Turkish Collation Fails with Error Message: "Error 21112: '-PollingInterval' is not a valid parameter for the Log Reader Agent"
Bug ID:351342281238 (http://support.microsoft.com/kb/281238/EN-US/) FIX: xp_findnextmsg Does Not Return a Value for @msg_id Parameter on Output
Bug ID:351343281239 (http://support.microsoft.com/kb/281239/EN-US/) FIX: xp_findnextmsg Returns Multiple Rows When No Parameters Are Specified
Bug ID:351363282229 (http://support.microsoft.com/kb/282229/EN-US/) FIX: SP_OA Procedures Leak Memory and Cause Various Errors
Bug ID:351373284228 (http://support.microsoft.com/kb/284228/EN-US/) INF: New Trace Flag to Enhance Stored Procedure Replication
Bug ID:351375282279 (http://support.microsoft.com/kb/282279/EN-US/) FIX: Execution of sp_OACreate on COM Object Without Type Information Causes Server Shut Down
Bug ID:351376286565 (http://support.microsoft.com/kb/286565/EN-US/) FIX: SQL Server Process Terminates Attempting to Reset from an sp_OA Based Batch
Bug ID:351394, 352221288122 (http://support.microsoft.com/kb/288122/EN-US/) FIX: Lock Monitor Uses Excessive CPU
Bug ID:351407288189 (http://support.microsoft.com/kb/288189/EN-US/) FIX: DTS FTP Task May Fail to Download Files After a Network Problem
Bug ID:351431299361 (http://support.microsoft.com/kb/299361/EN-US/) FIX: Timestamp Column Truncated When Replicating with Sybase Using Merant OLEDB Provider
Bug ID:351441283825 (http://support.microsoft.com/kb/283825/EN-US/) FIX: DBCC DBREINDEX Does Not Keep Original Fillfactor
Bug ID:351450, 352729293328 (http://support.microsoft.com/kb/293328/EN-US/) FIX: Update Query Does Not Execute Correctly
Bug ID:351471292455 (http://support.microsoft.com/kb/292455/EN-US/) FIX: OSQL Does Not Display Column Names for Query
Bug ID:351474289149 (http://support.microsoft.com/kb/289149/EN-US/) FIX: A Query That Uses Hash Match Teams May Fail with 8630 Error Message
Bug ID:351486299865 (http://support.microsoft.com/kb/299865/EN-US/) FIX: DMO BulkCopy fails to copy data when column names contain the space character
Bug ID:351502286253 (http://support.microsoft.com/kb/286253/EN-US/) FIX: Multiple SQL Agent Jobs Launched At The Same Time May Fail With Primary Key Error Message
Bug ID:351513286788 (http://support.microsoft.com/kb/286788/EN-US/) FIX: Server Side Cursor May Return Incorrect Results
Bug ID:351566282982 (http://support.microsoft.com/kb/282982/EN-US/) FIX: Suboptimal Performance Using a Cursor to Update a Heap Involved in an Indexed View
Bug ID:351620291780 (http://support.microsoft.com/kb/291780/EN-US/) FIX: DTS Transfer Objects May Fail if Dependent Objects Are Not in Alphabetical Order
Bug ID:351634, 351180290917 (http://support.microsoft.com/kb/290917/EN-US/) FIX: Incorrect Identity Values After Failed Unique Index Creation
Bug ID:351653290643 (http://support.microsoft.com/kb/290643/EN-US/) FIX: Microsoft Search Service Cannot be Stopped During Large Population
Bug ID:351658299544 (http://support.microsoft.com/kb/299544/EN-US/) FIX: Correlated Subquery Containing UNION ALL May Cause Access Violation
Bug ID:351669294459 (http://support.microsoft.com/kb/294459/EN-US/) FIX: Can't Use Four-Part Name to Query Oracle Table if Name Contains Lowercase Characters
Bug ID:351682290058 (http://support.microsoft.com/kb/290058/EN-US/) FIX: SQL Mail Procedures May Intermittently Fail with Error 0x8004010f
Bug ID:351686286774 (http://support.microsoft.com/kb/286774/EN-US/) FIX: SQL Server 2000 Cluster Setup Fails with "Entry Point for DllCNVREM.dll not found" Error Message
Bug ID:351698293758 (http://support.microsoft.com/kb/293758/EN-US/) FIX: Nullability Changes not Handled by SQL Server with Linked Server Queries to DB2
Bug ID:351714285952 (http://support.microsoft.com/kb/285952/EN-US/) FIX: NO_TRUNCATE May Be Added to Backup Log Statement when You Perform a Log Backup from SEM
Bug ID:351729291376 (http://support.microsoft.com/kb/291376/EN-US/) FIX: Cannot Use Dynamic SQL Statements Within OPENQUERY
Bug ID:351736295053 (http://support.microsoft.com/kb/295053/EN-US/) FIX: OPENXML May Leak Worktables in Memory
Bug ID:351754289880 (http://support.microsoft.com/kb/289880/EN-US/) FIX: SQL Server Assertion Failure Occurs if Recovery Model of TempDB is not SIMPLE
Bug ID:351761285870 (http://support.microsoft.com/kb/285870/EN-US/) FIX: Update With Self Join May Update Incorrect Number Of Rows
Bug ID:351773292755 (http://support.microsoft.com/kb/292755/EN-US/) FIX: Full-Text Queries May Return "Unspecified Error" Error Message
Bug ID:351791290921 (http://support.microsoft.com/kb/290921/EN-US/) FIX: UPPER and LOWER Functions Return Metadata Length as if DBCS Were Used
Bug ID:351797289739 (http://support.microsoft.com/kb/289739/EN-US/) FIX: Distributed Query with Optika Provider May Return Incorrect Results
Bug ID:351829275145 (http://support.microsoft.com/kb/275145/EN-US/) FIX: Only One SQL Server Performance Condition Alert Is Treated As Active
Bug ID:351866, 351704295034 (http://support.microsoft.com/kb/295034/EN-US/) FIX: Microsoft Search Service May Cause 100% CPU Usage if BUILTIN\Administrators Login Is Removed
Bug ID:351892286737 (http://support.microsoft.com/kb/286737/EN-US/) FIX: FetchBufferSize Greater than Certain Number Fails to Transfer all Rows and Does Not Return an Error
Bug ID:351894280720 (http://support.microsoft.com/kb/280720/EN-US/) FIX: xp_sendmail Generates UNICODE CSV File Format
Bug ID:351901289475 (http://support.microsoft.com/kb/289475/EN-US/) FIX: SQLAgent Incorrectly Uses TLSAlloc for Transact-SQL Jobs Causing all TLS Slots to be Exhausted
Bug ID:351918295037 (http://support.microsoft.com/kb/295037/EN-US/) FIX: MERGE UNION Is Not Used with Large Number of UNION Clauses
Bug ID:351920290085 (http://support.microsoft.com/kb/290085/EN-US/) FIX: Extended Stored Procedure "xp_logevent" Generates an Access Violation when Given Too Large a Parameter
Bug ID:351927294338 (http://support.microsoft.com/kb/294338/EN-US/) FIX: xp_enumgroups Generates an Access Violation when Passed a Large Parameter
Bug ID:351939286749 (http://support.microsoft.com/kb/286749/EN-US/) FIX: Table Creation, Row Insertion, and Index Creation Inside Transaction, Followed By Addition of Constraint May Result in Consistency Errors
Bug ID:351941293292 (http://support.microsoft.com/kb/293292/EN-US/) FIX: DBCC CHECKDB May Produce an Access Violation When Database Is in Use
Bug ID:351948290644 (http://support.microsoft.com/kb/290644/EN-US/) FIX: DTSRun.exe Causes Access Violation on SMP Computers
Bug ID:351952290739 (http://support.microsoft.com/kb/290739/EN-US/) FIX: Iterating Through SQL Mail Messages Using Extended Procedures Takes Longer in SQL Server 2000
Bug ID:351953290210 (http://support.microsoft.com/kb/290210/EN-US/) FIX: Removal of Full-Text Index May Incorrectly Remove Rows From sysdepends System Table
Bug ID:351984299448 (http://support.microsoft.com/kb/299448/EN-US/) FIX: Subquery That References Table with No Statistics and Returns Empty Result Set May Cause AV
Bug ID:351990291851 (http://support.microsoft.com/kb/291851/EN-US/) FIX: Merge Replication Stored Procedures May Be Scripted Incorrectly When an Article is in Two Publications
Bug ID:352016299937 (http://support.microsoft.com/kb/299937/EN-US/) FIX: Changes to Indexed View Article of a Transactional Publication Are Not Saved
Bug ID:352024298402 (http://support.microsoft.com/kb/298402/EN-US/) INF: Understanding How to Set the SQL Server I/O Affinity Option
Bug ID:352036289691 (http://support.microsoft.com/kb/289691/EN-US/) FIX: Sysprocesses Is Incorrectly Showing Rollback Status Even Though the Transaction Is Not Rolling Back
Bug ID:352038303224 (http://support.microsoft.com/kb/303224/EN-US/) FIX: Use of the Copy Database Wizard to Copy a Database Disables Full-Text Indexing on the Source Database
Bug ID:352051299787 (http://support.microsoft.com/kb/299787/EN-US/) FIX: Skewed Replication Statistics in Output File When Running Agent Continuously
Bug ID:352074290077 (http://support.microsoft.com/kb/290077/EN-US/) FIX: DTS Scheduled Job Does Not Complete After First Run
Bug ID:352077291540 (http://support.microsoft.com/kb/291540/EN-US/) FIX: Instead of Triggers that Use Work Tables Cause a Memory Leak
Bug ID:352081300272 (http://support.microsoft.com/kb/300272/EN-US/) FIX: Transfer of a View that Contains a UDF by Using DTS Export Data Fails with Error 208
Bug ID:352082Q300194 (http://support.microsoft.com/kb/Q300194/EN-US/) FIX: Error 644 Using Two Indexes on a Column with Uppercase Preference Sort Order
Bug ID:352091288426 (http://support.microsoft.com/kb/288426/EN-US/) FIX: Alerts Triggered Incorrectly When Security Auditing is Enabled
Bug ID:352092295045 (http://support.microsoft.com/kb/295045/EN-US/) FIX: SELECT DISTINCT Returns Incorrect Results in SQL_Latin1_General_Pref_Cp1_CI_AS Collation
Bug ID:352098290918 (http://support.microsoft.com/kb/290918/EN-US/) FIX: Incorrect Behavior of LIKE [-] When Using an Index
Bug ID:352099294929 (http://support.microsoft.com/kb/294929/EN-US/) FIX: MSDE Installation Contains the Wrong Icon for the Service Manager
Bug ID:352114299889 (http://support.microsoft.com/kb/299889/EN-US/) FIX: Full Population May Not Complete if Microsoft Search Service Is Stopped and Restarted
Bug ID:352142289472 (http://support.microsoft.com/kb/289472/EN-US/) FIX: SQLAgent Exception Occurs when the System Maintains 613, 2661 or 4709 Jobs
Bug ID:352148290413 (http://support.microsoft.com/kb/290413/EN-US/) FIX: DB-Library sp_cursor Fails with Error Message 16933 if Bracketed Identifiers are Passed with the Tablename Parameter
Bug ID:352211290645 (http://support.microsoft.com/kb/290645/EN-US/) FIX: SQL Server Active Directory Registration Always Reports Success
Bug ID:352213300180 (http://support.microsoft.com/kb/300180/EN-US/) FIX: sp_MSexpandnotbelongs May Be Called at Publisher Due to Invalid Evaluation of Join Filter
Bug ID:352217292761 (http://support.microsoft.com/kb/292761/EN-US/) FIX: xp_startmail Error Message Does Not Indicate Problem
Bug ID:352230302421 (http://support.microsoft.com/kb/302421/EN-US/) FIX: Query Issued Against Two Instances of the Same Table May Cause an Access Violation
Bug ID:352255292737 (http://support.microsoft.com/kb/292737/EN-US/) FIX: Drag and Drop Object Type Node to the Editor in Query Analyzer Returns Error Message
Bug ID:352264291274 (http://support.microsoft.com/kb/291274/EN-US/) FIX: Correlated Subquery on Partitioned Views with Text Operations May Cause Access Violation
Bug ID:352271291273 (http://support.microsoft.com/kb/291273/EN-US/) FIX: SQLMail Incorrectly Uses Default Mail Profile
Bug ID:352297293166 (http://support.microsoft.com/kb/293166/EN-US/) FIX: Parallel Modification Operation May Spin Trying to Release Locks
Bug ID:352303294999 (http://support.microsoft.com/kb/294999/EN-US/) FIX: SQL Server Fails to Start with \f Option on Computers with Many CPUs
Bug ID:352312290814 (http://support.microsoft.com/kb/290814/EN-US/) FIX: xp_readmail Leaks Memory if Message Contains Attachment
Bug ID:352320293430 (http://support.microsoft.com/kb/293430/EN-US/) FIX: SEM New SQL Server Registration Using Long Server Name Fails with Access Violation
Bug ID:352326298803 (http://support.microsoft.com/kb/298803/EN-US/) FIX: Coalesce with Subquery May Generate an Access Violation
Bug ID:352345291566 (http://support.microsoft.com/kb/291566/EN-US/) FIX: Parallel Plan for Index Creation of Non-Clustered Index May Result in Use of Pages That are not Allocated
Bug ID:352358300056 (http://support.microsoft.com/kb/300056/EN-US/) FIX: Merge Metadata Cleanup May Cause Subscriber Transaction Log to Grow Quickly
Bug ID:352372292753 (http://support.microsoft.com/kb/292753/EN-US/) FIX: Some Object Browser Folders Cannot Be Scripted
Bug ID:352404291235 (http://support.microsoft.com/kb/291235/EN-US/) FIX: Query Analyzer Hangs After You Drag && Drop Files Into the Query Editor and You Close One of the Newly Created Windows
Bug ID:352492296685 (http://support.microsoft.com/kb/296685/EN-US/) FIX: Cannot Execute SELECT COUNT(*) Against DB2 on Mainframe Using Four-Part Name
Bug ID:352500, 351440288330 (http://support.microsoft.com/kb/288330/EN-US/) FIX: FTP Task in DTS Deletes File from the Destination Folder After the Package Completes Execution
Bug ID:352501294902 (http://support.microsoft.com/kb/294902/EN-US/) FIX : Rollback to Savepoint Causes Assertion and Errors
Bug ID:352555295022 (http://support.microsoft.com/kb/295022/EN-US/) FIX: Sqlmaint.exe Is Not Available with MSDE 2000
Bug ID:352575, 352695293232 (http://support.microsoft.com/kb/293232/EN-US/) FIX: Undetected Deadlock Occurs When Lock Owner Is Waiting on CXPACKET
Bug ID:352606299602 (http://support.microsoft.com/kb/299602/EN-US/) FIX: Extended Stored Procedure xp_sendmail Does Not Handle DBCS Correctly
Bug ID:352608295459 (http://support.microsoft.com/kb/295459/EN-US/) FIX: sp_helptext Fails with Invalid Length Parameter Error
Bug ID:352640286286 (http://support.microsoft.com/kb/286286/EN-US/) FIX: LOCK_TIMEOUT Causes Transaction to Roll Back and @@error Does Not Capture Error 1222
Bug ID:352700294874 (http://support.microsoft.com/kb/294874/EN-US/) FIX: Combination of Multiple EXIST, OR, and Subquery Clauses May Give a Sub-Optimal Plan
Bug ID:352705294787 (http://support.microsoft.com/kb/294787/EN-US/) FIX: Update Plan with User Defined Function May Fail to Find a Plan
Bug ID:352735293632 (http://support.microsoft.com/kb/293632/EN-US/) FIX: EventSubClass Column Incorrect for Deadlock Chain Events
Bug ID:352765, 353201298951 (http://support.microsoft.com/kb/298951/EN-US/) FIX: Snapshot Agent for Merge Publication May Fail with 107 Error
Bug ID:352793293484 (http://support.microsoft.com/kb/293484/EN-US/) FIX: Incorrect Record is Deleted or Updated When a Clustered Index is in Descending Order
Bug ID:352799295644 (http://support.microsoft.com/kb/295644/EN-US/) FIX: Transaction Log Restores May Fail with 3456 Error
Bug ID:352807295046 (http://support.microsoft.com/kb/295046/EN-US/) FIX: OLE Automation Fails When Calling ADODB.Connection Methods
Bug ID:352826299285 (http://support.microsoft.com/kb/299285/EN-US/) FIX: Query with Complex Correlated Subquery May Cause Unexpected Results in Aggregate Functions
Bug ID:352830295055 (http://support.microsoft.com/kb/295055/EN-US/) FIX: sp_OAMethod Does Not Convert Numeric Datatype Correctly
Bug ID:352839294872 (http://support.microsoft.com/kb/294872/EN-US/) FIX: Update on a Table with INT and BIT Columns May Zero Out INT Columns
Bug ID:352847302409 (http://support.microsoft.com/kb/302409/EN-US/) FIX: Unable to Connect to SQL Server 2000 When Certificate Authority Name Is the Same As the Host Name of the Windows 2000 Computer
Bug ID:352867295023 (http://support.microsoft.com/kb/295023/EN-US/) FIX: "SET ROWCOUNT" May Cause Data to be Unreadable
Bug ID:352935295113 (http://support.microsoft.com/kb/295113/EN-US/) FIX: Corrupted TDS Packets Cause Access Violation in SQL Server
Bug ID:352963299903 (http://support.microsoft.com/kb/299903/EN-US/) FIX: sp_scriptpublicationcustomprocs Generates Replication Stored Procedures
Bug ID:353011, 353081294828 (http://support.microsoft.com/kb/294828/EN-US/) FIX: Passing a Large Command Line String to Query Analyzer Results in Assertion Failed
Bug ID:353031294839 (http://support.microsoft.com/kb/294839/EN-US/) FIX: No Error Message Generated by Query Analyzer When You Try to Open a Database with a Name Greater Than 128 Characters
Bug ID:353107295006 (http://support.microsoft.com/kb/295006/EN-US/) FIX : OSQL Utility Returns Incorrect Error Message
Bug ID:353170294412 (http://support.microsoft.com/kb/294412/EN-US/) FIX: SQLAgent T-SQL Job Does Not Respect SET NOCOUNT ON When Sending Output to File
Bug ID:353206, 352955294860 (http://support.microsoft.com/kb/294860/EN-US/) FIX: Modification Queries May Take Too Long to Compile if Halloween Protection is Required for Multiple Tables
Bug ID:353275295193 (http://support.microsoft.com/kb/295193/EN-US/) FIX: Merge Module Sqlsvr.msm Fails Validation with ICE03
Bug ID:353324295627 (http://support.microsoft.com/kb/295627/EN-US/) FIX: Xp_readmail May Cause System to Stop Responding in Windows 95 or Windows 98
Bug ID:353326 272737 (http://support.microsoft.com/kb/272737/EN-US/) FIX: SQL Server Profiler Generates Error when Reading Trace Files that Exceed 1023 SPIDs
Bug ID:353344299620 (http://support.microsoft.com/kb/299620/EN-US/) FIX: Cannot Use a Profile Name Longer Than 32 Characters with SQL Mail
Bug ID:353394296098 (http://support.microsoft.com/kb/296098/EN-US/) FIX: xp_sendmail Fails with the @attach_results Parameter on SQL Server 2000 Personal Edition
Bug ID:353405299351 (http://support.microsoft.com/kb/299351/EN-US/) FIX: MSDE Installation Fails on Systems That Have SQL Server 2000 Service Pack 1 Installed
Bug ID:353492300145 (http://support.microsoft.com/kb/300145/EN-US/) FIX: Merge Replication Conflict Viewer Resolves Data Conflicts Incorrectly
Bug ID:353641296465 (http://support.microsoft.com/kb/296465/EN-US/) FIX: Mssearch.exe Memory Leak Occurs when Results are not Completely Processed
Bug ID:354039, 353802299717 (http://support.microsoft.com/kb/299717/EN-US/) FIX: Query Method Used to Access Data May Allow Rights that the Login Might Not Normally Have
Bug ID:354604301060 (http://support.microsoft.com/kb/301060/EN-US/) FIX: Import of Text File Results in Error "Column Delimiter not found"
Bug ID:46409290646 (http://support.microsoft.com/kb/290646/EN-US/) FIX: SQLColAttribute Returns Incorrect Table Attributes When Table Name Contains a Period
| Article Translations
|
Back to the top
