Microsoft KB Archive/254369

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

Article ID: 254369

Article Last Modified on 4/12/2007



APPLIES TO

  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server OLAP Services



This article was previously published under Q254369

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 INF: SQL Server 7.0 Service Pack 1 Fixlist


To download Service Pack 2, see the following article in the Microsoft Knowledge Base:

254561 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 INF: Readme.txt for SQL Server 7.0 Service Pack 2


MORE INFORMATION

SQL Server and MSDE FixList

Bug ID Link Title
36489 243027 FIX: Numeric Column in Oracle Causes Error 7354
47131 243027 FIX: Numeric Column in Oracle Causes Error 7354
47769 246498 FIX: SP1 Query Analyzer Reports Illegal Operation and Exits on Windows 9x
53778 248745 FIX: DB-Library Cursors on Stored Procedures May not be Created
53836 200795 FIX: DBCC CHECKCATALOG May Incorrectly Report Error 2513
53838 246598 FIX: Columns Listed Multiple Times in GROUP BY WITH CUBE Clause Cause Access Violation
53910 248749 FIX: Possible Denial of Service Attack with Appropriate NULL Bytes in TDS Header
53943 214818 FIX: UPDATE of Table Column with a FOREIGN KEY Constraint May Fail with Msg 8623
54077 225705 FIX: BCP Import with Extended Character as a Column Delimiter Fails
54083 238091 FIX: Creating New TCP/IP Advanced Entry Deletes Existing Advanced Entries
54274 234174 FIX: Db_owner Role Members Cannot Use sp_[un]bindrule and sp_[un]bindefault
54421 247181 FIX: SQLMaint.exe -CkDBRepair Option Does Not Work Correctly
54532 294445 FIX: Error Message 2731 Occurs When You Create a Table with a Column Length of Zero
54578 232926 FIX: Complex Query Containing Redundant Logic May Cause Access Violation
54663 247870 FIX: Logreader Fails when Using XCALL Syntax with Text or Image Column
54703 252865 FIX: Replay of Prepared Cursor Statements May Generate Error 16902
54707 226109 FIX: SQLServerAgent May Shut Down If SQL Server Is Started from the Console
54745 226122 FIX: Conn Using MP Netlib with Low Memory can Fail with AV
54796 247312 FIX: SQLDMO: Changing Length of a Column Within a DoAlter Does Not Work
54812 247107 FIX: Generating Scripts to Multiple Files May Yield Error 20524
54818 252948 FIX: SQLRowCount Returns -1 After Insertion of a BLOB >= 400K
54907 247108 FIX: Test Button Fails if DTS Transform Has No Destination Columns
54939 247974 FIX: Perfmon Errors Logged in Event Log when SQL Server Not Running
54956 254905 FIX: xp_trace_setqueryhistory not Flushed by Access Violation
54978 225501 FIX: SQL-DMO Operations on SQL Server 7.0 Uses More Memory
54992 246775 FIX: Error 7102 with Keyset-Driven Cursors on Table with Text Column
54999 246565 FIX: Non-Compute Query Before Compute Query Causes OSQL to Stop
55007 245406 FIX: Nonclustered Index Not Chosen with Varchar and LIKE Clause
55009 248307 FIX: Arithmetic Overflow in sp_checkdbtempsize and sp_checktable
55013 226154 FIX: Async Keyset Cursors and Memory Pressure May Cause AV and Server Shutdown
55014 224998 FIX: Incorrect Locking with a Dynamic Cursor FETCH LAST Operation and a Serializable Transaction
55031 225141 FIX: SELECT Statements With UNION May Cause Error 8618
55032 225093 FIX: Poor Performance with Inner Join with Multiple LIKE Clauses Using Variables
55150 225501 FIX: SQL-DMO Operations on SQL Server 7.0 Uses More Memory
55241 245795 FIX: Objects Created and Stored in DTS Global Variables Released Prematurely
55278 229075 FIX: Transfer Objects Fails if SP Preceded by Multi-line Comment
55297 230268 FIX: ANSI Join with DATEDIFF in the SELECT May Return Error 8624
55303 246824 FIX: Memory Leak May Occur When Calling Bulk Insert From a Stored Procedure
55322 248988 FIX: RESTORE Fails When Fewer Devices Used on RESTORE than BACKUP
55330 234814 FIX: Merge Agent Fails During Synchronization of Rollup Subscriber
55363 247052 FIX: DTS Package Creator/Owner Name Does Not Change When Another User Saves a New Package
55366 234883 FIX: Wrong Index Chosen When Query References Values Beyond Statistics
55374 248135 FIX: Merge Snapshot Fails with "Line 1: Incorrect syntax near '[Object Name>]'."
55383 246646 FIX: SQL Server Has Fatal Exception When Attempting to Shrink Database
55405 247134 FIX: Many ISNULLs Within an Expression May Cause Access Violation
55491 246028 FIX: "Out of Memory" Error with Bulk Insert
55507 247307 FIX: SQLDMO: DBFile.Shrink and LogFile.Shrink with SQLDMOShrink_EmptyFile Generates Invalid DBCC Command
55515 239133 FIX: Errors Running Wizards Against Objects not Owned by DBO
55537 255633 FIX: SET ROWCOUNT or TOP With Partitioned View May Cause Poor Performance
55554 234174 FIX: Db_owner Role Members Cannot Use sp_[un]bindrule and sp_[un]bindefault
55589 255643 FIX: Incorrect Costing Causes Other Joins to be Favored Over Loop Join
55597 247500 FIX: Parallel Sort May Be Slower Than Non-Parallel Sort
55618 217019 FIX: RAISERROR Does Not Work with SQLOLEDB Provider
55626 246177 FIX: Optimizer Chooses Table Scan Instead of Index Seek for Simple SELECT Involving @@identity
55630 235060 FIX: Distributed Query Predicate not Remoted when IDBSchemaRowset not Supported
55635 243504 FIX: Replication Snapshot Agent May Fail with Access Violation Error When A Long Filter Clause is Used
55636 236868 FIX: DMO Transfer Methods Does Not Perform Code Page Conversion
55638 241717 FIX: Update Statement Conflicts with Foreign Key Constraint
55656 247019 FIX: Access Violation When Adding CHECK Constraint w/ ESCAPE Keyword
55660 238523 FIX: DTS "Execute SQL Task" Terminates Prematurely Without Completing All Commands in Batch
55690 246702 FIX: Regression: Specific Inner Join Slower with Service Pack 1 Applied
55704 234031 FIX: Existing Connection Combo Box in DTS UI Displays Incorrect Connections
55725 236439 FIX: Memory Leak with DB-Library Connection Using TCP/IP or IPX/SPX
55726 235502 FIX: Disproportional Data File Filling
55738 238356 FIX: Use of 25 Different Tables in a Query May Raise Error 1203
55748 234256 FIX: sp_addtype Does Not Allow Owner Qualified Object Names
55770 234268 FIX: SQLDMO - .Login and .Password Properties are Ignored with .LoginSecure = FALSE
55787 239883 FIX: SYBASE CT-Library Clients Cannot Connect to Microsoft SQL Server 7.0
55798 238355 FIX: SQLOLEDB Resends Prepared Commands with Client Cursors
55799 234938 FIX: SEM connection slow if server registered with trusted conne
55817 248798 FIX: Restore Filegroup Allowed after Truncating the Transaction Log
55839 234861 FIX: SEM May AV When Changing the Size of a Pane in Design View
55840 236440 FIX: sp_OAGetProperty Fails on Properties From Inherited Interface
55858 229480 FIX: Disabled Importing File in DTS Import CMD Dialog Box
55863 235060 FIX: Distributed Query Predicate not Remoted when IDBSchemaRowset not Supported
55868 235007 FIX: Modifying SQL 6.5 Logreader on SQL 7.0 Distributor Fails with Error "The required parameter '-PublisherDB' is missing."
55904 235281 FIX: Negative 0 (zero) Causes ODBC SQL Server Driver Error
55906 235401 FIX: 8623 Error with INSERT-SELECT when Nullable Clustered Keys not Referenced
55907 246564 FIX: SQL Enterprise Manager AVs on Copy of Large SQL Script from Preview
55909 246607 FIX: ODS Function Srv_describe May Fail on Certain Type Conversions
55911 237793 FIX: Using Wildcard Operator '%' with LIKE May Produce Inconsistent Row Patterns
55934 247056 FIX: Error 8630 When Querying A View Created with a UNION Clause
55938 248604 FIX: SELECT with Subquery Containing BETWEEN Clause is Slow When Starting Range is the Minimum Value
55964 239883 FIX: SYBASE CT-Library Clients Cannot Connect to Microsoft SQL Server 7.0
56005 241658 FIX: REPL: "Too Many Arguments Were Supplied" Error When Inserting a Row
56007 248062 FIX: Distributed Query with Oracle Cannot Work with Table Exported by DTS
56011 236068 FIX: Null Parameter for DTS Lookup Causes MMC to Exit
56013 236955 FIX: Lock Conversion Processing Does Not Properly Wakeup Lock Waiter
56034 246191 FIX: INSERT SELECT with a HAVING Clause and SUBSELECT Causes AV
56052 243502 FIX: Phantom Inserts with SELECT...ORDER BY DESC
56055 236424 FIX: Stack Overflow Running CHECKDB Against DB With Many Objects
56059 238547 FIX: Update on View-based Cursor Fails to Modify Row if View Contains a Join
56064 239015 FIX: Non-convergence Problem with Merge Replication
56068 239766 FIX: DTC Transaction IDs and Isolation Levels Not Captured
56069 244549 FIX: SELECT Query Involving Bit Datatype Slower on SQL 7.0 than SQL 6.5
56070 248688 FIX: Keyset, Dynamic and Forward Only Cursor Queries May not Get Auto-Parameterized
56082 240833 FIX: Full-Text Search Support for TOP via CONTAINSTABLE and FREETEXTTABLE Clauses
56084 239766 FIX: DTC Transaction IDs and Isolation Levels Not Captured
56085 244548 FIX: SQL 7.0 Slower than SQL 6.5 on Multiple Left Outer Join
56102 239475 FIX: sp_execute Results in Handled AV After Error 2627
56117 249119 FIX: SQL Server May Stop Without Any Information by BULK INSERT
56121 248156 FIX: Incorrect Error Trace Information for Query Interface Failure
56124 251077 FIX: SEM Slow Opening the Database Properties Dialog Box
56128 238206 FIX: Password Dangling and Decrypted When Changing Security Mode For Replication
56131 237703 FIX: Permissions Not Changed Correctly Using SQL Enterprise Manager
56147 239133 FIX: Errors Running Wizards Against Objects not Owned by DBO
56148 238455 FIX: BCP IN with 4GB or Larger File Fails with Unexpected EOF
56161 246588 FIX: DBO not Able to Alter Database Using Enterprise Manager
56166 245662 FIX: Access Violation When Using Generate SQL Scripts Option in SQL Server Enterprise Manager
56167 238238 FIX: ODS API srv_revert_to_self Does Not Revert Multi-Protocol Connections
56173 248442 FIX: Error 515 with Concatenated NULLs in WHERE Clause and ORDER BY
56174 246323 FIX: Check Constraint Is Not Enforced if Marked "Not for Replication"
56208 238658 FIX: Distribution Agent Fails with 'Incorrect Syntax' for Updating Subscribers
56218 238637 FIX: Update on View Based Cursor to Multiple Rows in Fetch Buffer Fails with 1203 Msg.
56222 243302 FIX: Deletion May Inappropriately Fill the Transaction Log
56233 240798 FIX: Insert from Linked-Server Into Table with BIT Field Having a DEFAULT Constraint Causes AV
56239 247208 FIX: Custom SP Resovler Does Not Log Merge Conflict Correctly
56275 252372 FIX: Join Filters with Dynamic Filters May Lead to Non-convergence Problem
56282 247313 FIX: SEM 7.0 Login Failed Message When Editing or Running DTS Package
56339 240194 FIX: Conflict Viewer Shows Incorrect Format for Datetime Column
56340 240192 FIX: Unresolved Merge Conflicts With Constraints And Triggers
56355 247891 FIX: Event Log and DTS Error File does not Show DTS Error Detail
56362 251229 FIX: GetExecutionErrorInfo and OnError Event May Not Return All Errors
56363 251229 FIX: GetExecutionErrorInfo and OnError Event May Not Return All Errors
56367 246229 FIX: Access Violation in kill_proc During Per Server Licensing Cleanup May Cause Server Hang
56375 245631 FIX: Error Message "8624 - Internal SQL Server Error"
56394 244273 FIX: Changing the Number of Columns in a DTS File Connection May Cause Error
56396 254806 FIX: QUERY Statement Causes 512 Error When You Access a View
56397 246226 FIX: Heap Memory Corruption and AV in kill_proc May Occur when Using Per Server Licensing
56413 242047 FIX: Using Srv_paramsetoutput to Set an Output Parameter to NULL Fails
56423 244446 FIX: SQL 7.0 Slower than SQL 6.5 on UNIONed Left Outer Join and View
56433 252375 FIX: Pull Subscribers Unsynchronized if Reinitialized from Subscriber Causing Distribution Failures
56435 248420 FIX: DTS Designer Fails with Unspecified Error When Adding Table to DTS Query Designer Window
56457 246189 FIX: Execution of IS_MEMBER May Cause AV When Many Roles Exist
56460 241678 FIX: Replication Merge JOIN Filters May not be Completely Evaluated when a Filtered Table is Modified
56481 243292 FIX: Creating a Table in Enterprise Manager When Using a Domain Account May Cause Server AV
56495 246893 FIX: Subquery in IN Clause with DISTINCT and JOINs May Cause Access Violation
56506 243302 FIX: Deletion May Inappropriately Fill the Transaction Log
56510 246571 FIX: Access Violation When Loading 5 MB SQL File in Execute SQL Task on Win 9x
56516 243211 FIX: Poor Performance with In Clause Using Multiple Correlated Subqueries Unioned Together
56519 246201 FIX: Subquery with ORDER BY may Return Results in Wrong Order
56522 243377 FIX: Merge System Tables not Dropped When Restoring Merge-Published DB Over Non-published DB Across Servers
56535 245833 FIX: Immediate Updating Subscriber May Fail If a Text Column Comes Before Primary Key
56536 246139 FIX: BCP Into a TEXT Column May Cause SQL Server to Stop Executing
56539 244934 FIX: Killing Running Query May Result in a SPID in Constant ROLLBACK State and AV
56540 244962 FIX: Calling a Stored Procedure with Text/Image Parameters using ADO May Cause an Access Violation
56542 244538 FIX: Upgrade Wizard Fails with "Backup 6.x Devices - phase II" Error if Using Tape
56552 247125 FIX: Optimizer May Choose Inefficient Query Plan When Using NOT LIKE with an Empty String
56580 247191 FIX: SQL Server 7.0 Slower than SQL Server 6.5 on Join with View Containing CASE and Subquery
56582 247492 FIX: Primary Key Can Be Dropped if Table is Published
56599 243741 FIX: Replication Initialize Method Causes Handle Leak on Failure
56633 243664 FIX: Secondary SPIDs Enlisted in DTC Transaction do not Obtain DTC Isolation Level
56658 246031 FIX: Queries Using Linked Servers May Cause AV and CPU Spin
56660 244943 FIX: Security Information Not Persistent for the Connection Object in a DTS Package
56672 246815 FIX: Sqlmaint.exe is Not Included in MSDE Installation
56738 246678 FIX: Creating a New Database User from Enterprise Manager May Fail with Error 16916
56745 246646 FIX: Fatal Exception When Attempting to Shrink Database
56746 246646 FIX: Fatal Exception When Attempting to Shrink Database
56747 248624 FIX: Creating Publication Fails if Table Has Long Column Name
56751 248492 FIX: SQL Server Does Not Properly Inform the DTC of Aborted Transactions
56762 247673 FIX: Data Column Host Process ID does not Show PID of Process Being Traced in Profiler
56775 246474 FIX: Optimizer Chooses Inefficient Clustered Index on Query with Date Range Condition
56821 252905 FIX: Slow Compile Time on Complex Joins with Unfiltered Table
56830 248623 FIX: No Mechanism for Cleaning Up Merge System Tables
56866 246612 FIX: Malformed RPC TDS Packet Causes Various AVs
56868 247235 FIX: Sp_Change_Users_Login with Auto_Fix Fails When Run with Local Cursor Database Option Set
56969 258226 FIX: DBCS Space Is Not Treated Correctly
57007 251094 FIX: Sampling Inconsistency Results in Access Violation or Slow-Running Queries
57097 250994 FIX: Update Generation Markers After Applying the MSmerge_genhistory.bcp
57098 248434 FIX: Non-Conflicting Column Updates May Cause Erroneous Metadata Mismatch Conflicts
57166 251190 FIX: Performance Impact of Remote SPs Not Returning Result Sets
57173 262446 FIX: Error Message "Permission Denied" When You Update A View
57204 250345 FIX: Prefetching of Rows by Bookmark Lookup May Not Release Locks in Read Committed Isolation
57428 260254 FIX: Rollback of Transactions Named as Empty String Cause Access Violations
57634 256052 FIX: Sqlservr.exe Non-Trusted Connection Through OPENROWSET Allows Access to Service Account
57854 259956 FIX: Text Field Data Truncated When Double Byte Character Spans Page Break

OLAP Services Fixlist

Bug ID Link Title
629 241356 FIX: FIX: "Invalid Pointer" Error When Creating Calculated Member in a Local Cube
1325 249158 FIX: Foodmart Directory Created in Root Folder of Install Drive
1356 248615 FIX: Dimension Wizard Calculates Years Incorrectly On Time Dimen
1378 248619 FIX: Dimension Wizard Does Not Allow Creating Time Dimension Hie
1496 253496 FIX: Processing OLAP Partitions in Parallel May Result in Errors
1505 249210 FIX: Cancellation DTS OLAP Processing Task May Result in Error
1539 234660 FIX: OLAP: "Object Does not exist" Error Processing Multi-Hierarchy Dimension
1544 236315 FIX: Users Cannot Access OLAP Cube from Clients After Installing SP1
2026 236315 FIX: Users Cannot Access OLAP Cube from Clients After Installing SP1
2340 239889 FIX: VBDSOWriteEnableCube: Debug Assertion Caused by a Data Type Not Addressed in the Sample Code
2361 248836 FIX: Incremental Update of Dimension Tables May Cause 206 Error
3644 249698 FIX: OLAP Addins: Archive Fails With more than 2GB of data
3698 243093 FIX: Using an IP Address for OLAP Data Source Connection Property Causes Error
3792 256129 FIX: OLAP Server Out of Memory Error Occurs When You Perform Incremental Processing of Dimensions
3809 244263 INF: How Sorting Works in OLAP Services
3823 243545 FIX: Incorrect Error Messages from DTS Addin While Processing Cube/Dimension
4413 246015 FIX: DTS OLAP Processing Task Fails if Package Stored in Repository
4472 241088 FIX: Registry Permission Difference When You Install OLAP Services on Windows 2000
4483 248612 FIX: Date Fields Display Incorrectly When Time Dimension is Based on Fact Table
4524 255087 FIX: No Error When You Open OLAP Manager If User Account
4525 241088 FIX: Registry Permission Difference When You Install OLAP Services on Windows 2000
4546 255135 FIX: Copy/Paste Cubes Fail Without Any Error Messages



Additional query words: sp sp2 fix list

Keywords: kbbug kbfix kbinfo KB254369