INF: SQL Server 7.0 Service Pack 1 Fixlist

ID: Q225019


The information in this article applies to:


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.

Please note that this article is a living document. We are continuing to write articles about additional bugs that have been fixed, and as those articles are published, this article will be updated.

In addition, 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 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:

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


MORE INFORMATION

SQL Server and MSDE FixList

NOTE: Some of the articles listed in the table below are currently works in progress. As soon as these articles are publicly available, we'll update this article and provide links that work.

Bug ID Q Number Title
46568 Q207451 FIX: DTS Query Designer Does Nothing When ENTER Key Is Pressed
48052 Q225045 BULK INSERT Statement Inserts Records Into Table When FIRSTROW Is Greater Than LASTROW
52498 Q196919 FIX: Desc. Index Scans May Block with High Transaction Isolation
52728 Q224157 FIX: Internal Error 998 Reported from Profiler
52795 Q198515 FIX: Address Book in Send Mail Task Adds Only First Address
52932 Q198163 FIX: FT Wizard Fails with WinNT Authentication and Not Sysadmin
52979 Q197800 FIX: Cursor Overhead Higher on SQL 7.0 for Small Result Sets
53028 Q196790 FIX: BULK INSERT w/ BATCHSIZE Disregards LASTROW Parameter
53101 Q196771 FIX: @@language Value Can Be Truncated After Changing Value
53106 Q202429 FIX: Error 21761 When Binding Non-DBO Default
53157 Q203777 FIX: Index Tuning Fails on Unicode Named Tables & Workfiles
53196 Q198884 FIX: DTS Can't Save a Package to Repository w/ Login > 20 Chars.
53205 Q224805 FIX: Index Tuning Wizard Recommends that Indexes for System Tables Be Dropped
53311 Q198514 FIX: Restore to New Server Causes Transactions to Remain in Log
53327 Q201533 FIX: Enterprise Manager Displays 'SQL Server Standard'
53390 Q197385 FIX: DTSRun: Package Reports False Success with User Password
53428 Q233027 FIX: Cannot Properly Add IPX/SPX Address to Server Network Utility
53474 Q198265 FIX: Failed Sp_prepare Incorrectly Closes Transaction
53486 Q200118 FIX: Adding Database Files During Upgrade May Cause Errors
53507 Q198521 FIX: SQL Profiler May Cause Divide By Zero Exception
53547 Q224160 FIX: Create DB Wizard Incorrectly Sets Trans. Log File Growth
53566 Q221243 FIX: Users Added via WinNT Groups Not Able to View Table List
53568 Q224539 FIX: Optimizer Does Not Consider Anti Semi Join for NOT IN Query
53592 Q229007 FIX: SpaceAvailableInMB Property Returns Used Space Instead
53594 Q233019 FIX: DTSWIZ /? Shows /r as an Option but It Does Not Exist
53736 Q199294 INF: Cursors Remain Open when CURSOR_CLOSE_ON_COMMIT Set OFF
53748 Q219425 FIX: DTS Wizard New DB Errors When Target Server Is SQL 6.5
53803 Q228933 FIX: 'Unspecified Error' Message Returns Placing a NULL in a Col
53834 Q219416 FIX: Duplicate Hash Keys Created for Two Distinct Index Keys
53850 Q218605 FIX: Progress Indicators Not Shown When Transferring Data w/ DTS
53851 Q208927 FIX: Transfer Manager Leaves Open Connection in Source DB
53856 Q199688 FIX: @@IDENTITY Returns NULL If Trigger Inserts into Tbl w/o ID
53975 Q224986 FIX: Query Analyzer Truncates COMPUTE Clause Output at Six Chars
53980 Q224162 FIX: Unhandled Exception During Upgrade When Excluding Database
53984 Q215457 FIX: Logreader Fails to Replicate Updating Non-NULL Text Fields
54013 Q224996 FIX: Access Violation Selecting Linked Table
54139 Q217036 FIX: Logreader Tasks Not Upgraded from SQL Server 6.5 to 7.0
54203 Q219756 FIX: Connections May Result in Handle Leak If SQLTRACE Enabled
54345 Q233190 FIX: Access Violation When Using UNIONs in Transact-SQL Cursors
54366 Q224581 FIX: Large Numbers of AND Conditions May Cause Stack Overflow
54436 Q219865 FIX: Sqltrace.dll May Cause Heap Corruption w/0-Length RPC Param
54451 Q225084 FIX: IE 5.0 Hinders SQL 7.0 Wizards and Tabbed Dialogs on Win9x
54536 Q229003 FIX: Error 21770 When Trying to Manage Permissions for User-Owned Stored Procedures in SEM
54540 Q221558 FIX: Sp_replcounters with INSERT..EXEC May Cause Server Hang
54783 Q228473 FIX: Adding Merge Subscription Fails with Error 8115
54985 Q232244 FIX: Delay Between Responses Not Observed for Perf Condition Alert
55067 Q233542 FIX: Concurrent Execution of Keyset Cursors Cause Errors & AV
55243 Q230301 FIX: French BOL Table of Contents Missing 4 Topics

OLAP Services Fixlist

Bug ID Q Number Title
681 Q234072 FIX: Dimension Wizard: Cannot Browse a Table or a View with a Space in the Table/View Name
1282 Q233491 FIX: Cannot Link OLAP Servers in SQL Server Enterprise Linked Server
1286 Q233179 FIX: OLAP: Cannot Upgrade Client Win98 Computer Containing Office 2000

Additional query words: sp sp1 fix list


Keywords          : kbbug7.00 
Version           : winnt:7.0
Platform          : winnt 
Issue type        : kbinfo 

Last Reviewed: July 21, 1999