Microsoft KB Archive/225019

From BetaArchive Wiki

Article ID: 225019

Article Last Modified on 9/8/2006



APPLIES TO

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



This article was previously published under Q225019

SUMMARY

The following is a list of fixes and various other improvements that have been made in Service Pack 1 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 this query will be 7.00.623 if you are running SQL Server 7.0 with no service pack applied or 7.00.699 for SQL Server 7.0 Service Pack 1.

Please note that 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 1 for Microsoft SQL Server 7.0 (build 7.00.699) and Microsoft Data Engine (MSDE) 1.0, either click on the link or use the Qxxxxxx number to query for the article in the Microsoft Knowledge Base.

To download the service pack, see the following article in the Microsoft Knowledge Base:

232570 INF: How to Obtain Service Pack 1 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0


To view the Readme.txt file that accompanies Service Pack 1, see the following article in the Microsoft Knowledge Base:

232574 INF: Readme.txt for SQL Server 7.0 Service Pack 1


MORE INFORMATION

SQL Server and MSDE FixList

Bug ID Q Number Title
46568 207451 FIX: DTS Query Designer Does Nothing When ENTER Key Is Pressed
51679 236045 FIX: Upgrade Wizard GUI Allows Adding of New File Groups to Model and TempDB Databases
52498 196919 FIX: Desc. Index Scans May Block with High Transaction Isolation
52728 224157 FIX: Internal Error 998 Reported from Profiler
52795 198515 FIX: Address Book in Send Mail Task Adds Only First Address
52858 233202 FIX: Configuration Fails Pasting Distributor Database Name with a Leading Space
52932 198163 FIX: FT Wizard Fails with WinNT Authentication and Not Sysadmin
52979 197800 FIX: Cursor Overhead Higher on SQL 7.0 for Small Result Sets
53018 201857 FIX: BCP Format File Field Length Does Not Behave as Documented
53028 196790 FIX: BULK INSERT w/ BATCHSIZE Disregards LASTROW Parameter
53101 196771 FIX: @@language Value Can Be Truncated After Changing Value
53106 202429 FIX: Error 21761 When Binding Non-DBO Default
53157 203777 FIX: Index Tuning Fails on Unicode Named Tables & Workfiles
53196 198884 FIX: DTS Can't Save a Package to Repository w/ Login > 20 Chars.
53205 224805 FIX: Index Tuning Wizard Recommends that Indexes for System Tables Be Dropped
53311 198514 FIX: Restore to New Server Causes Transactions to Remain in Log
53327 201533 FIX: Enterprise Manager Displays 'SQL Server Standard'
53390 197385 FIX: DTSRun: Package Reports False Success with User Password
53428 233027 FIX: Cannot Properly Add IPX/SPX Address to Server Network Utility
53470 233525 FIX: Mmc.exe Remains in the Task List After Closing the Console Window
53474 198265 FIX: Failed Sp_prepare Incorrectly Closes Transaction
53486 200118 FIX: Adding Database Files During Upgrade May Cause Errors
53507 198521 FIX: SQL Profiler May Cause Divide By Zero Exception
53547 224160 FIX: Create DB Wizard Incorrectly Sets Trans. Log File Growth
53566 221243 FIX: Users Added via WinNT Groups Not Able to View Table List
53568 224539 FIX: Optimizer Does Not Consider Anti Semi Join for NOT IN Query
53590 239773 FIX: Using dbcc Stackdump or CTRL+C + D Causes Fatal Exception on Windows 95 & Windows 98
53592 229007 FIX: SpaceAvailableInMB Property Returns Used Space Instead
53594 233019 FIX: DTSWIZ /? Shows /r as an Option but It Does Not Exist
53658 232522 FIX: Err 16943 When Dropping Pull Subscription w/ 'ALL' Param.
53736 199294 INF: Cursors Remain Open when CURSOR_CLOSE_ON_COMMIT Set OFF
53748 219425 FIX: DTS Wizard New DB Errors When Target Server Is SQL 6.5
53803 228933 FIX: 'Unspecified Error' Message Returns Placing a NULL in a Col
53834 219416 FIX: Duplicate Hash Keys Created for Two Distinct Index Keys
53840 240039 FIX: DBCC OPENTRAN Does Not Report Replication Information
53850 218605 FIX: Progress Indicators Not Shown When Transferring Data w/ DTS
53851 208927 FIX: Transfer Manager Leaves Open Connection in Source DB
53856 199688 FIX: @@IDENTITY Returns NULL If Trigger Inserts into Tbl w/o ID
53857 240036 FIX: Distribution Agent Ignores Error on Pre-Creation Command
53859 257425 FIX: DTS Object Transfer Does Not Transfer BLOB Data Greater Than 64 KB
53861 240035 FIX: Logreader Failure with TEXT/IMAGE Data Inserted Through BCP
53975 224986 FIX: Query Analyzer Truncates COMPUTE Clause Output at Six Chars
53980 224162 FIX: Unhandled Exception During Upgrade When Excluding Database
53984 215457 FIX: Logreader Fails to Replicate Updating Non-NULL Text Fields
53994 224329 FIX: Merge Initial Sync w/ Dynamic Filters Takes Long Time
54013 224996 FIX: Access Violation Selecting Linked Table
54112 244763 FIX: Access Violation Under High Cursor Stress
54138 218967 FIX: "CREATE INDEX" in Form Causes ASC or DESC to be Removed in an ORDER BY Clause
54139 217036 FIX: Logreader Tasks Not Upgraded from SQL Server 6.5 to 7.0
54186 233553 FIX: Non-Clustered Fillfactor Reset When Clustered Index Created
54203 219756 FIX: Connections May Result in Handle Leak If SQLTRACE Enabled
54345 233190 FIX: Access Violation When Using UNIONs in Transact-SQL Cursors
54366 224581 FIX: Large Numbers of AND Conditions May Cause Stack Overflow
54436 219865 FIX: Sqltrace.dll May Cause Heap Corruption w/0-Length RPC Param
54451 225084 FIX: IE 5.0 Hinders SQL 7.0 Wizards and Tabbed Dialogs on Win9x
54536 229003 FIX: Error 21770 When Trying to Manage Permissions for User-Owned Stored Procedures in SEM
54540 221558 FIX: Sp_replcounters with INSERT..EXEC May Cause Server Hang
54689 239717 FIX: SQLDMO - Setting BULKCOPY.SuspendIndexing = True May Fail
54783 228473 FIX: Adding Merge Subscription Fails with Error 8115
54840 223257 FIX: RPC Using SQL_PARAM_OUTPUT and SQL_PARAM_DEFAULT May Cause AV
54985 232244 FIX: Delay Between Responses Not Observed for Perf Condition Alert
55001 244230 FIX: Slow Query Performance Using Correlated Subquery with "Or Exists" Clause
55067 233542 FIX: Concurrent Execution of Keyset Cursors Cause Errors & AV
55087 233491 FIX: Cannot Link OLAP Servers in SQL Server Enterprise Linked Server
55243 230301 FIX: French BOL Table of Contents Missing 4 Topics
55572 234915 FIX: Upgrade to SQL Server Fails When MSDE Installed from MOD

OLAP Services Fixlist

Bug ID Q Number Title
639 234646 FIX: MS Query Hangs Trying to Overwrite an Existing Local Cube File
664 241351 FIX: Problems in Managing OLAP Cube Roles on French Versions
681 234072 FIX: Dimension Wizard: Cannot Browse a Table or a View with a Space in the Table/View Name
1282 233491 FIX: Cannot Link OLAP Servers in SQL Server Enterprise Linked Server
1286 233179 FIX: OLAP: Cannot Upgrade Client Win98 Computer Containing Office 2000
1351 234516 FIX: OLAP:DSO Role Update May Return "Key Already Associated" Error or Cause System Hang



Additional query words: sp sp1 fix list

Keywords: kbinfo kbbug kbfix KB225019