Microsoft KB Archive/254369: Difference between revisions
(importing KB archive) |
(No difference)
|
Revision as of 17:16, 18 July 2020
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