DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 225019 - Last Review: February 21, 2014 - Revision: 4.4

This article was previously published under Q225019
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 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  (http://support.microsoft.com/kb/232570/EN-US/ ) 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  (http://support.microsoft.com/kb/232574/EN-US/ ) INF: Readme.txt for SQL Server 7.0 Service Pack 1

MORE INFORMATION

SQL Server and MSDE FixList

Collapse this tableExpand this table
Bug IDQ NumberTitle
46568207451  (http://support.microsoft.com/kb/207451/EN-US/ ) FIX: DTS Query Designer Does Nothing When ENTER Key Is Pressed
51679236045  (http://support.microsoft.com/kb/236045/EN-US/ ) FIX: Upgrade Wizard GUI Allows Adding of New File Groups to Model and TempDB Databases
52498196919  (http://support.microsoft.com/kb/196919/EN-US/ ) FIX: Desc. Index Scans May Block with High Transaction Isolation
52728224157  (http://support.microsoft.com/kb/224157/EN-US/ ) FIX: Internal Error 998 Reported from Profiler
52795198515  (http://support.microsoft.com/kb/198515/EN-US/ ) FIX: Address Book in Send Mail Task Adds Only First Address
52858233202  (http://support.microsoft.com/kb/233202/EN-US/ ) FIX: Configuration Fails Pasting Distributor Database Name with a Leading Space
52932198163  (http://support.microsoft.com/kb/198163/EN-US/ ) FIX: FT Wizard Fails with WinNT Authentication and Not Sysadmin
52979197800  (http://support.microsoft.com/kb/197800/EN-US/ ) FIX: Cursor Overhead Higher on SQL 7.0 for Small Result Sets
53018201857  (http://support.microsoft.com/kb/201857/EN-US/ ) FIX: BCP Format File Field Length Does Not Behave as Documented
53028196790  (http://support.microsoft.com/kb/196790/EN-US/ ) FIX: BULK INSERT w/ BATCHSIZE Disregards LASTROW Parameter
53101196771  (http://support.microsoft.com/kb/196771/EN-US/ ) FIX: @@language Value Can Be Truncated After Changing Value
53106202429  (http://support.microsoft.com/kb/202429/EN-US/ ) FIX: Error 21761 When Binding Non-DBO Default
53157203777  (http://support.microsoft.com/kb/203777/EN-US/ ) FIX: Index Tuning Fails on Unicode Named Tables & Workfiles
53196198884  (http://support.microsoft.com/kb/198884/EN-US/ ) FIX: DTS Can't Save a Package to Repository w/ Login > 20 Chars.
53205224805  (http://support.microsoft.com/kb/224805/EN-US/ ) FIX: Index Tuning Wizard Recommends that Indexes for System Tables Be Dropped
53311198514  (http://support.microsoft.com/kb/198514/EN-US/ ) FIX: Restore to New Server Causes Transactions to Remain in Log
53327201533  (http://support.microsoft.com/kb/201533/EN-US/ ) FIX: Enterprise Manager Displays 'SQL Server Standard'
53390197385  (http://support.microsoft.com/kb/197385/EN-US/ ) FIX: DTSRun: Package Reports False Success with User Password
53428233027  (http://support.microsoft.com/kb/233027/EN-US/ ) FIX: Cannot Properly Add IPX/SPX Address to Server Network Utility
53470233525  (http://support.microsoft.com/kb/233525/EN-US/ ) FIX: Mmc.exe Remains in the Task List After Closing the Console Window
53474198265  (http://support.microsoft.com/kb/198265/EN-US/ ) FIX: Failed Sp_prepare Incorrectly Closes Transaction
53486200118  (http://support.microsoft.com/kb/200118/EN-US/ ) FIX: Adding Database Files During Upgrade May Cause Errors
53507198521  (http://support.microsoft.com/kb/198521/EN-US/ ) FIX: SQL Profiler May Cause Divide By Zero Exception
53547224160  (http://support.microsoft.com/kb/224160/EN-US/ ) FIX: Create DB Wizard Incorrectly Sets Trans. Log File Growth
53566221243  (http://support.microsoft.com/kb/221243/EN-US/ ) FIX: Users Added via WinNT Groups Not Able to View Table List
53568224539  (http://support.microsoft.com/kb/224539/EN-US/ ) FIX: Optimizer Does Not Consider Anti Semi Join for NOT IN Query
53590239773  (http://support.microsoft.com/kb/239773/EN-US/ ) FIX: Using dbcc Stackdump or CTRL+C + D Causes Fatal Exception on Windows 95 & Windows 98
53592229007  (http://support.microsoft.com/kb/229007/EN-US/ ) FIX: SpaceAvailableInMB Property Returns Used Space Instead
53594233019  (http://support.microsoft.com/kb/233019/EN-US/ ) FIX: DTSWIZ /? Shows /r as an Option but It Does Not Exist
53658232522  (http://support.microsoft.com/kb/232522/EN-US/ ) FIX: Err 16943 When Dropping Pull Subscription w/ 'ALL' Param.
53736199294  (http://support.microsoft.com/kb/199294/EN-US/ ) INF: Cursors Remain Open when CURSOR_CLOSE_ON_COMMIT Set OFF
53748219425  (http://support.microsoft.com/kb/219425/EN-US/ ) FIX: DTS Wizard New DB Errors When Target Server Is SQL 6.5
53803228933  (http://support.microsoft.com/kb/228933/EN-US/ ) FIX: 'Unspecified Error' Message Returns Placing a NULL in a Col
53834219416  (http://support.microsoft.com/kb/219416/EN-US/ ) FIX: Duplicate Hash Keys Created for Two Distinct Index Keys
53840240039  (http://support.microsoft.com/kb/240039/EN-US/ ) FIX: DBCC OPENTRAN Does Not Report Replication Information
53850218605  (http://support.microsoft.com/kb/218605/EN-US/ ) FIX: Progress Indicators Not Shown When Transferring Data w/ DTS
53851208927  (http://support.microsoft.com/kb/208927/EN-US/ ) FIX: Transfer Manager Leaves Open Connection in Source DB
53856199688  (http://support.microsoft.com/kb/199688/EN-US/ ) FIX: @@IDENTITY Returns NULL If Trigger Inserts into Tbl w/o ID
53857240036  (http://support.microsoft.com/kb/240036/EN-US/ ) FIX: Distribution Agent Ignores Error on Pre-Creation Command
53859 257425  (http://support.microsoft.com/kb/257425/EN-US/ ) FIX: DTS Object Transfer Does Not Transfer BLOB Data Greater Than 64 KB
53861240035  (http://support.microsoft.com/kb/240035/EN-US/ ) FIX: Logreader Failure with TEXT/IMAGE Data Inserted Through BCP
53975224986  (http://support.microsoft.com/kb/224986/EN-US/ ) FIX: Query Analyzer Truncates COMPUTE Clause Output at Six Chars
53980224162  (http://support.microsoft.com/kb/224162/EN-US/ ) FIX: Unhandled Exception During Upgrade When Excluding Database
53984215457  (http://support.microsoft.com/kb/215457/EN-US/ ) FIX: Logreader Fails to Replicate Updating Non-NULL Text Fields
53994224329  (http://support.microsoft.com/kb/224329/EN-US/ ) FIX: Merge Initial Sync w/ Dynamic Filters Takes Long Time
54013224996  (http://support.microsoft.com/kb/224996/EN-US/ ) FIX: Access Violation Selecting Linked Table
54112244763  (http://support.microsoft.com/kb/244763/EN-US/ ) FIX: Access Violation Under High Cursor Stress
54138218967  (http://support.microsoft.com/kb/218967/EN-US/ ) FIX: "CREATE INDEX" in Form Causes ASC or DESC to be Removed in an ORDER BY Clause
54186233553  (http://support.microsoft.com/kb/233553/EN-US/ ) FIX: Non-Clustered Fillfactor Reset When Clustered Index Created
54203219756  (http://support.microsoft.com/kb/219756/EN-US/ ) FIX: Connections May Result in Handle Leak If SQLTRACE Enabled
54345233190  (http://support.microsoft.com/kb/233190/EN-US/ ) FIX: Access Violation When Using UNIONs in Transact-SQL Cursors
54366224581  (http://support.microsoft.com/kb/224581/EN-US/ ) FIX: Large Numbers of AND Conditions May Cause Stack Overflow
54436219865  (http://support.microsoft.com/kb/219865/EN-US/ ) FIX: Sqltrace.dll May Cause Heap Corruption w/0-Length RPC Param
54451225084  (http://support.microsoft.com/kb/225084/EN-US/ ) FIX: IE 5.0 Hinders SQL 7.0 Wizards and Tabbed Dialogs on Win9x
54536229003  (http://support.microsoft.com/kb/229003/EN-US/ ) FIX: Error 21770 When Trying to Manage Permissions for User-Owned Stored Procedures in SEM
54540221558  (http://support.microsoft.com/kb/221558/EN-US/ ) FIX: Sp_replcounters with INSERT..EXEC May Cause Server Hang
54689239717  (http://support.microsoft.com/kb/239717/EN-US/ ) FIX: SQLDMO - Setting BULKCOPY.SuspendIndexing = True May Fail
54783228473  (http://support.microsoft.com/kb/228473/EN-US/ ) FIX: Adding Merge Subscription Fails with Error 8115
54840223257  (http://support.microsoft.com/kb/223257/EN-US/ ) FIX: RPC Using SQL_PARAM_OUTPUT and SQL_PARAM_DEFAULT May Cause AV
54985232244  (http://support.microsoft.com/kb/232244/EN-US/ ) FIX: Delay Between Responses Not Observed for Perf Condition Alert
55001244230  (http://support.microsoft.com/kb/244230/EN-US/ ) FIX: Slow Query Performance Using Correlated Subquery with "Or Exists" Clause
55067233542  (http://support.microsoft.com/kb/233542/EN-US/ ) FIX: Concurrent Execution of Keyset Cursors Cause Errors & AV
55087233491  (http://support.microsoft.com/kb/233491/EN-US/ ) FIX: Cannot Link OLAP Servers in SQL Server Enterprise Linked Server
55243230301  (http://support.microsoft.com/kb/230301/EN-US/ ) FIX: French BOL Table of Contents Missing 4 Topics
55572234915  (http://support.microsoft.com/kb/234915/EN-US/ ) FIX: Upgrade to SQL Server Fails When MSDE Installed from MOD

OLAP Services Fixlist

Collapse this tableExpand this table
Bug IDQ NumberTitle
639234646  (http://support.microsoft.com/kb/234646/EN-US/ ) FIX: MS Query Hangs Trying to Overwrite an Existing Local Cube File
664241351  (http://support.microsoft.com/kb/241351/EN-US/ ) FIX: Problems in Managing OLAP Cube Roles on French Versions
681234072  (http://support.microsoft.com/kb/234072/EN-US/ ) FIX: Dimension Wizard: Cannot Browse a Table or a View with a Space in the Table/View Name
1282233491  (http://support.microsoft.com/kb/233491/EN-US/ ) FIX: Cannot Link OLAP Servers in SQL Server Enterprise Linked Server
1286233179  (http://support.microsoft.com/kb/233179/EN-US/ ) FIX: OLAP: Cannot Upgrade Client Win98 Computer Containing Office 2000
1351234516  (http://support.microsoft.com/kb/234516/EN-US/ ) FIX: OLAP:DSO Role Update May Return "Key Already Associated" Error or Cause System Hang

APPLIES TO
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server OLAP Services
Keywords: 
kbnosurvey kbarchive kbbug kbfix kbinfo KB225019
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