INF: List of Bugs Fixed in SQL Server 2000 Service Pack 1 (1 of 2)

Bug ID:236010

300172 FIX: sp_addmergearticle May Fail with Error 20009 if Article Added Is Vertically Filtered

Bug ID:236030

299462 FIX: Dump of Internal Structures while Users Connect or Disconnect May Cause Access Violation

Bug ID:236045

295466 FIX: Affinity Mask Option in sp_configure Does Not Support 32 Processors

Bug ID:236046

299466 FIX: Running Stack Dumper Causes Memory Leak of Virtual Bytes

Bug ID:236053

294311 FIX: Trigger Does Not Return Expected Duplicate Key Insert Error to Client

Bug ID:236072

292454 FIX: Update Queries with OpenXML Table Aliases Cause Access Violation

Bug ID:236087

274224 FIX: Using SQL Server 2000 Merge Modules May Result in Confusing Message

Bug ID:236107

274329 FIX: Optimizer Slow to Generate Query Plan for Complex Queries that have Many Joins and Semi-Joins

Bug ID:236111

294388 FIX: Reading Perflib Registry Values Terminates SQL Server Startup with Fatal Exception

Bug 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 Clients

Bug ID:236124

286268 FIX: User and Owner Passwords are Dimmed When You Save a Package as a File By Using DTSWIZ

Bug ID:236129

295551 FIX: Text Pasted in Query Analyzer Result Window Is Not Visible

Bug ID:236137

286234 FIX: Suboptimal Execution Plan on an Indirect UPDATE to an Indexed View

Bug ID:236142

285006 FIX: XML Parsing Error 6603 or Truncated Text Data with OPENXML

Bug ID:236167

274266 FIX: Data Modification Query with a Distinct Subquery on a View May Cause Error 3624

Bug 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 Slowly

Bug ID:236191

280744 FIX: Update Query Returns Error 1903 if Temporary Composite Index Over 900 Bytes

Bug 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 Ignored

Bug ID:236230

290080 FIX: Assert Occurs When You Try to Alter a Database and Trace Flag 902 is Enabled

Bug ID:236233

290083 FIX: FOR XML EXPLICIT: Conflict Attribute in xmltext Is Not Overwritten if xmltext Contains DBCS

Bug ID:236274

293155 FIX: BCP with Format File and -R Parameter Ignores Regional Settings

Bug ID:236293

278509 FIX: Distribution Agent Ignores Quoted Identifier Option on Initial Sync to Oracle Subscribers

Bug ID:236309

274773 FIX: If You Change Windows Security to Windows/SQL Security the SA Password is Blank

Bug ID:236325

276329 FIX: Complex Distinct or Group By Query Can Return Unexpected Results with Parallel Execution Plan

Bug ID:236329

290415 FIX: Use of the Jet Provider to Query a Linked Server Text File from SQL Server May Be Very Slow

Bug ID:236374

290351 FIX: SQL Server Assertion During Distributed Transaction

Bug ID:236375

289893 FIX: Current Row's Time if Empty Is Replaced by Previous Row's Time in Bulk Copy

Bug ID:236394

293464 FIX: Merge Replication Does Not Log Conflicts after Successively Adding and Dropping Columns

Bug ID:236400

275901 FIX: SQL RPC That Raises Error Will Mask @@ERROR with Msg 7221

Bug ID:236421

300183 FIX: SQL Server Cluster Resource Fails to Come Online Until Cluster Service Is Restarted

Bug ID:236443

279296 FIX: Using ALTER TABLE to Change Column Type Can Result in Unexpected NULL Values on INSERT

Bug ID:236453

280294 FIX: SQL Server ODBC Driver Reuses Incorrect Parameter Length

Bug ID:236456

294420 FIX: Logreader Fails to Select Text Data that is Inserted by SQL Server 6.5 Bcp Utility

Bug ID:236457

277640 FIX: Denial of Service Attack with NULL Bytes in RPC Request

298012 Malformed RPC Request Can Cause Service Problems

Bug ID:236561

295373 FIX: Creating Indexes in Parallel May Fail with Deadlock on Sysindexes

Bug ID:236588

279659 FIX: SQL Server 2000 Takes Much Longer to Compile the Query Against Local Partitioned View Than SQL Server 7.0

Bug ID:236595

288957 FIX: Multiple Calls To a User Defined Function Within an Aggregate Function May Return Incorrect Results

Bug ID:236625

267953 FIX: Interleaving Prepare And Adhoc Execute of Query May Cause Recompile Loop

Bug ID:236630

290353 FIX: Updating View Based on Partitioned View May Result in Assertion

Bug ID:236633

293329 FIX: Attaching Database Files Saved In Different Disk Folders Through SQL Enterprise Manager

Bug 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 Client

Bug ID:236682

297104 FIX: Backup or Restore Using Large Transaction Logs May Return Error 3241

Bug ID:236752

293784 FIX: Unable to Drop a Catalog When Disk Is Full

Bug ID:236753

278698 FIX: Exception Access Violation Encountered During Compile of Hash Match Team Plan

Bug ID:236765

279295 FIX: Parallel Index Creation on Large SMP Hardware Can Cause Handled Access Violation

Bug ID:300104

286775 FIX: Creating a Publication From Within DTSWIZ Fails with "Error 496: General Error" Error Message

Bug ID:300108

293489 FIX: Merge Replication with Dynamic Filters May Cause MMC to Fail

Bug ID:350775

279183 FIX: Scripting Object with Several Extended Properties May Cause Exception

Bug ID:350799

279293 FIX: CASE Using LIKE with Empty String Can Result in Access Violation or Abnormal Server Shutdown

Bug ID:350879

279123 FIX: SQL Server 2000 Uninstallation May Break SQL Server CE Replication

Bug ID:350886, 236168

292456 FIX: GetColumnInfo Returns Incorrect Column Information

Bug ID:350894

294783 FIX: Addition of a Column to an Incrementally Added Article Prior to Snapshot Generation Fails

Bug ID:350896

299914 FIX: Executing MAX or MIN Aggregate Functions on Column with Hypothetical Clustered Index May Result in CPU SPIN

Bug ID:350899

299470 FIX: SELECT with Distinct and Self Loop Join May Cause 1203 Error Message

Bug ID:350911

292637 FIX: Unicode Character String Longer Than Seven Bytes in a LIKE Clause Is Truncated in Execution Plan

Bug ID:350912

288174 FIX: Modifying a Table with DRI Cascade That Is Involved in an Indexed View May Cause Msg 8624

Bug ID:350933

287401 FIX: Unable to Use GOTO in an Execute SQL Task of a DTS Package

Bug ID:350958

297156 FIX: Snapshot Agent Error Occurs While Adding Table with a Space in Name to an Existing Merge Publication

Bug ID:350970

300217 FIX: "Update Index in Background" Option in Change Tracking May Not Work if Very Low Disk Space Detected

Bug ID:350984

300037 FIX: Error 229 "EXECUTE permission denied on object xp_mapdown_bitmap" on Merge Published Table

Bug ID:351022

285979 FIX: Changing Autostart Options for Named Instances Change Autostart Settings for the Default Instance

Bug ID:351023

303119 FIX: Upgrade to SQL Server 2000 Cluster Does Not Add All SQL Server Resource Dependencies

Bug ID:351025

279338 FIX: DBCC CHECKCONSTRAINTS Does Not Handle Names with Special Characters

Bug ID:351080

291275 FIX: sp_replsetoriginator May Generate Access Violation in Bidirectional Transactional Replication

Bug ID:351081

290592 FIX: Full-Text Rows Missing After Crawl Due to Full Disk

Bug ID:351097

295030 FIX: Index Tuning Wizard Execution May Generate Floating Point Exception

Bug ID:351119

299382 FIX: Zeros Incorrectly Removed from the Binary Column in SQL Profiler

Bug ID:351128

279804 FIX: INSERT Statement Incorrectly Conflicts with Constraint

Bug ID:351140

279867 FIX: Sending Maintenance Report by E-mail to Operator Fails in Maintenance Plan

Bug ID:351147

282416 FIX: Opening the Database Folder in SQL Server Enterprise Manager 2000 Takes a Long Time

Bug ID:351185

293345 FIX: ANSI Script from Profiler Cannot be Opened in Query Analyzer

Bug ID:351188, 351189

280380 FIX: Buffer Overflow Exploit Possible with Extended Stored Procedures

Bug ID:351196

280846 FIX: Merge Snapshot Agent May Fail With Syntax Error Message When Published Table Contains Computed Columns

Bug ID:351222

282455 FIX: SQL Server Fails to Start When Computer Binds 48 or More Socket Addresses

Bug ID:351225

282243 FIX: Incorrect Results with Join of Column Converted to Binary

Bug ID:351229

295039 FIX: Assertion Raised When DELETE Is Performed on a Table Joined with a View

Bug ID:351230

288996 FIX: System View Sysopentapes Can Be Dropped

Bug ID:351235

289551 FIX: Generate SQL Script in Enterprise Manager Generates Scripts in Wrong Sequence if the Table has User-Defined Function as Computed Column

Bug ID:351242

293761 FIX: Dynamic Filtered Tables Do Not Replicate Data From Joined Tables to SQL Server CE Subscribers

Bug ID:351243

287606 FIX: Enterprise Manager Reports Table Sizes That Are Inconsistent as Compared to sp_spaceused

Bug ID:351259

286255 FIX: UNION Query Returns Internal Query Processor Error Message 8623

Bug ID:351266

290642 FIX: Exists with Full Outer Join May Generate Access Violation

Bug ID:351268, 351286

281843 FIX: SQLDMO GetProcessInputBuffer Returns Incorrect Result

Bug ID:351300

294970 FIX: Distribution Agent Fails with Syntax Error with Compensating Commands for Queued Updating Subscribers

Bug ID:351305

286249 FIX: Complex Update Statement Returns 8624 Internal SQL Server Error

Bug ID:351307

299366 FIX: Calling Remote Stored Procedure Inside Local Stored Procedure While Passing Text Parameter Causes AV

Bug ID:351327

294415 FIX: Resource Does Not Failover Immediately if an Error is Encountered by the Resource DLL

Bug ID:351328

295032 FIX: Job Step Fails if First INSERT of Batch Job Encounters a Msg 3604 Error

Bug 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 Output

Bug ID:351343

281239 FIX: xp_findnextmsg Returns Multiple Rows When No Parameters Are Specified

Bug ID:351363

282229 FIX: SP_OA Procedures Leak Memory and Cause Various Errors

Bug ID:351373

284228 INF: New Trace Flag to Enhance Stored Procedure Replication

Bug ID:351375

282279 FIX: Execution of sp_OACreate on COM Object Without Type Information Causes Server Shut Down

Bug ID:351376

286565 FIX: SQL Server Process Terminates Attempting to Reset from an sp_OA Based Batch

Bug ID:351394, 352221

288122 FIX: Lock Monitor Uses Excessive CPU

Bug ID:351407

288189 FIX: DTS FTP Task May Fail to Download Files After a Network Problem

Bug ID:351431

299361 FIX: Timestamp Column Truncated When Replicating with Sybase Using Merant OLEDB Provider

Bug ID:351441

283825 FIX: DBCC DBREINDEX Does Not Keep Original Fillfactor

Bug ID:351450, 352729

293328 FIX: Update Query Does Not Execute Correctly

Bug ID:351471

292455 FIX: OSQL Does Not Display Column Names for Query

Bug ID:351474

289149 FIX: A Query That Uses Hash Match Teams May Fail with 8630 Error Message

Bug ID:351486

299865 FIX: DMO BulkCopy fails to copy data when column names contain the space character

Bug ID:351502

286253 FIX: Multiple SQL Agent Jobs Launched At The Same Time May Fail With Primary Key Error Message

Bug ID:351513

286788 FIX: Server Side Cursor May Return Incorrect Results

Bug ID:351566

282982 FIX: Suboptimal Performance Using a Cursor to Update a Heap Involved in an Indexed View

Bug ID:351620

291780 FIX: DTS Transfer Objects May Fail if Dependent Objects Are Not in Alphabetical Order

Bug ID:351634, 351180

290917 FIX: Incorrect Identity Values After Failed Unique Index Creation

Bug ID:351653

290643 FIX: Microsoft Search Service Cannot be Stopped During Large Population

Bug ID:351658

299544 FIX: Correlated Subquery Containing UNION ALL May Cause Access Violation

Bug ID:351669

294459 FIX: Can't Use Four-Part Name to Query Oracle Table if Name Contains Lowercase Characters

Bug ID:351682

290058 FIX: SQL Mail Procedures May Intermittently Fail with Error 0x8004010f

Bug ID:351686

286774 FIX: SQL Server 2000 Cluster Setup Fails with "Entry Point for DllCNVREM.dll not found" Error Message

Bug ID:351698

293758 FIX: Nullability Changes not Handled by SQL Server with Linked Server Queries to DB2

Bug ID:351714

285952 FIX: NO_TRUNCATE May Be Added to Backup Log Statement when You Perform a Log Backup from SEM

Bug ID:351729

291376 FIX: Cannot Use Dynamic SQL Statements Within OPENQUERY

Bug ID:351736

295053 FIX: OPENXML May Leak Worktables in Memory

Bug ID:351754

289880 FIX: SQL Server Assertion Failure Occurs if Recovery Model of TempDB is not SIMPLE

Bug ID:351761

285870 FIX: Update With Self Join May Update Incorrect Number Of Rows

Bug ID:351773

292755 FIX: Full-Text Queries May Return "Unspecified Error" Error Message

Bug ID:351791

290921 FIX: UPPER and LOWER Functions Return Metadata Length as if DBCS Were Used

Bug ID:351797

289739 FIX: Distributed Query with Optika Provider May Return Incorrect Results

Bug ID:351829

275145 FIX: Only One SQL Server Performance Condition Alert Is Treated As Active

Bug ID:351866, 351704

295034 FIX: Microsoft Search Service May Cause 100% CPU Usage if BUILTIN\Administrators Login Is Removed

Bug ID:351892

286737 FIX: FetchBufferSize Greater than Certain Number Fails to Transfer all Rows and Does Not Return an Error

Bug ID:351894

280720 FIX: xp_sendmail Generates UNICODE CSV File Format

Bug ID:351901

289475 FIX: SQLAgent Incorrectly Uses TLSAlloc for Transact-SQL Jobs Causing all TLS Slots to be Exhausted

Bug ID:351918

295037 FIX: MERGE UNION Is Not Used with Large Number of UNION Clauses

Bug ID:351920

290085 FIX: Extended Stored Procedure "xp_logevent" Generates an Access Violation when Given Too Large a Parameter

Bug ID:351927

294338 FIX: xp_enumgroups Generates an Access Violation when Passed a Large Parameter

Bug ID:351939

286749 FIX: Table Creation, Row Insertion, and Index Creation Inside Transaction, Followed By Addition of Constraint May Result in Consistency Errors

Bug ID:351941

293292 FIX: DBCC CHECKDB May Produce an Access Violation When Database Is in Use

Bug ID:351948

290644 FIX: DTSRun.exe Causes Access Violation on SMP Computers

Bug ID:351952

290739 FIX: Iterating Through SQL Mail Messages Using Extended Procedures Takes Longer in SQL Server 2000

Bug ID:351953

290210 FIX: Removal of Full-Text Index May Incorrectly Remove Rows From sysdepends System Table

Bug ID:351984

299448 FIX: Subquery That References Table with No Statistics and Returns Empty Result Set May Cause AV

Bug ID:351990

291851 FIX: Merge Replication Stored Procedures May Be Scripted Incorrectly When an Article is in Two Publications

Bug ID:352016

299937 FIX: Changes to Indexed View Article of a Transactional Publication Are Not Saved

Bug ID:352024

298402 INF: Understanding How to Set the SQL Server I/O Affinity Option

Bug ID:352036

289691 FIX: Sysprocesses Is Incorrectly Showing Rollback Status Even Though the Transaction Is Not Rolling Back

Bug ID:352038

303224 FIX: Use of the Copy Database Wizard to Copy a Database Disables Full-Text Indexing on the Source Database

Bug ID:352051

299787 FIX: Skewed Replication Statistics in Output File When Running Agent Continuously

Bug ID:352074

290077 FIX: DTS Scheduled Job Does Not Complete After First Run

Bug ID:352077

291540 FIX: Instead of Triggers that Use Work Tables Cause a Memory Leak

Bug ID:352081

300272 FIX: Transfer of a View that Contains a UDF by Using DTS Export Data Fails with Error 208

Bug ID:352082

300194 FIX: Error 644 Using Two Indexes on a Column with Uppercase Preference Sort Order

Bug ID:352091

288426 FIX: Alerts Triggered Incorrectly When Security Auditing is Enabled

Bug ID:352092

295045 FIX: SELECT DISTINCT Returns Incorrect Results in SQL_Latin1_General_Pref_Cp1_CI_AS Collation

Bug ID:352098

290918 FIX: Incorrect Behavior of LIKE [-] When Using an Index

Bug ID:352099

294929 FIX: MSDE Installation Contains the Wrong Icon for the Service Manager

Bug ID:352114

299889 FIX: Full Population May Not Complete if Microsoft Search Service Is Stopped and Restarted

Bug ID:352142

289472 FIX: SQLAgent Exception Occurs when the System Maintains 613, 2661 or 4709 Jobs

Bug ID:352148

290413 FIX: DB-Library sp_cursor Fails with Error Message 16933 if Bracketed Identifiers are Passed with the Tablename Parameter

Bug ID:352211

290645 FIX: SQL Server Active Directory Registration Always Reports Success

Bug ID:352213

300180 FIX: sp_MSexpandnotbelongs May Be Called at Publisher Due to Invalid Evaluation of Join Filter

Bug ID:352217

292761 FIX: xp_startmail Error Message Does Not Indicate Problem

Bug ID:352230

302421 FIX: Query Issued Against Two Instances of the Same Table May Cause an Access Violation

Bug ID:352255

292737 FIX: Drag and Drop Object Type Node to the Editor in Query Analyzer Returns Error Message

Bug ID:352264

291274 FIX: Correlated Subquery on Partitioned Views with Text Operations May Cause Access Violation

Bug ID:352271

291273 FIX: SQLMail Incorrectly Uses Default Mail Profile

Bug ID:352297

293166 FIX: Parallel Modification Operation May Spin Trying to Release Locks

Bug ID:352303

294999 FIX: SQL Server Fails to Start with \f Option on Computers with Many CPUs

Bug ID:352312

290814 FIX: xp_readmail Leaks Memory if Message Contains Attachment

Bug ID:352320

293430 FIX: SEM New SQL Server Registration Using Long Server Name Fails with Access Violation

Bug ID:352326

298803 FIX: Coalesce with Subquery May Generate an Access Violation

Bug ID:352345

291566 FIX: Parallel Plan for Index Creation of Non-Clustered Index May Result in Use of Pages That are not Allocated

Bug ID:352358

300056 FIX: Merge Metadata Cleanup May Cause Subscriber Transaction Log to Grow Quickly

Bug ID:352372

292753 FIX: Some Object Browser Folders Cannot Be Scripted

Bug ID:352404

291235 FIX: Query Analyzer Hangs After You Drag && Drop Files Into the Query Editor and You Close One of the Newly Created Windows

Bug ID:352492

296685 FIX: Cannot Execute SELECT COUNT(*) Against DB2 on Mainframe Using Four-Part Name

Bug ID:352500, 351440

288330 FIX: FTP Task in DTS Deletes File from the Destination Folder After the Package Completes Execution

Bug ID:352501

294902 FIX : Rollback to Savepoint Causes Assertion and Errors

Bug ID:352555

295022 FIX: Sqlmaint.exe Is Not Available with MSDE 2000

Bug ID:352575, 352695

293232 FIX: Undetected Deadlock Occurs When Lock Owner Is Waiting on CXPACKET

Bug ID:352606

299602 FIX: Extended Stored Procedure xp_sendmail Does Not Handle DBCS Correctly

Bug ID:352608

295459 FIX: sp_helptext Fails with Invalid Length Parameter Error

Bug ID:352640

286286 FIX: LOCK_TIMEOUT Causes Transaction to Roll Back and @@error Does Not Capture Error 1222

Bug ID:352700

294874 FIX: Combination of Multiple EXIST, OR, and Subquery Clauses May Give a Sub-Optimal Plan

Bug ID:352705

294787 FIX: Update Plan with User Defined Function May Fail to Find a Plan

Bug ID:352735

293632 FIX: EventSubClass Column Incorrect for Deadlock Chain Events

Bug ID:352765, 353201

298951 FIX: Snapshot Agent for Merge Publication May Fail with 107 Error

Bug ID:352793

293484 FIX: Incorrect Record is Deleted or Updated When a Clustered Index is in Descending Order

Bug ID:352799

295644 FIX: Transaction Log Restores May Fail with 3456 Error

Bug ID:352807

295046 FIX: OLE Automation Fails When Calling ADODB.Connection Methods

Bug ID:352826

299285 FIX: Query with Complex Correlated Subquery May Cause Unexpected Results in Aggregate Functions

Bug ID:352830

295055 FIX: sp_OAMethod Does Not Convert Numeric Datatype Correctly

Bug ID:352839

294872 FIX: Update on a Table with INT and BIT Columns May Zero Out INT Columns

Bug 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 Computer

Bug ID:352867

295023 FIX: "SET ROWCOUNT" May Cause Data to be Unreadable

Bug ID:352935

295113 FIX: Corrupted TDS Packets Cause Access Violation in SQL Server

Bug ID:352963

299903 FIX: sp_scriptpublicationcustomprocs Generates Replication Stored Procedures

Bug ID:353011, 353081

294828 FIX: Passing a Large Command Line String to Query Analyzer Results in Assertion Failed

Bug ID:353031

294839 FIX: No Error Message Generated by Query Analyzer When You Try to Open a Database with a Name Greater Than 128 Characters

Bug ID:353107

295006 FIX : OSQL Utility Returns Incorrect Error Message

Bug ID:353170

294412 FIX: SQLAgent T-SQL Job Does Not Respect SET NOCOUNT ON When Sending Output to File

Bug ID:353206, 352955

294860 FIX: Modification Queries May Take Too Long to Compile if Halloween Protection is Required for Multiple Tables

Bug ID:353275

295193 FIX: Merge Module Sqlsvr.msm Fails Validation with ICE03

Bug ID:353324

295627 FIX: Xp_readmail May Cause System to Stop Responding in Windows 95 or Windows 98

Bug 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 Mail

Bug ID:353394

296098 FIX: xp_sendmail Fails with the @attach_results Parameter on SQL Server 2000 Personal Edition

Bug ID:353405

299351 FIX: MSDE Installation Fails on Systems That Have SQL Server 2000 Service Pack 1 Installed

Bug ID:353492

300145 FIX: Merge Replication Conflict Viewer Resolves Data Conflicts Incorrectly

Bug ID:353641

296465 FIX: Mssearch.exe Memory Leak Occurs when Results are not Completely Processed

Bug ID:354039, 353802

299717 FIX: Query Method Used to Access Data May Allow Rights that the Login Might Not Normally Have

Bug 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