DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 254369 - Last Review: February 28, 2014 - Revision: 4.5

This article was previously published under Q254369
This article has been archived. It is offered "as is" and will no longer be updated.

On This Page

SUMMARY

The following is a list of fixes and various other improvements that have been made in Service Pack 2 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 is currently running, execute the following statement from a Query Analyzer window:
SELECT @@version
				
The result of the query is 7.00.623 if you are running SQL Server 7.0 with no service pack applied, 7.00.699 for SQL Server 7.0 Service Pack 1, and 7.00.842 for SQL Server 7.0 Service Pack 2.

Please note that the workarounds described in these articles have been provided for your information only. It is not necessary to implement these workarounds if you have the updated software.

For more information about each corrected problem in Service Pack 2 for Microsoft SQL Server 7.0 (build 7.00.842) 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 by Service Pack 1 are also corrected by Service Pack 2. For a list of those problems, refer to the following article in the Microsoft Knowledge Base:
225019  (http://support.microsoft.com/kb/225019/EN-US/ ) INF: SQL Server 7.0 Service Pack 1 Fixlist
To download Service Pack 2, see the following article in the Microsoft Knowledge Base:
254561  (http://support.microsoft.com/kb/254561/EN-US/ ) INF: How to Obtain Service Pack 2 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0
To view the Readme.txt file that accompanies Service Pack 2, see the following article in the Microsoft Knowledge Base:
254555  (http://support.microsoft.com/kb/254555/EN-US/ ) INF: Readme.txt for SQL Server 7.0 Service Pack 2

MORE INFORMATION

SQL Server and MSDE FixList

Collapse this tableExpand this table
Bug IDLinkTitle
36489243027  (http://support.microsoft.com/kb/243027/EN-US/ ) FIX: Numeric Column in Oracle Causes Error 7354
47131243027  (http://support.microsoft.com/kb/243027/EN-US/ ) FIX: Numeric Column in Oracle Causes Error 7354
47769246498  (http://support.microsoft.com/kb/246498/EN-US/ ) FIX: SP1 Query Analyzer Reports Illegal Operation and Exits on Windows 9x
53778248745  (http://support.microsoft.com/kb/248745/EN-US/ ) FIX: DB-Library Cursors on Stored Procedures May not be Created
53836200795  (http://support.microsoft.com/kb/200795/EN-US/ ) FIX: DBCC CHECKCATALOG May Incorrectly Report Error 2513
53838246598  (http://support.microsoft.com/kb/246598/EN-US/ ) FIX: Columns Listed Multiple Times in GROUP BY WITH CUBE Clause Cause Access Violation
53910 248749  (http://support.microsoft.com/kb/248749/EN-US/ ) FIX: Possible Denial of Service Attack with Appropriate NULL Bytes in TDS Header
53943214818  (http://support.microsoft.com/kb/214818/EN-US/ ) FIX: UPDATE of Table Column with a FOREIGN KEY Constraint May Fail with Msg 8623
54077225705  (http://support.microsoft.com/kb/225705/EN-US/ ) FIX: BCP Import with Extended Character as a Column Delimiter Fails
54083238091  (http://support.microsoft.com/kb/238091/EN-US/ ) FIX: Creating New TCP/IP Advanced Entry Deletes Existing Advanced Entries
54274234174  (http://support.microsoft.com/kb/234174/EN-US/ ) FIX: Db_owner Role Members Cannot Use sp_[un]bindrule and sp_[un]bindefault
54421247181  (http://support.microsoft.com/kb/247181/EN-US/ ) FIX: SQLMaint.exe -CkDBRepair Option Does Not Work Correctly
54532294445  (http://support.microsoft.com/kb/294445/EN-US/ ) FIX: Error Message 2731 Occurs When You Create a Table with a Column Length of Zero
54578232926  (http://support.microsoft.com/kb/232926/EN-US/ ) FIX: Complex Query Containing Redundant Logic May Cause Access Violation
54663247870  (http://support.microsoft.com/kb/247870/EN-US/ ) FIX: Logreader Fails when Using XCALL Syntax with Text or Image Column
54703252865  (http://support.microsoft.com/kb/252865/EN-US/ ) FIX: Replay of Prepared Cursor Statements May Generate Error 16902
54707226109  (http://support.microsoft.com/kb/226109/EN-US/ ) FIX: SQLServerAgent May Shut Down If SQL Server Is Started from the Console
54745226122  (http://support.microsoft.com/kb/226122/EN-US/ ) FIX: Conn Using MP Netlib with Low Memory can Fail with AV
54796247312  (http://support.microsoft.com/kb/247312/EN-US/ ) FIX: SQLDMO: Changing Length of a Column Within a DoAlter Does Not Work
54812247107  (http://support.microsoft.com/kb/247107/EN-US/ ) FIX: Generating Scripts to Multiple Files May Yield Error 20524
54818252948  (http://support.microsoft.com/kb/252948/EN-US/ ) FIX: SQLRowCount Returns -1 After Insertion of a BLOB >= 400K
54907247108  (http://support.microsoft.com/kb/247108/EN-US/ ) FIX: Test Button Fails if DTS Transform Has No Destination Columns
54939247974  (http://support.microsoft.com/kb/247974/EN-US/ ) FIX: Perfmon Errors Logged in Event Log when SQL Server Not Running
54956254905  (http://support.microsoft.com/kb/254905/EN-US/ ) FIX: xp_trace_setqueryhistory not Flushed by Access Violation
54978225501  (http://support.microsoft.com/kb/225501/EN-US/ ) FIX: SQL-DMO Operations on SQL Server 7.0 Uses More Memory
54992246775  (http://support.microsoft.com/kb/246775/EN-US/ ) FIX: Error 7102 with Keyset-Driven Cursors on Table with Text Column
54999246565  (http://support.microsoft.com/kb/246565/EN-US/ ) FIX: Non-Compute Query Before Compute Query Causes OSQL to Stop
55007245406  (http://support.microsoft.com/kb/245406/EN-US/ ) FIX: Nonclustered Index Not Chosen with Varchar and LIKE Clause
55009248307  (http://support.microsoft.com/kb/248307/EN-US/ ) FIX: Arithmetic Overflow in sp_checkdbtempsize and sp_checktable
55013226154  (http://support.microsoft.com/kb/226154/EN-US/ ) FIX: Async Keyset Cursors and Memory Pressure May Cause AV and Server Shutdown
55014224998  (http://support.microsoft.com/kb/224998/EN-US/ ) FIX: Incorrect Locking with a Dynamic Cursor FETCH LAST Operation and a Serializable Transaction
55031225141  (http://support.microsoft.com/kb/225141/EN-US/ ) FIX: SELECT Statements With UNION May Cause Error 8618
55032225093  (http://support.microsoft.com/kb/225093/EN-US/ ) FIX: Poor Performance with Inner Join with Multiple LIKE Clauses Using Variables
55150225501  (http://support.microsoft.com/kb/225501/EN-US/ ) FIX: SQL-DMO Operations on SQL Server 7.0 Uses More Memory
55241245795  (http://support.microsoft.com/kb/245795/EN-US/ ) FIX: Objects Created and Stored in DTS Global Variables Released Prematurely
55278229075  (http://support.microsoft.com/kb/229075/EN-US/ ) FIX: Transfer Objects Fails if SP Preceded by Multi-line Comment
55297230268  (http://support.microsoft.com/kb/230268/EN-US/ ) FIX: ANSI Join with DATEDIFF in the SELECT May Return Error 8624
55303246824  (http://support.microsoft.com/kb/246824/EN-US/ ) FIX: Memory Leak May Occur When Calling Bulk Insert From a Stored Procedure
55322248988  (http://support.microsoft.com/kb/248988/EN-US/ ) FIX: RESTORE Fails When Fewer Devices Used on RESTORE than BACKUP
55330234814  (http://support.microsoft.com/kb/234814/EN-US/ ) FIX: Merge Agent Fails During Synchronization of Rollup Subscriber
55363247052  (http://support.microsoft.com/kb/247052/EN-US/ ) FIX: DTS Package Creator/Owner Name Does Not Change When Another User Saves a New Package
55366234883  (http://support.microsoft.com/kb/234883/EN-US/ ) FIX: Wrong Index Chosen When Query References Values Beyond Statistics
55374248135  (http://support.microsoft.com/kb/248135/EN-US/ ) FIX: Merge Snapshot Fails with "Line 1: Incorrect syntax near '[Object Name>]'."
55383246646  (http://support.microsoft.com/kb/246646/EN-US/ ) FIX: SQL Server Has Fatal Exception When Attempting to Shrink Database
55405247134  (http://support.microsoft.com/kb/247134/EN-US/ ) FIX: Many ISNULLs Within an Expression May Cause Access Violation
55491246028  (http://support.microsoft.com/kb/246028/EN-US/ ) FIX: "Out of Memory" Error with Bulk Insert
55507247307  (http://support.microsoft.com/kb/247307/EN-US/ ) FIX: SQLDMO: DBFile.Shrink and LogFile.Shrink with SQLDMOShrink_EmptyFile Generates Invalid DBCC Command
55515239133  (http://support.microsoft.com/kb/239133/EN-US/ ) FIX: Errors Running Wizards Against Objects not Owned by DBO
55537255633  (http://support.microsoft.com/kb/255633/EN-US/ ) FIX: SET ROWCOUNT or TOP With Partitioned View May Cause Poor Performance
55554234174  (http://support.microsoft.com/kb/234174/EN-US/ ) FIX: Db_owner Role Members Cannot Use sp_[un]bindrule and sp_[un]bindefault
55589255643  (http://support.microsoft.com/kb/255643/EN-US/ ) FIX: Incorrect Costing Causes Other Joins to be Favored Over Loop Join
55597247500  (http://support.microsoft.com/kb/247500/EN-US/ ) FIX: Parallel Sort May Be Slower Than Non-Parallel Sort
55618217019  (http://support.microsoft.com/kb/217019/EN-US/ ) FIX: RAISERROR Does Not Work with SQLOLEDB Provider
55626246177  (http://support.microsoft.com/kb/246177/EN-US/ ) FIX: Optimizer Chooses Table Scan Instead of Index Seek for Simple SELECT Involving @@identity
55630235060  (http://support.microsoft.com/kb/235060/EN-US/ ) FIX: Distributed Query Predicate not Remoted when IDBSchemaRowset not Supported
55635243504  (http://support.microsoft.com/kb/243504/EN-US/ ) FIX: Replication Snapshot Agent May Fail with Access Violation Error When A Long Filter Clause is Used
55636236868  (http://support.microsoft.com/kb/236868/EN-US/ ) FIX: DMO Transfer Methods Does Not Perform Code Page Conversion
55638241717  (http://support.microsoft.com/kb/241717/EN-US/ ) FIX: Update Statement Conflicts with Foreign Key Constraint
55656247019  (http://support.microsoft.com/kb/247019/EN-US/ ) FIX: Access Violation When Adding CHECK Constraint w/ ESCAPE Keyword
55660238523  (http://support.microsoft.com/kb/238523/EN-US/ ) FIX: DTS "Execute SQL Task" Terminates Prematurely Without Completing All Commands in Batch
55690246702  (http://support.microsoft.com/kb/246702/EN-US/ ) FIX: Regression: Specific Inner Join Slower with Service Pack 1 Applied
55704234031  (http://support.microsoft.com/kb/234031/EN-US/ ) FIX: Existing Connection Combo Box in DTS UI Displays Incorrect Connections
55725236439  (http://support.microsoft.com/kb/236439/EN-US/ ) FIX: Memory Leak with DB-Library Connection Using TCP/IP or IPX/SPX
55726235502  (http://support.microsoft.com/kb/235502/EN-US/ ) FIX: Disproportional Data File Filling
55738238356  (http://support.microsoft.com/kb/238356/EN-US/ ) FIX: Use of 25 Different Tables in a Query May Raise Error 1203
55748234256  (http://support.microsoft.com/kb/234256/EN-US/ ) FIX: sp_addtype Does Not Allow Owner Qualified Object Names
55770234268  (http://support.microsoft.com/kb/234268/EN-US/ ) FIX: SQLDMO - .Login and .Password Properties are Ignored with .LoginSecure = FALSE
55787239883  (http://support.microsoft.com/kb/239883/EN-US/ ) FIX: SYBASE CT-Library Clients Cannot Connect to Microsoft SQL Server 7.0
55798238355  (http://support.microsoft.com/kb/238355/EN-US/ ) FIX: SQLOLEDB Resends Prepared Commands with Client Cursors
55799234938  (http://support.microsoft.com/kb/234938/EN-US/ ) FIX: SEM connection slow if server registered with trusted conne
55817248798  (http://support.microsoft.com/kb/248798/EN-US/ ) FIX: Restore Filegroup Allowed after Truncating the Transaction Log
55839234861  (http://support.microsoft.com/kb/234861/EN-US/ ) FIX: SEM May AV When Changing the Size of a Pane in Design View
55840236440  (http://support.microsoft.com/kb/236440/EN-US/ ) FIX: sp_OAGetProperty Fails on Properties From Inherited Interface
55858229480  (http://support.microsoft.com/kb/229480/EN-US/ ) FIX: Disabled Importing File in DTS Import CMD Dialog Box
55863235060  (http://support.microsoft.com/kb/235060/EN-US/ ) FIX: Distributed Query Predicate not Remoted when IDBSchemaRowset not Supported
55868235007  (http://support.microsoft.com/kb/235007/EN-US/ ) FIX: Modifying SQL 6.5 Logreader on SQL 7.0 Distributor Fails with Error "The required parameter '-PublisherDB' is missing."
55904235281  (http://support.microsoft.com/kb/235281/EN-US/ ) FIX: Negative 0 (zero) Causes ODBC SQL Server Driver Error
55906235401  (http://support.microsoft.com/kb/235401/EN-US/ ) FIX: 8623 Error with INSERT-SELECT when Nullable Clustered Keys not Referenced
55907246564  (http://support.microsoft.com/kb/246564/EN-US/ ) FIX: SQL Enterprise Manager AVs on Copy of Large SQL Script from Preview
55909246607  (http://support.microsoft.com/kb/246607/EN-US/ ) FIX: ODS Function Srv_describe May Fail on Certain Type Conversions
55911237793  (http://support.microsoft.com/kb/237793/EN-US/ ) FIX: Using Wildcard Operator '%' with LIKE May Produce Inconsistent Row Patterns
55934247056  (http://support.microsoft.com/kb/247056/EN-US/ ) FIX: Error 8630 When Querying A View Created with a UNION Clause
55938248604  (http://support.microsoft.com/kb/248604/EN-US/ ) FIX: SELECT with Subquery Containing BETWEEN Clause is Slow When Starting Range is the Minimum Value
55964239883  (http://support.microsoft.com/kb/239883/EN-US/ ) FIX: SYBASE CT-Library Clients Cannot Connect to Microsoft SQL Server 7.0
56005241658  (http://support.microsoft.com/kb/241658/EN-US/ ) FIX: REPL: "Too Many Arguments Were Supplied" Error When Inserting a Row
56007248062  (http://support.microsoft.com/kb/248062/EN-US/ ) FIX: Distributed Query with Oracle Cannot Work with Table Exported by DTS
56011236068  (http://support.microsoft.com/kb/236068/EN-US/ ) FIX: Null Parameter for DTS Lookup Causes MMC to Exit
56013236955  (http://support.microsoft.com/kb/236955/EN-US/ ) FIX: Lock Conversion Processing Does Not Properly Wakeup Lock Waiter
56034246191  (http://support.microsoft.com/kb/246191/EN-US/ ) FIX: INSERT SELECT with a HAVING Clause and SUBSELECT Causes AV
56052243502  (http://support.microsoft.com/kb/243502/EN-US/ ) FIX: Phantom Inserts with SELECT...ORDER BY DESC
56055236424  (http://support.microsoft.com/kb/236424/EN-US/ ) FIX: Stack Overflow Running CHECKDB Against DB With Many Objects
56059238547  (http://support.microsoft.com/kb/238547/EN-US/ ) FIX: Update on View-based Cursor Fails to Modify Row if View Contains a Join
56064239015  (http://support.microsoft.com/kb/239015/EN-US/ ) FIX: Non-convergence Problem with Merge Replication
56068239766  (http://support.microsoft.com/kb/239766/EN-US/ ) FIX: DTC Transaction IDs and Isolation Levels Not Captured
56069244549  (http://support.microsoft.com/kb/244549/EN-US/ ) FIX: SELECT Query Involving Bit Datatype Slower on SQL 7.0 than SQL 6.5
56070248688  (http://support.microsoft.com/kb/248688/EN-US/ ) FIX: Keyset, Dynamic and Forward Only Cursor Queries May not Get Auto-Parameterized
56082FIX: Full-Text Search Support for TOP via CONTAINSTABLE and FREETEXTTABLE Clauses
56084239766  (http://support.microsoft.com/kb/239766/EN-US/ ) FIX: DTC Transaction IDs and Isolation Levels Not Captured
56085244548  (http://support.microsoft.com/kb/244548/EN-US/ ) FIX: SQL 7.0 Slower than SQL 6.5 on Multiple Left Outer Join
56102239475  (http://support.microsoft.com/kb/239475/EN-US/ ) FIX: sp_execute Results in Handled AV After Error 2627
56117249119  (http://support.microsoft.com/kb/249119/EN-US/ ) FIX: SQL Server May Stop Without Any Information by BULK INSERT
56121248156  (http://support.microsoft.com/kb/248156/EN-US/ ) FIX: Incorrect Error Trace Information for Query Interface Failure
56124251077  (http://support.microsoft.com/kb/251077/EN-US/ ) FIX: SEM Slow Opening the Database Properties Dialog Box
56128238206  (http://support.microsoft.com/kb/238206/EN-US/ ) FIX: Password Dangling and Decrypted When Changing Security Mode For Replication
56131237703  (http://support.microsoft.com/kb/237703/EN-US/ ) FIX: Permissions Not Changed Correctly Using SQL Enterprise Manager
56147239133  (http://support.microsoft.com/kb/239133/EN-US/ ) FIX: Errors Running Wizards Against Objects not Owned by DBO
56148238455  (http://support.microsoft.com/kb/238455/EN-US/ ) FIX: BCP IN with 4GB or Larger File Fails with Unexpected EOF
56161246588  (http://support.microsoft.com/kb/246588/EN-US/ ) FIX: DBO not Able to Alter Database Using Enterprise Manager
56166245662  (http://support.microsoft.com/kb/245662/EN-US/ ) FIX: Access Violation When Using Generate SQL Scripts Option in SQL Server Enterprise Manager
56167238238  (http://support.microsoft.com/kb/238238/EN-US/ ) FIX: ODS API srv_revert_to_self Does Not Revert Multi-Protocol Connections
56173248442  (http://support.microsoft.com/kb/248442/EN-US/ ) FIX: Error 515 with Concatenated NULLs in WHERE Clause and ORDER BY
56174246323  (http://support.microsoft.com/kb/246323/EN-US/ ) FIX: Check Constraint Is Not Enforced if Marked "Not for Replication"
56208238658  (http://support.microsoft.com/kb/238658/EN-US/ ) FIX: Distribution Agent Fails with 'Incorrect Syntax' for Updating Subscribers
56218238637  (http://support.microsoft.com/kb/238637/EN-US/ ) FIX: Update on View Based Cursor to Multiple Rows in Fetch Buffer Fails with 1203 Msg.
56222243302  (http://support.microsoft.com/kb/243302/EN-US/ ) FIX: Deletion May Inappropriately Fill the Transaction Log
56233240798  (http://support.microsoft.com/kb/240798/EN-US/ ) FIX: Insert from Linked-Server Into Table with BIT Field Having a DEFAULT Constraint Causes AV
56239247208  (http://support.microsoft.com/kb/247208/EN-US/ ) FIX: Custom SP Resovler Does Not Log Merge Conflict Correctly
56275252372  (http://support.microsoft.com/kb/252372/EN-US/ ) FIX: Join Filters with Dynamic Filters May Lead to Non-convergence Problem
56282247313  (http://support.microsoft.com/kb/247313/EN-US/ ) FIX: SEM 7.0 Login Failed Message When Editing or Running DTS Package
56339240194  (http://support.microsoft.com/kb/240194/EN-US/ ) FIX: Conflict Viewer Shows Incorrect Format for Datetime Column
56340240192  (http://support.microsoft.com/kb/240192/EN-US/ ) FIX: Unresolved Merge Conflicts With Constraints And Triggers
56355247891  (http://support.microsoft.com/kb/247891/EN-US/ ) FIX: Event Log and DTS Error File does not Show DTS Error Detail
56362251229  (http://support.microsoft.com/kb/251229/EN-US/ ) FIX: GetExecutionErrorInfo and OnError Event May Not Return All Errors
56363251229  (http://support.microsoft.com/kb/251229/EN-US/ ) FIX: GetExecutionErrorInfo and OnError Event May Not Return All Errors
56367246229  (http://support.microsoft.com/kb/246229/EN-US/ ) FIX: Access Violation in kill_proc During Per Server Licensing Cleanup May Cause Server Hang
56375245631  (http://support.microsoft.com/kb/245631/EN-US/ ) FIX: Error Message "8624 - Internal SQL Server Error"
56394244273  (http://support.microsoft.com/kb/244273/EN-US/ ) FIX: Changing the Number of Columns in a DTS File Connection May Cause Error
56396254806  (http://support.microsoft.com/kb/254806/EN-US/ ) FIX: QUERY Statement Causes 512 Error When You Access a View
56397246226  (http://support.microsoft.com/kb/246226/EN-US/ ) FIX: Heap Memory Corruption and AV in kill_proc May Occur when Using Per Server Licensing
56413242047  (http://support.microsoft.com/kb/242047/EN-US/ ) FIX: Using Srv_paramsetoutput to Set an Output Parameter to NULL Fails
56423244446  (http://support.microsoft.com/kb/244446/EN-US/ ) FIX: SQL 7.0 Slower than SQL 6.5 on UNIONed Left Outer Join and View
56433252375  (http://support.microsoft.com/kb/252375/EN-US/ ) FIX: Pull Subscribers Unsynchronized if Reinitialized from Subscriber Causing Distribution Failures
56435248420  (http://support.microsoft.com/kb/248420/EN-US/ ) FIX: DTS Designer Fails with Unspecified Error When Adding Table to DTS Query Designer Window
56457246189  (http://support.microsoft.com/kb/246189/EN-US/ ) FIX: Execution of IS_MEMBER May Cause AV When Many Roles Exist
56460241678  (http://support.microsoft.com/kb/241678/EN-US/ ) FIX: Replication Merge JOIN Filters May not be Completely Evaluated when a Filtered Table is Modified
56481243292  (http://support.microsoft.com/kb/243292/EN-US/ ) FIX: Creating a Table in Enterprise Manager When Using a Domain Account May Cause Server AV
56495246893  (http://support.microsoft.com/kb/246893/EN-US/ ) FIX: Subquery in IN Clause with DISTINCT and JOINs May Cause Access Violation
56506243302  (http://support.microsoft.com/kb/243302/EN-US/ ) FIX: Deletion May Inappropriately Fill the Transaction Log
56510246571  (http://support.microsoft.com/kb/246571/EN-US/ ) FIX: Access Violation When Loading 5 MB SQL File in Execute SQL Task on Win 9x
56516243211  (http://support.microsoft.com/kb/243211/EN-US/ ) FIX: Poor Performance with In Clause Using Multiple Correlated Subqueries Unioned Together
56519246201  (http://support.microsoft.com/kb/246201/EN-US/ ) FIX: Subquery with ORDER BY may Return Results in Wrong Order
56522243377  (http://support.microsoft.com/kb/243377/EN-US/ ) FIX: Merge System Tables not Dropped When Restoring Merge-Published DB Over Non-published DB Across Servers
56535245833  (http://support.microsoft.com/kb/245833/EN-US/ ) FIX: Immediate Updating Subscriber May Fail If a Text Column Comes Before Primary Key
56536246139  (http://support.microsoft.com/kb/246139/EN-US/ ) FIX: BCP Into a TEXT Column May Cause SQL Server to Stop Executing
56539244934  (http://support.microsoft.com/kb/244934/EN-US/ ) FIX: Killing Running Query May Result in a SPID in Constant ROLLBACK State and AV
56540244962  (http://support.microsoft.com/kb/244962/EN-US/ ) FIX: Calling a Stored Procedure with Text/Image Parameters using ADO May Cause an Access Violation
56542244538  (http://support.microsoft.com/kb/244538/EN-US/ ) FIX: Upgrade Wizard Fails with "Backup 6.x Devices - phase II" Error if Using Tape
56552247125  (http://support.microsoft.com/kb/247125/EN-US/ ) FIX: Optimizer May Choose Inefficient Query Plan When Using NOT LIKE with an Empty String
56580247191  (http://support.microsoft.com/kb/247191/EN-US/ ) FIX: SQL Server 7.0 Slower than SQL Server 6.5 on Join with View Containing CASE and Subquery
56582247492  (http://support.microsoft.com/kb/247492/EN-US/ ) FIX: Primary Key Can Be Dropped if Table is Published
56599243741  (http://support.microsoft.com/kb/243741/EN-US/ ) FIX: Replication Initialize Method Causes Handle Leak on Failure
56633243664  (http://support.microsoft.com/kb/243664/EN-US/ ) FIX: Secondary SPIDs Enlisted in DTC Transaction do not Obtain DTC Isolation Level
56658246031  (http://support.microsoft.com/kb/246031/EN-US/ ) FIX: Queries Using Linked Servers May Cause AV and CPU Spin
56660244943  (http://support.microsoft.com/kb/244943/EN-US/ ) FIX: Security Information Not Persistent for the Connection Object in a DTS Package
56672246815  (http://support.microsoft.com/kb/246815/EN-US/ ) FIX: Sqlmaint.exe is Not Included in MSDE Installation
56738246678  (http://support.microsoft.com/kb/246678/EN-US/ ) FIX: Creating a New Database User from Enterprise Manager May Fail with Error 16916
56745246646  (http://support.microsoft.com/kb/246646/EN-US/ ) FIX: Fatal Exception When Attempting to Shrink Database
56746246646  (http://support.microsoft.com/kb/246646/EN-US/ ) FIX: Fatal Exception When Attempting to Shrink Database
56747248624  (http://support.microsoft.com/kb/248624/EN-US/ ) FIX: Creating Publication Fails if Table Has Long Column Name
56751248492  (http://support.microsoft.com/kb/248492/EN-US/ ) FIX: SQL Server Does Not Properly Inform the DTC of Aborted Transactions
56762247673  (http://support.microsoft.com/kb/247673/EN-US/ ) FIX: Data Column Host Process ID does not Show PID of Process Being Traced in Profiler
56775246474  (http://support.microsoft.com/kb/246474/EN-US/ ) FIX: Optimizer Chooses Inefficient Clustered Index on Query with Date Range Condition
56821252905  (http://support.microsoft.com/kb/252905/EN-US/ ) FIX: Slow Compile Time on Complex Joins with Unfiltered Table
56830248623  (http://support.microsoft.com/kb/248623/EN-US/ ) FIX: No Mechanism for Cleaning Up Merge System Tables
56866246612  (http://support.microsoft.com/kb/246612/EN-US/ ) FIX: Malformed RPC TDS Packet Causes Various AVs
56868247235  (http://support.microsoft.com/kb/247235/EN-US/ ) FIX: Sp_Change_Users_Login with Auto_Fix Fails When Run with Local Cursor Database Option Set
56969258226  (http://support.microsoft.com/kb/258226/EN-US/ ) FIX: DBCS Space Is Not Treated Correctly
57007251094  (http://support.microsoft.com/kb/251094/EN-US/ ) FIX: Sampling Inconsistency Results in Access Violation or Slow-Running Queries
57097250994  (http://support.microsoft.com/kb/250994/EN-US/ ) FIX: Update Generation Markers After Applying the MSmerge_genhistory.bcp
57098248434  (http://support.microsoft.com/kb/248434/EN-US/ ) FIX: Non-Conflicting Column Updates May Cause Erroneous Metadata Mismatch Conflicts
57166251190  (http://support.microsoft.com/kb/251190/EN-US/ ) FIX: Performance Impact of Remote SPs Not Returning Result Sets
57173262446  (http://support.microsoft.com/kb/262446/EN-US/ ) FIX: Error Message "Permission Denied" When You Update A View
57204250345  (http://support.microsoft.com/kb/250345/EN-US/ ) FIX: Prefetching of Rows by Bookmark Lookup May Not Release Locks in Read Committed Isolation
57428260254  (http://support.microsoft.com/kb/260254/EN-US/ ) FIX: Rollback of Transactions Named as Empty String Cause Access Violations
57634256052  (http://support.microsoft.com/kb/256052/EN-US/ ) FIX: Sqlservr.exe Non-Trusted Connection Through OPENROWSET Allows Access to Service Account
57854259956  (http://support.microsoft.com/kb/259956/EN-US/ ) FIX: Text Field Data Truncated When Double Byte Character Spans Page Break

OLAP Services Fixlist

Collapse this tableExpand this table
Bug IDLinkTitle
629241356  (http://support.microsoft.com/kb/241356/EN-US/ ) FIX: FIX: "Invalid Pointer" Error When Creating Calculated Member in a Local Cube
1325249158  (http://support.microsoft.com/kb/249158/EN-US/ ) FIX: Foodmart Directory Created in Root Folder of Install Drive
1356248615  (http://support.microsoft.com/kb/248615/EN-US/ ) FIX: Dimension Wizard Calculates Years Incorrectly On Time Dimen
1378248619  (http://support.microsoft.com/kb/248619/EN-US/ ) FIX: Dimension Wizard Does Not Allow Creating Time Dimension Hie
1496253496  (http://support.microsoft.com/kb/253496/EN-US/ ) FIX: Processing OLAP Partitions in Parallel May Result in Errors
1505249210  (http://support.microsoft.com/kb/249210/EN-US/ ) FIX: Cancellation DTS OLAP Processing Task May Result in Error
1539234660  (http://support.microsoft.com/kb/234660/EN-US/ ) FIX: OLAP: "Object Does not exist" Error Processing Multi-Hierarchy Dimension
1544236315  (http://support.microsoft.com/kb/236315/EN-US/ ) FIX: Users Cannot Access OLAP Cube from Clients After Installing SP1
2026236315  (http://support.microsoft.com/kb/236315/EN-US/ ) FIX: Users Cannot Access OLAP Cube from Clients After Installing SP1
2340239889  (http://support.microsoft.com/kb/239889/EN-US/ ) FIX: VBDSOWriteEnableCube: Debug Assertion Caused by a Data Type Not Addressed in the Sample Code
2361248836  (http://support.microsoft.com/kb/248836/EN-US/ ) FIX: Incremental Update of Dimension Tables May Cause 206 Error
3644249698  (http://support.microsoft.com/kb/249698/EN-US/ ) FIX: OLAP Addins: Archive Fails With more than 2GB of data
3698243093  (http://support.microsoft.com/kb/243093/EN-US/ ) FIX: Using an IP Address for OLAP Data Source Connection Property Causes Error
3792256129  (http://support.microsoft.com/kb/256129/EN-US/ ) FIX: OLAP Server Out of Memory Error Occurs When You Perform Incremental Processing of Dimensions
3809244263  (http://support.microsoft.com/kb/244263/EN-US/ ) INF: How Sorting Works in OLAP Services
3823243545  (http://support.microsoft.com/kb/243545/EN-US/ ) FIX: Incorrect Error Messages from DTS Addin While Processing Cube/Dimension
4413246015  (http://support.microsoft.com/kb/246015/EN-US/ ) FIX: DTS OLAP Processing Task Fails if Package Stored in Repository
4472241088  (http://support.microsoft.com/kb/241088/EN-US/ ) FIX: Registry Permission Difference When You Install OLAP Services on Windows 2000
4483248612  (http://support.microsoft.com/kb/248612/EN-US/ ) FIX: Date Fields Display Incorrectly When Time Dimension is Based on Fact Table
4524255087  (http://support.microsoft.com/kb/255087/EN-US/ ) FIX: No Error When You Open OLAP Manager If User Account
4525241088  (http://support.microsoft.com/kb/241088/EN-US/ ) FIX: Registry Permission Difference When You Install OLAP Services on Windows 2000
4546255135  (http://support.microsoft.com/kb/255135/EN-US/ ) FIX: Copy/Paste Cubes Fail Without Any Error Messages

APPLIES TO
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server OLAP Services
Keywords: 
kbnosurvey kbarchive kbbug kbfix kbinfo KB254369
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support