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