Article ID: 274797
Article Last Modified on 1/29/2007
APPLIES TO
- Microsoft SQL Server 7.0 Standard Edition
- Microsoft SQL Server OLAP Services
This article was previously published under Q274797
SUMMARY
The following is a list of fixes and various other improvements that have been made in Service Pack 3 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0. For more information, contact your primary support provider.
To 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:
7.00.623 if SQL Server 7.0 with no service pack applied 7.00.699 if SQL Server 7.0 Service Pack 1 7.00.842 if SQL Server 7.0 Service Pack 2 7.00.961 if SQL Server 7.0 Service Pack 3
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 3 for Microsoft SQL Server 7.0 (build 7.00.961) and Microsoft Data Engine (MSDE) 1.0, either click the link or use the Qxxxxxx number to query for the article in the Microsoft Knowledge Base.
SQL Server service packs are cumulative. All of the problems corrected in Service Pack 1 and Service Pack 2 are also corrected in Service Pack 3. For a list of those problems, refer to the following articles in the Microsoft Knowledge Base:
225019 SQL Server 7.0 Service Pack 1 fixlist
254369 SQL Server 7.0 Service Pack 2 fixlist
To download Service Pack 3, see the following article in the Microsoft Knowledge Base:
274799 How to obtain Service Pack 3 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0
To view the Readme.htm file that accompanies the Service Pack 3, see the following article in the Microsoft Knowledge Base:
274798 Readme.txt for SQL Server 7.0 Service Pack 3
MORE INFORMATION
SQL Server and MSDE FixList
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.
Bug ID | Link | Title |
---|---|---|
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 | 278443 | 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 | 283036 | 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 | 283034 | 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.
Bug ID | Link | Title |
---|---|---|
57883 | 278022 | FIX: Bulk Insert inserts garbage when converting text column from Multi Byte codepage to a Single Byte codepage |
57917 | 275721 | FIX: Corruption of tempdb caused during playback |
58160 | 280808 | FIX: SQL 7.0 SP2 Pull subscriber does not detect that Shiloh Merge Agent Snapshot is obsolete |
58222 | 286257 | FIX: DBCC CHECKTABLE Fails If Corrupt Text Has Long Clustered Key |
58334 | 277738 | FIX: Parallel Select with Aggregate returns Incorrect results |
OLAP Services Fixlist
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.
Bug ID | Link | Title |
---|---|---|
3825, 11211 | 248829 | FIX: Denial of Services During Connections |
7454 | 275049 | FIX: Edit of Calculated Member Returns an Error Message if Parent Dimension is a Multiple Hierarchy |
7709 | 259677 | FIX: OLAP Server May Not Use Aggregations Even When They Exist |
8300 | 274701 | FIX: After Upgrade to OLAP SP2 Reconnection to Server May Cause "Cannot save object in DSO" Error Message |
8888 | 263619 | FIX: Archive/Restore Fails After You Apply SP2 Add-in with SQL Server Repository |
9010 | 263155 | FIX: Processing All Dimensions May Fail From OLAP Manager or DTS Package |
9820 | 271760 | FIX: Incorrect Aggregates After "Incremental Update" of Cube from DTS |
9065 | 274732 | FIX: Permissions on the Temp Folder Change After You Use the Archive/Restore Add-In |
11193 | 275135 | FIX: StrToSet Function Returns Error Message when String is Over 1 K in Size |
11211 | 248829 | FIX: Denial of Services During Connections |
11214 | 275919 | FIX: OLAP Manager Stops Responding When You Edit Partitions |
11240 | 274843 | FIX: OLAP Manager Performs Incremental Update on Private Dimensions when Full Process for Cube is Performed |
11260 | 275050 | FIX: OLAP Databases Missing in OLAP Manager with Migrated Repository Database |
11261 | 272006 | FIX: Cubes and Databases No Longer Visible from OLAP Manager |
11276 | 275924 | FIX: OLAP Manager May Stop Responding When You Migrate Repository |
11287 | 275867 | FIX: OLAP Manager May Return Error After You Install MDAC 2.6 |
11303 | 276608 | FIX: Errors When You Add Aggregations to an Existing Partition |
External Fixlist
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).
Products | Link | Title |
---|---|---|
Access and Visual Studio | 266277 | PRB: Using the Visual Studio 6.0 and Access 2000 Visual Database Tools with SQL Server 2000 |
Microsoft Data Access Components | 279401 | PRB: Over Localized Sort Order Strings In Access/Jet ODBC Driver |
Didn't see an answer to your question? Visit the Microsoft SQL Server Newsgroups at: Microsoft SQL Server Newsgroups
Comments about this or other Microsoft SQL Server Knowledge Base articles? Drop us a note at SQLKB
Additional query words: SP3
Keywords: kbinfo KB274797