The following is a list of bugs that have been fixed by SQL
Server 7.0 Service Pack 3 (SP3). The links point to currently published
Microsoft Knowledge Base articles.
|
26147 | 281338 | FIX: Select
Distinct Fails to Eliminate Duplicate Null Values on Bit Datatype |
49541 | 274310 | FIX: Error 823
or 8966 Reported by SQL Server with Insufficient System Resources |
54404 | 262699 | FIX: User
Logged Into DB in Single User Mode May Encounter 924 Error |
55011 | 231759 | FIX: SEM
Generates SQL-DMO Error When Adding an ODBC Subscriber |
55030 | 264489 | FIX: Index
Tuning Wizard Does Not Process Parameterized Workload Across Batches |
55450 | 279505 | FIX:
Transaction Log Space Grows on Standby Server |
55180 | 280872 | FIX: SQL Server
7.0 Microsoft Search Fails to Start and Error Message 1332 Occurs |
55912 | 283899 | FIX: Adding
Several Constraints in a Single ALTER TABLE Statement May Get Assertion
Followed by Error 3624 |
55981 | 235693 | FIX: Select
Query with GROUP BY and Outer Join Causes Handled Access Violation |
56075 | 249294 | FIX: Password
Fails to Meet Password Policy Requirements |
56180 | 275145 | FIX: Only One
SQL Server Performance Condition Alerts Is Treated As Active |
56244 | 262519 | FIX:
SQLSetCursorName Fails When "Use ANSI Quoted Identifiers" Is Cleared |
56266 | 240853 | FIX: Lock
Escalation With Parallel Query May Cause 1203 Error And Server Shutdown |
56598 | 243740 | FIX:
Replication AddSubscription Method Causes Handle Leak on Failure |
56646 | 281129 | FIX: Update of
Table with Large varchar Columns May Cause Access Violation |
56702 | 262023 | FIX: Queries
With Large Numeric Values May Not Use Appropriate Index |
56806 | 247749 | FIX: Column
Level Permissions not Scripted When Generated Using Enterprise Manager When
Table Level Permissions Exist for That Role or User |
56832 | 279697 | FIX: Text
Truncated in Replication Property Page with Japanese Locale |
56950 | 280791 | FIX: Assert
Occurs in SQL Server When You Run DBCC CHECKDB or sp_adddistributiondb |
57034 | 279690 | FIX: Duplicate
Hotkeys in German SQL Server 7.0 DTS Import Wizard |
57044 | 263649 | FIX: Handled
Access Violation on INSERT Through Cursor |
57112 | 278250 | FIX: DTS:
Transfer Objects and Data May Cause Access Violation |
57127 | 247871 | FIX: DTC
Commit/Abort Operation may Leave Suspended Worker Thread with Waittype
0x0201 |
57131 | 274354 | FIX:
FAST_FORWARD Cursors Perform Slower |
57161 | 247069 | FIX: Using
ICommandPrepare->Prepare() May Cause ICommand->Execute() not to Report
Errors |
57213 | 277809 | FIX: A
Non-Sysadmin May Execute sp_procoption Stored Procedure |
57260 | 275618 | FIX: Cannot Set
SQLServerAgent Password to More Than 16 Characters in Enterprise Manager |
57268 | 279015 | FIX: SQL Server
Does Not Run RESTOREVERIFYONLY When Scheduling a Back Up in SQL Enterprise
Manager |
57286 | 264041 | FIX: DBCC
CHECKALLOC May Inaccurately Report Errors 8968 and 8998 |
57295 | 241448 | FIX:
Replication with Immediate-Updating Subscribers Fails with Error 21082 |
57299 | 275614 | BUG: Bulk
Insert - lacked row when truncates error |
57330 | 279511 | FIX: DBCC
SHRINKFILE with Empty Option May Not Move Heap and Text Pages |
57354 | 256649 | FIX:
Simultaneous DTC Operations May Cause Errors |
57394 | 280739 | FIX: DTS Wizard
Hangs at Startup While Enumerating OLEDB Providers |
57401 | 275503 | FIX: BCP Out
Fails with Exception Error if You Use a Format File to Change Order of
Columns |
57417 | 278280 | FIX: Abort of
mult-database transaction can fail with assertion |
57435 | 276303 | FIX: Fatal
Exception "EXCEPTION_FLT_OVERFLOW" Occurs During Query Optimization |
57436 | 253010 | FIX: Busy
Connections Leave Cursors Open After Call To SQLFreeStmt or SQLCloseCursor |
57450 | 253230 | FIX: SEM:
Appended Backup Database with Verify Always Checks Only FILE Number = 1 |
57453 | 274428 | FIX: Revoking
Update Permissions on a Table Also Revokes Column-Level Select Permissions |
57468 | 276595 | FIX:
Replication Agents Print Logon Password When You Use the Output Parameter |
57471 | 275619 | FIX: RPC That
Calls Another RPC Returns an Error Message and Incorrect Results |
57477 | 280361 | FIX: "Generate
SQL Script" in Enterprise Manager May Not Script Out the Correct
Permissions |
57488 | 264192 | FIX: Bulk Load
Operation on Nchar Field Pads Incorrectly |
57515 | 260342 | FIX:
Replication Agents May Fail With Arithmetic Overflow Errors Due to Large
Latencies |
57525 | 258083 | FIX: Abort of
Distributed Transaction with Xproc May Cause Assertions, Access Violations and
Server Shutdown |
57532 | 258087 | FIX: Non-Admin
User That Executes Batch While Server Shuts Down May Encounter Retail
Assertion |
57537 | 281617 | FIX: SQLMAINT
Backup to Tape with Verify Only Checks the First File |
57545 | 259775 | FIX: ISNULL
with ANSI_WARNINGS OFF Drops Connection On Divide By Zero |
57554 | 262462 | FIX: Conversion
Errors Occur in Prepared Statements That Use UNIONs |
57559 | 255900 | FIX: DTS
Package Created on Uplevel (2.5/2.6) MDAC May Fail on Computer with Downlevel
(2.1) MDAC |
57560 | 275487 | FIX: Stack
Overflow Exception Error Occurs When You Insert 250 KB or More of Data Into a
Text or Image Column |
57569 | 275487 | FIX: Stack
Overflow Exception Error Occurs When You Insert 250 KB or More of Data Into a
Text or Image Column |
57602 | 260346 | FIX:
Transactional Publications with a Filter on Numeric Columns Fail to Replicate
Data |
57615 | 276583 | FIX: Error
Message Occurs When You Open a DTS Package Saved with Characters that do not
Exist in SQL Server Code Page |
57631 | 275724 | FIX: After
Performing a Replace All in Query Analyzer, Queries don't Execute |
57635 | 278383 | FIX:
Replication Monitor Is Not Updated After Anonymous Subscription (Distribution
or Merge) Expires |
57640 | 284237 | FIX: SELECT
Statement with Two LIKE Clauses Where the Table Has a CHECK Constraint Causes
AV |
57641 | 279793 | FIX: Error
Message 602 During Recovery of a Database |
57658 | 276039 | FIX: Duplicate
Hash Keys Generated for Two Distinct Index Key Values on Non-Unique Clustered
Index |
57661 | 261133 | FIX: DTS "Send
Mail" Fills Up Mailbox and Outlook Cannot See or Delete E-Mail Messages |
57680 | Q278442 | FIX: DTS
Import Wizard Closes When You Browse for SQL Server Servers |
57686 | 278509 | FIX:
Distribution Agent Ignores Quoted Identifier Option on Initial Sync to Oracle
Subscribers |
57693 | 278855 | FIX: Assert in
Errorlog During WITH STANDBY Recovery on a Replicated Database |
57695 | 257424 | FIX: Problem
Upgrading Japanese Database Servers to Windows 2000 After Installing Service
Pack 2 |
57700 | 278964 | FIX: Temporary
Tables Are Not Dropped When the Merge Agent Runs in Continuous Mode |
57706 | 263304 | FIX: UPDATE
Fails Under INSERT/UPDATE Stress on Non-Indexed Table |
57727 | 275622 | Datetime Column
Defaults Load Incorrectly During BULK INSERT |
57729 | 278421 | FIX: A SELECT
Statement with a Large IN Clause May Fail with a Stack Overflow and the Client
Disconnects |
57730 | 260087 | FIX: Large
Error Numbers May Cause Heap Corruption in SQLServerAgent Service |
57737 | 276533 | FIX: Upgrading
a Republishing Merge Subscriber to SP2 May Fail with Error Message 20026 |
57746 | 274995 | FIX: Plan
re-use gives incorrect query results |
57752 | 258198 | FIX: Error
Message 8630 Occurs When Updates are Performed to a Table with Compound
Keys |
57757 | 259021 | FIX: Parallel
Hash Join with Empty Result Set Incorrectly Flows Error Back on Client
Connection |
57764 | 274521 | FIX: BULK
INSERT May Silently Reject NULL Values for NOT NULL Columns |
57775 | 274483 | FIX: Unable to
Choose Article Resolver When You Use SQL Server 2000 Distributor and SQL Server
7.0 Publisher |
57785 | 280685 | FIX: Preparing
a Statement That References a Missing Object Incorrectly Succeeds |
57799 | 258974 | FIX: Query
Analyzer Might Not Save all Rows in the Result Set to a File When You Use the
"Results in Grid" Option |
57801 | 274801 | FIX: SQL Server
7.0 Clients on Windows 2000 May Cause Extra Trip to Domain Controller During
Integrated Logon |
57804 | 259551 | FIX: Database
Remains in Single User Mode with the Database Maintenance Plan Option "Repair
Any Minor Problems" |
57805 | 281185 | FIX: Linked
Index Server Query Through OLE DB Provider with OR Clause Reports Error
7349 |
57806 | 259141 | FIX: SP2
Regression: 8624 Error Might Occur When You Modify a Table with a Complex
Query |
57812 | 264170 | FIX: Immediate
Updating Subscribers Receive Error Message 7415 When Performing UPDATES and
INSERTS |
57816 | 274716 | FIX: Error "The
System Cannot Find the File Specified" When You Open a DTS Package |
57820 | 281141 | FIX:
Replication Distribution Agent That Uses ActiveX Control May Skip INSERT
Commands Under Stressed Condition |
57826 | 278629 | FIX: Merge
Replication Agent Fails with "The merge process could not initialize the
subscription" Error Message |
57827 | 265355 | FIX: NCHAR
Columns Padded with Empty Strings Instead of Spaces During BCP/BULK INSERT |
57828 | 275624 | FIX: Identity
Value Recovery May Fail After a Nonlogged Bulk Load |
57829 | 279088 | FIX: Merge
Agent May Ignore Subscriber-Side Changes in Articles with the Same Name |
57846 | 261216 | FIX: Snapshot
Agent for a Merge Publication Might Fail with Error Message 4408 or 50007 |
57857 | 274661 | FIX: Delete
operation may fail to delete some of the qualified rows with a self-referencing
subquery |
57864 | 278980 | FIX: Insert
with SUBSTRING Operation Fails if JOIN Comparison is Based on NULL Values and
LIKE Clause |
57871 | 262019 | FIX: Aborting
Parallel Query With Hash Operation May Orphan Extents in Tempdb |
57872 | 268150 | FIX:
INSERT..SELECT with NOT EXISTS Can Choose Slower Merge Join Plan |
57899 | 277547 | FIX: Table
Corruption When Using BCP with SELECT INTO/BULK COPY, Nonclustered Index, and
IGNORE_DUP_KEY |
57901 | 266008 | FIX: Ad Hoc
Access Denied Post SP2 Using OPENROWSET |
57904 | 278285 | FIX: Attention
During Tempdb Auto Stats May Result in Server Shutdown |
57912 | 263955 | FIX: Merge
Agent Fails with "Setting Sentgen Too High" Error Message |
57921 | 274706 | FIX:
Regression: Compilation of Many UNIONs Takes Excessively Long Time |
57922 | 278965 | FIX: Patindex
Function May Return Incorrect Result on SQL Server 7.0 with DBCS Codepage |
57938 | 276225 | FIX: SQL Server
7.0 Service Pack 2 May Fail to Delegate the Filter Condition to the
Provider |
57939 | 278021 | FIX: Clearing
"Enforce constraint for replication" Check Box for a CHECK Constraint Breaks
Constraint Checking on All Nonreplication Operations |
57941 | 274467 | FIX: Queries
with TOP N PERCENT in Subquery May Fail with Error Message 8623 |
57944 | 264005 | FIX: Error
Message 8623 Occurs If You Use INSERT-SELECT with NOT IN or NOT EXISTS Keywords
in Subquery of the WHERE Clause |
57949 | 275690 | FIX: SQL Server
Agent Startup May be Delayed by Four Seconds |
57952 | 264646 | FIX: Snapshot
Agent Fails with 4408 Error Message if a Merge Publication Contains a Large
Number of Join Filters |
57954 | 266234 | FIX: Parallel
Query That Has Many Bit Columns May Cause Access Violation |
57956 | 263968 | FIX: Service
Pack Install Can Save Standard Security Password in File |
57959 | 272220 | FIX: TEXT/IMAGE
Data Storage Space Not Reclaimed Correctly |
57962 | 267264 | FIX:
Distribution Agent May Fail to Report That a Subscription is Marked as
Inactive |
57963 | 278353 | FIX: Race
Condition When Server Allocates Memory Can Cause AV |
57966 | 279319 | FIX: Query
Using Nested IN and a CASE Clause Causes an Access Violation |
57978 | 264687 | FIX: ADO
Applications Report a Syntax Error When Column Names Contain Spaces |
57983 | 266234 | FIX: Parallel
Query That Has Many Bit Columns May Cause Access Violation |
57985 | 262973 | PRB: Possible
Thread Starvation Detected Message Reported in the SQL Server Error Log |
57986 | 277897 | FIX: OLEDB:
DBCC SHOW_STATISTICS May Cause Protocol Error Message in TDS Stream |
57987 | 279823 | FIX: Restore of
a Database Gives Error 4038 Due to Malformed Media Set |
57997 | 274811 | FIX: Keyset
Cursor Fetches Same Row Repeatedly |
57999 | 278978 | FIX: SELECT May
Not Return All Rows if It Contains a Large Number of Values in an IN Clause on
a NUMERIC Column |
58000 | 264880 | FIX: Passwords
May Be Retrieved from Enterprise Manager and from a DTS Package with No Owner
Password |
58007 | 266158 | FIX: Complex
Merge Join Might Cause Handled Access Violation |
58015 | 276992 | FIX: Bulk
Insert or Snapshot Replication May Corrupt Table During NOLOCK Scans |
58026 | 273009 | FIX:
sp_helptext May Fail to Return the Correct Text when a New Line Begins at
Multiples of 8000 Bytes |
58032 | 266158 | FIX: Complex
Merge Join Might Cause Handled Access Violation |
58035 | 263968 | FIX: Service
Pack Install Can Save Standard Security Password in File |
58041 | 281287 | FIX: Msg 8964
on Index with IGNORE_DUP_KEY and Row Has a Text Column |
58044 | 265865 | FIX: Float Data
Inaccurately Converted when Sent to Linked Server |
58055 | 278387 | FIX:
INFORMATION_SCHEMA.KEY_COLUMN_USAGE.ORDINAL_POSITION Column Reflects Incorrect
Data |
58057 | 278360 | FIX: NT User
and Domain Name May not be Recorded by SQL Profiler for a Standard Security
Connection |
58059 | 260342 | FIX:
Replication Agents May Fail With Arithmetic Overflow Errors Due to Large
Latencies |
58063 | 267953 | FIX:
Interleaving Prepare And Adhoc Execute of Query May Cause Recompile Loop |
58065 | 274353 | FIX: Query
Analyzer: Empty Row is Returned with COMPUTE on SMALLINT Data |
58068 | 268153 | FIX:
Distributed Query with NO_BROWSETABLE Against Timestamp Column Can Cause Access
Violation |
58075 | 274376 | INF:
sp_mergecleanupmetadata Optimized for Speed and Less Disk Space Usage |
58078 | 282175 | FIX: Parallel
Query on Four CPUs Using NLS Is Slower Than Two CPUs |
58090 | 266368 | FIX: Updates
That Use LEFT OUTER JOIN May Not Complete if Parallelism Is Used |
58092 | 266372 | FIX: OPTION
(MAXDOP 1) Hint May Not Turn Off Parallel Query |
58093 | Q282036 | FIX: Setting
Retention Period of a Merge Publication Can Drop Subscriptions |
58095 | 266766 | FIX: Temporary
Stored Procedures in SA Owned Databases may Bypass Permission Checks When You
Run Stored Procedures |
58099 | 275992 | FIX: Running
Sp_vupgrade_replication May Fail with Timeout Expired Error Message During
Service Pack 2 Upgrade |
58101 | Q283934 | FIX: Merge
Replication Fails After a Call to sp_MSgetrowmetadata |
58103 | 278363 | FIX: Attentions
During Non-Logged Allocations in tempdb can Result in Errors 8906 and 8946 |
58112 | 264880 | FIX: Passwords
May Be Retrieved from Enterprise Manager and from a DTS Package with No Owner
Password |
58121 | 275615 | FIX: Restore
Command That Uses Large File Names May Cause Access Violation |
58127 | 267599 | FIX: Running a
Stored Procedure While SET FMTONLY is Off and On Can Cause 602, 604 and 618
Error Messages |
58129 | 268081 | FIX: Error
Message 1511 Occurs When You Restore a Database or Transaction Log Dump |
58130 | 275304 | FIX: Access
Violation with Queries that Involve Hash Join on Large Data Sets |
58133 | 268275 | FIX:
Transactional ActiveX Pull Subscribers May Expire Even If They Synchronize
Within Retention Period |
58137 | 285127 | FIX: Updates
Are Replicated as Delete/Insert Pair Even When Updates Should Not Be
Replicated |
58148 | 268413 | FIX: SP2
Regression: DTS Transfer Fails with Access Violation if Destination Server is
Unnamed |
58156 | 276427 | FIX: Snapshot
Fails with Duplicate Key Row in MSmerge_genhistory |
58158 | 280747 | FIX: UPDATE
Statement on a Clustered Index Key Fails with Error 547 |
58161 | 276751 | FIX: Bulk
Insert May Leak Memory in Abort Cases |
58168 | 275427 | FIX: SP2
Regression: Update That Contains a Join Causes a 601 Error Message and Produces
Incorrect Results |
58170 | 275661 | FIX: Error
Message 6107 Occurs with Transact-SQL KILL Command After Pooled Connection is
Reset |
58174 | 274314 | FIX: SQL Server
7.0 SP2 Unattended Client Setup Results in "MMC Snap-In Failed to Initialize"
Error Message |
58175 | 269560 | FIX:
LoginTimeout and QueryTimeout Properties in Replication ActiveX Control Are Not
Used During Execution |
58184 | 274993 | FIX: Column
Level Permissions May Be Displayed Incorrectly When GRANT_WITH_GRANT Option Is
Used |
58186 | 272457 | FIX: SQL Server
Exception Encountered in CQDynArray::Resize |
58198 | 278366 | FIX: Concurrent
Shrink Operations Against Heaps can Result in Errors 8968, 8905, and 8906 |
58199 | 269282 | FIX: Error
Message 602 Occurs When You Query a Temporary Table That Has a Non-Clustered
Index |
58203 | 269839 | FIX: Access
Violation Occurs When Querying a Remote Index Provider |
58212 | 274765 | FIX: SELECT
Statement May Generate Incorrect Results When Hash Join Is Used in the Parallel
Query Plan |
58214 | 282174 | FIX: Restoring
or Altering a Database Might Result in CPU Spin |
58223 | 269697 | FIX: SPID
Returns to ROLLBACK Status When You Cancel a SELECT Statement with a Parallel
Plan |
58233 | 273584 | FIX:
Multiserver Jobs Fail to Download on French Localized TSX |
58247 | 284440 | FIX: UPDATE
with CASE Statement That Uses NEWID() Function Causes Errors 8951, 8952, 8955
and 8956 |
58253 | 274470 | FIX: SELECT
DISTINCT May Return Incorrect Results Unless Column Set Equal to Itself |
58263 | 276529 | FIX: SP2
Regression - Update Queries with Hash Joins Do Not Update Any Rows |
58279 | 274266 | FIX: Data
Modification Query with a Distinct Subquery on a View May Cause Error 3624 |
58284 | 264646 | FIX: Snapshot
Agent Fails with 4408 Error Message if a Merge Publication Contains a Large
Number of Join Filters |
58285 | 280744 | FIX: Update
Query Returns Error 1903 if Temporary Composite Index Over 900 Bytes |
58286 | 281287 | FIX: Msg 8964
on Index with IGNORE_DUP_KEY and Row Has a Text Column |
58287 | 280807 | PRB: DTS
Packages in SQL Server 7.0 Cannot Be Saved Using SQL Server 2000 Encrypted
Format |
58289 | 276048 | FIX: AV in
COledbError::RaiseRestartPositionError running a FT query |
58293 | 280361 | BUG: "Generate
SQL Script" from Enterprise Manger may not script out correct permissions |
58299 | 277737 | FIX: Merge
Replication Reports Misleading Conflict When Using Horizontal Filtering |
58302 | 275339 | FIX: DTS Wizard
Specifies Destination Table Name Incorrectly |
58303 | 275670 | FIX: DTS Wizard
Parses Custom Datatypes Incorrectly |
58305 | 276060 | FIX: SELECT
with ORDER BY Does Not Maintain Sort Order if Run in Parallel |
58316 | 276041 | FIX: Retrieving
Text/Image Data May Return Error 5180 |
58319 | 278369 | FIX: Stack
Dumps May Be Incorrect or Incomplete When UMS Runs in Fiber Mode |
58325 | 278371 | FIX: Executing
SQL Diagnostics During Connect/Disconnect can Cause AV or Server Shutdown |
58327 | 278372 | FIX: Running
Stack Dumper Can Cause Memory Leak of Virtual Bytes |
58361 | 275536 | FIX: Linked
Server Query with Hyphen in LIKE Clause May Run Slower than Expected |
58369 | 281287 | FIX: Msg 8964
on Index with IGNORE_DUP_KEY and Row Has a Text Column |
58372 | 278394 | FIX: Error
Message 8509 Not Returned to Client Correctly When DTC Import Fails |
58383 | 277839 | FIX: Active
SDES for Negative Object ID Message Logged Followed by Process Termination |
58386 | 277843 | FIX: Restore of
Log in Standby Mode May Cause 9004 Error Message if the Original Database has
Shrink Enabled |
58397 | 276067 | FIX: Duplicate
Distribution Steps May Lead to Bad Plan Selection for >= or =<
Predicates |
58404 | 281295 | FIX: Merge
Replication Synchronization May Be Slow |
58405 | 275593 | FIX: DELETE
Results in 8908 Error Message When You Use a Parallel Plan |
58433 | 275901 | FIX: SQL RPC
That Raises Error Will Mask @@ERROR with Msg 7221 |
58465 | 277029 | PRB: SQL Server
7.0 as Master Server Cannot Enlist SQL Server 2000 Named Instance as Target
Server |
58467 | 277716 | Q277716 - FIX:
OPENQUERY/OPENROWSET with DB2 Linked Server May Return Incorrect Results with
Decimal Datatype |
58472 | 276234 | FIX:
SQLMaint.exe Sets Database Status Incorrectly |
58473 | 278671 | FIX: Slow Query
Performance When Non-SA Executes Query That Causes Trigger to Access the
INSERTED or DELETED Tables |
58497 | 276499 | FIX: SP2
Regression: Running a Stored Procedure with Index on Local Temp Table Causes
AV |
58503 | 281191 | FIX: SQL Server
Replication Syncronization to DB2 Subscriber Fails with Numeric Data Type |
58522 | 277839 | FIX: Active
SDES for Negative Object ID Message Logged and Followed by Process
Termination |
58544 | 277698 | FIX: LEFT OUTER
JOIN on a View that Uses the DISTINCT Keyword Produces Incorrect Results |
100932 | 280380 | FIX: Buffer Overflow Exploit Possible
With Extended Stored Procedures |
100936 | 280380 | FIX: Buffer Overflow Exploit Possible
With Extended Stored Procedures |
101265 | 288185 | FIX: Stored Procedure Continues to Use
Parameter Value Passed During First Execution |
The following articles are still being written and
therefore the links will not work. They are included here to provide you with
as much information as possible.
The following is a list of bugs that have been marked fixed by
SQL Server 7.0 Service Pack 3. The links point to currently published Microsoft
Knowledge Base articles.
The following is a list of bugs that have been marked fixed by
components external to SQL Server 7.0 and have been included in SQL Server 7.0
Service Pack 3 (SP3).
Didn't see an answer to your question? Visit the
Microsoft SQL Server Newsgroups at:
Comments about this or other
Microsoft SQL Server Knowledge Base articles? Drop us a note at