Microsoft KB Archive/274797

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 08:46, 21 July 2020 by X010 (talk | contribs) (Text replacement - ">" to ">")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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