Article ID: 232574 - View products that this article applies to.
This article was previously published under Q232574
This article has been archived. It is offered "as is" and will no longer be updated.
This article is a copy of the Readme.txt file included in Service Pack 1 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0.
Service Pack 1 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0May 25, 1999
(c) Copyright Microsoft Corporation, 1999
1.1 Service Pack Versions
2.0 Downloading and Extracting SP1
2.1 Extracting Database Components SP1
2.2 Extracting OLAP Services SP1
3.0 Service Pack Installation
3.1 Back Up Databases
3.2 Ensure the System Databases Have Enough Free Space
3.3 Prepare Cluster Configurations
3.4 Stop Applications Before Running Service Pack 1 Setup
3.5 Install Database Components SP1
3.6 Install OLAP Services SP1
3.7 Restart Services
3.8 Recluster a Cluster Configuration
3.9 Restart Applications
4.0 Redistributing Database Components SP1 Client Components
5.0 Documentation Notes
5.1 Upgrading Client-Only Computers After Installing SP1
5.2 Rebuilding master After Installing SP1
5.3 Applying SP1 to a Later Version
5.4 Installing SP1 on Windows NT 4.0, Terminal Server Edition
5.5 SP1 and Replication
5.5.1 Installing SP1 on a Server Providing a Remote Distribution Database for Merge Publications5.6 Change in Cursor Behavior
5.5.2 Upgrading to SP1 a Merge Publisher That Will Still Receive New Subscriptions from the Original Release of SQL Server 7.0
5.5.4 Running SP1 Replication with Earlier Versions of SQL Server
5.5.5 Updating Access 2000 (Jet 4.0) Merge Replication Subscribers
5.7 Changes in OLAP Services
5.7.1 Improved Security5.8 Data Transformation Services
5.7.2 The German Version of SQL Server OLAP Services on Alpha
5.7.3 Migrating the Repository of a Remotely Administered OLAP Server
5.7.4 OLAP Services SP1 with the Korean Version of Windows NT
5.8.1 Exporting to Oracle Databases5.9 SQL Server 7.0 and Exchange 5.5
5.8.2 Using the DTS Test Feature
5.8.3 Changes to the Execute Package Dialog Box
5.8.4 Data Transformation Services Error Messages
5.8.5 Use of the SET keyword in Microsoft Visual Basic Scripts
5.8.6 Tests Now Support Global Variables and Lookups
5.10 The French Version of SQL Server Books Online
5.11 SQL Server Clustering White Paper
1.0 IntroductionSP1 for SQL Server 7.0 and MSDE 1.0 is provided in two parts:
Once the service pack has been applied to a computer, there is no procedure to remove the service pack. This applies to both Database Components SP1 and OLAP Services SP1.
At this time there are no fixes required for the version of Microsoft English Query shipping with SQL Server 7.0.
The list of the fixes contained in this service pack is in Microsoft Knowledge Base article 225019
(http://support.microsoft.com/kb/225019/EN-US/ ). Each fix listed in Q225019 has a link to the Knowledge Base article describing the problem addressed by the fix. These Knowledge Base articles are published at http://support.microsoft.com/search/
(http://support.microsoft.com/search/). Select the option to search by article number and enter the article number Q225019.
For the latest year 2000 information specific to SQL Server 7.0, refer to the SQL Server 7.0 information in the Microsoft Year 2000 Resource Center.
1.1 Service Pack VersionsIf you are not sure which service pack you have installed on an instance of the SQL Server 7.0 database engine or MSDE 1.0, you can verify the version by issuing SELECT @@VERSION from osql, SQL Server Query Analyzer, or isql. This table illustrates the relationship between the version string reported by @@VERSION and the SQL Server 7.0 and MSDE 1.0 service packs:
Collapse this tableExpand this table
If you are not sure which edition of SQL Server 7.0 you are running, or if you have connected to MSDE 1.0, the last line of output returned by @@VERSION reports the edition to which you have connected:
2.0 Downloading and Extracting SP1This service pack is distributed in two formats:
If you downloaded SP1, you need to extract the files to build the service pack directories before you can run Setup.
NOTE: Several of the files in service packs are system files. Make sure you have the 'Show all files' option turned on in either Windows NT Explorer or Windows Explorer when working with service packs. To enable this option, on the View menu click Options and then select the option.
2.1 Extracting Database Components SP1To extract the Database Components SP1, place the self-extracting file for your processor architecture into a directory on the computer running SQL Server or MSDE. From that directory, execute the file. The self-extraction program will prompt you for the name of the directory in which you want the service pack files placed. For example, if you are running SQL Server or MSDE on an Intel-based computer and have created a directory named C:\70sp1, copy the file Sql70sp1i.exe to your computer, execute it, and provide the name of the C:\70sp1 directory when prompted.
This will extract the service pack files and place the two Microsoft Systems Management Server files in the C:\70sp1 directory. Additionally, a subdirectory will be created for the hardware platform (X86 or Alpha) where the remainder of the service pack files will be placed.
You can rename the database installation directory; however, you need to make sure that the directory name does not contain space characters.
2.2 Extracting OLAP Services SP1To extract the OLAP Services SP1, create a directory on your computer to hold the OLAP Services SP1. Copy the self-extracting OLAP Services file for your processor architecture into a directory on the computer running OLAP Services. From that directory, execute the file. The self-extraction program will prompt you for the name of the directory in which you want the service pack files placed. For example, if you are running SQL Server on an Alpha-based computer and have created a directory named C:\70sp1olap, copy the file Sql70olapsp1a.exe to your computer, execute it, and provide the name of the C:\70sp1olap directory when prompted. This will extract the service pack files.
3.0 Service Pack InstallationYou may use different series of the installation steps to install the different parts of this service pack:
If you install OLAP Services SP1 on a computer, and subsequently reinstall the original version of SQL Server 7.0 OLAP Services, you must install OLAP Services SP1 again.
You can also use Systems Management Server to install SP1 automatically on multiple computers running Windows NT(R) Server. The Smssq701.pdf file is a Package Definition File (PDF) that automates the creation of a SQL Server package in Systems Management Server. The SQL Server package can then be distributed and installed on computers running Systems Management Server. The Smssq701.cmd file is a batch file that detects the platform of the computer and runs the appropriate version of the Setup program.
3.1 Back Up DatabasesAs a precaution, back up all of your databases, including the master and msdb databases. Installation of the service pack does not make modifications to user databases, but it does make modifications to the master and msdb databases.
3.2 Ensure the System Databases Have Enough Free SpaceIf the autogrow option is on for both the master and msdb databases in the SQL Server or MSDE system on which you apply SP1, you may skip this step. You can verify this in SQL Server 7.0 by connecting to SQL Server from SQL Server Enterprise Manager, right clicking the icon for the database, and selecting Properties. Verify that the Automatically grow file check box is selected. You can verify this in MSDE by issuing these SQL statements:
In the output of these statements, verify that the growth column is not 0.
If the autogrow option is not on for either master or msdb databases, the databases that cannot autogrow must have at least 500 KB of free space. To verify this, run the sp_spaceused system stored procedure in the context of the master or msdb database. If the unallocated space figure in either database is less than 500 KB, increase the size of the database. Follow the instructions in the topic "Expanding the Database" in SQL Server Books Online.
3.3 Prepare Cluster ConfigurationsBefore installing Database Components SP1 to SQL Server 7.0, Enterprise Edition in a clustered environment, ensure that the group containing Microsoft Distributed Transaction Coordinator (DTC) is owned by the node on which DTC was first installed. If the group is not owned by this node, Service Pack 1 Setup will display a DTC setup error prompting you to correct the problem and then retry the setup. Correct the problem by moving the group to the node on which DTC was first installed.
If SQL Server, Enterprise Edition is running in a clustered configuration, it must be unclustered before you can apply Database Components SP1. To uncluster SQL Server, select the Failover Cluster Wizard in the SQL Server 7.0 program group. When prompted, insert your original SQL Server, Enterprise Edition compact disc and follow the instructions displayed by the wizard. Do this on all nodes of the Microsoft Windows NT(R) cluster where SQL Server has been clustered.
All SQL Server 7.0 instances operating in a cluster must be upgraded to SP1 before they are reclustered.
Additional information about running SQL Server in a clustered environment is available in a white paper. For more information about the white paper, see section 5.11 of this Readme.txt file.
3.4 Stop Applications Before Running Service Pack 1 SetupBefore running Service Pack 1 Setup to apply Database Components SP1, shut down the following services and applications:
If installing in a Windows NT cluster, ensure these applications and services are stopped on all nodes in the cluster.
Also stop SQL Server Service Manager if it is running. Right click on the minimized SQL Server Service Manager icon on the right side of the task bar, and then select Exit.
3.5 Install Database Components SP1Run the Setup.bat script from either:
The setup process then replaces the existing SQL Server or MSDE files with the service pack files. Setup also runs several .sql script files to update system stored procedures.
The DTC installer installs a new version of Microsoft Distributed Transaction Coordinator on your system. In a clustered environment, it does this on all nodes of the Windows NT cluster.
Setup places a record of the actions it performed in the Sqlsp.log file in the Temp directory of the computer on which it was run.
3.6 Install OLAP Services SP1Review section 3.0, Service Pack Installation, to see which steps are required to install the OLAP Services SP1 if that is all you want to install.
To install OLAP Services SP1, run Setup.exe from either:
3.7 Restart ServicesWhen Setup has completed, it may prompt you to restart the system. After the restart, or after Setup completes without requesting a restart, use the Services application in Control Panel to make sure the Microsoft Search, MSDTC, MSSQLServer, MSSQLServerOLAPService, and SQLServerAgent services are running.
3.8 Recluster a Cluster ConfigurationIf you have applied this service pack in a Windows NT cluster configuration, recluster SQL Server. You must apply this service pack to all SQL Server 7.0 instances that will be included in the cluster before reclustering.
To recluster SQL Server, select the Failover Cluster Wizard in the SQL Server 7.0 program group. When prompted by the wizard, insert your original SQL Server, Enterprise Edition compact disc and follow the instructions displayed by the wizard. Do this on all nodes of the Windows NT cluster containing instances of SQL Server that you want to include in the cluster.
3.9 Restart ApplicationsRestart the applications you closed before running Service Pack 1 Setup.
4.0 Redistributing Database Components SP1 Client ComponentsThis service pack includes a new file which contains updated Microsoft Data Access Components (MDAC) for redistribution.
Developers of OLE DB or ODBC applications use the file Mdac_typ.exe to distribute the client connectivity components required to connect the application to various data sources:
Developers wanting to distribute the versions of the OLE DB Provider for SQL Server and the SQL Server ODBC driver that shipped with the original version of SQL Server 7.0 or MSDE 1.0 should use the versions of Mdac_typ.exe and Mdacredist.txt that shipped with:
You may redistribute the Sqlredis.exe file under the same terms and conditions noted in the Mdacredist.txt file which accompanies this service pack.
5.0 Documentation NotesThis section discusses issues that affect sites running SP1, but are not the result of fixes contained in the service pack.
Changes in behavior introduced by fixes are documented in the "FIX" Knowledge Base article published for each fix. Knowledge Base article Q225019 is a list of fixes contained in the service pack. Each fix is linked to its corresponding Knowledge Base article. You can access the articles from http://support.microsoft.com/search/
(http://support.microsoft.com/search/). Select the option to specify an article number, and specify Q225019. Follow the links to the "FIX" Knowledge Base articles to see the details of each fix.
5.1 Upgrading Client-Only Computers After Installing SP1Users sometimes first install only the SQL Server client components on a computer, then later add a Standard, Enterprise, or Desktop Edition of the database server to the computer. This is done by running the Setup program from the SQL Server compact disk. If the client components on the computer have already been upgraded to SP1, the SQL Server Setup program will fail with the error:
Use the following procedure to add a Standard, Enterprise, or Desktop Edition of the database server to a client computer running the SP1 client components:
You cannot install a version that is older (7.00.623) than the version on your machine (7.00.699). Uninstall the older version.
5.2 Rebuilding master After Installing SP1Rebuilding the master database after applying SP1 removes the SP1 updates to the system tables. Users who rebuild their master database after applying SP1 should reapply Database Components SP1 after the rebuild.
5.3 Applying SP1 to a Later VersionIf you attempt to upgrade a SQL Server installation whose database engine executable files are the same date or newer than the ones provided with Database Components SP1, Service Pack 1 Setup will terminate with the following message:
Usually this indicates that SP1 (or higher) has already been applied to the SQL Server instance on the server and an upgrade is not required.
Setup has detected newer SQL Server components than those available in the Service Pack. Setup will not continue.
Possible exceptions to this are customers who have received from their SQL Server support vendor a special SQL Server build that is newer than the SP1 build, and have applied that build to a system that was not first upgraded to SP1. These customers should contact their SQL Server support vendor to request information about the upgrade process.
5.4 Installing SP1 on Windows NT 4.0, Terminal Server EditionService Pack 1 introduces support for running SQL Server on Windows NT Server 4.0, Terminal Server Edition. The original release of SQL Server 7.0 is not supported on Windows NT 4.0, Terminal Server Edition.
Service Pack 1 requires that Windows NT Server 4.0, Terminal Server Edition, Service Pack 4 be applied to a computer running Terminal Server Edition before SQL Server is installed. This service pack is specific to Terminal Server Edition and is separate from the Windows NT Server 4.0 Service Pack 4. For more information on the Terminal Server Edition service pack, see the Microsoft service pack download Web page at http://www.microsoft.com/technet/archive/downloads/winnt.mspx?mfr=true
Use these steps to install SQL Server 7.0 and SP1 on Windows NT Server 4.0, Terminal Server Edition:
5.5 SP1 and ReplicationWe recommend you apply this service pack to all 7.0 participants in your replication topology: Publisher, Distributor, and Subscribers. We recommend that you deploy SP1 across the replication topology in this sequence:
In merge replication, the distribution database is simply used to store agent history. Typically, the distribution database in a merge replication topology resides on the same computer as the published database. However, it is possible to also have a remote distribution database for merge replication at sites that want to centralize agent history logging.
You may not be able to immediately upgrade all the servers in a replication topology, so replication operations generally work unaffected between servers running the original version of SQL Server 7.0 and SP1 participants. These are the exceptions and considerations:
5.5.1 Installing SP1 on a Server Providing a Remote Distribution Database for Merge PublicationsIf you upgrade to SP1 a server with a remote distribution database for merge publications, you must also upgrade to SP1 each of the merge replication Publishers that use that distribution database. This requirement ensures optimal delivery of data changes from the associated merge replication Publishers by any Merge (Push) Agents running on the Distributor.
5.5.2 Upgrading to SP1 a Merge Publisher That Will Still Receive New Subscriptions from the Original Release of SQL Server 7.0To allow new merge replication Subscribers from servers that do not have SP1 installed, you must add the optional parameter "-70Subscribers" to each Snapshot Agent job. This ensures complete initial synchronization of any new SQL Server 7.0 merge Subscribers that do not have SP1 installed.
If a Subscriber running the original version of SQL Server has already received the initial synchronization, that Subscriber will continue to be able to merge data even without this parameter. However, if the subscription is dropped and re-created, or the subscription has to be completely reinitialized, the parameter would be necessary. The preferred solution would be to upgrade the Subscriber to SP1 rather than use the parameter. If you want to be sure, you can add the parameter until you are confident all Subscribers have moved to SP1.
5.5.3 Installing SP1 on a Merge Replication SubscriberIf you upgrade a SQL Server merge replication pull Subscriber to SP1, you must also upgrade each of its associated merge replication Publishers to SP1. This ensures optimal delivery of data changes from the associated merge replication Publishers by any Merge (Pull) Agents running on the Subscriber. This is best accomplished using the Distributor-Publisher-Subscriber deployment sequence stated above.
5.5.4 Running SP1 Replication with Earlier Versions of SQL ServerThere are no known differences in how SP1 works with SQL Server 6.0 or 6.5 Publishers and Subscribers compared to how the original SQL Server 7.0 works with the earlier versions.
5.5.5 Updating Access 2000 (Jet 4.0) Merge Replication SubscribersIn order for Jet-based Access 2000 Merge Subscribers to take advantage of improvements in SP1, you will need to copy the following Database Components SP1 files to your workstations running Access 2000:
NOTE: These steps are not necessary if MSDE 1.0 is serving as the Access 2000 Merge Subscriber. In this case, simply apply Database Components SP1 following the instructions in this Readme.
5.6 Change in Cursor BehaviorIn the original releases of SQL Server 7.0 and MSDE 1.0, a rollback closes all open cursors except for cursors that meet all of the following conditions:
5.7 Changes in OLAP ServicesThese changes in OLAP Services are introduced in OLAP Services SP1:
5.7.1 Improved SecuritySecurity for OLAP Services has been enhanced in OLAP Services SP1. Cell-level security is now supported. For information about using cell-level security, see the white paper "Cell-Level Security," available at http://technet.microsoft.com/en-us/library/cc917668.aspx
5.7.2 The German Version of SQL Server OLAP Services on AlphaThe German version of OLAP Services Setup now works only on Intel platforms. The German version of SQL Server 7.0 OLAP Services is not supported on Alpha platforms. If you attempt to run the German version of the OLAP Services SP1 Setup program on an Alpha computer, Setup terminates with an error. Use the US English version of OLAP Services SP1 on Alpha computers running German-version software.
If you installed the German version of SQL Server 7.0 OLAP Services on an Alpha computer running the German version of Windows NT, you must install the US English version of OLAP Services SP1.
5.7.3 Migrating the Repository of a Remotely Administered OLAP ServerAfter you install OLAP Services SP1 on a server, you can migrate the repository using the instance of OLAP Manager on the server. You cannot use OLAP Manager from another computer remotely administering the server to perform this task.
5.7.4 OLAP Services SP1 with the Korean Version of Windows NTIf you use SQL Server 7.0 OLAP Services on a server running the Korean version of Windows NT, you will not be able to connect to your OLAP server if you install Database Components SP1, OLAP Services SP1, or separately install the MDAC 2.1 SP1.
After you install any of these service packs on the server running OLAP Services, you must run Olaprepair.exe on the server to be able to connect to your OLAP server. Olaprepair.exe is located in the English version of OLAP Services SP1. Running this utility may require you to restart your server twice.
5.8 Data Transformation ServicesThese changes in Data Transformation Services (DTS) are introduced in Database Components SP1:
5.8.1 Exporting to Oracle DatabasesWhen exporting to Oracle using the DTS Export Wizard, if you create the destination tables using DTS, DTS will create the case-sensitive tables using quotation marks around the owner and table names. This is required to support owner or table names that are keywords or contain spaces. If your names are not keywords and do not contain spaces, and you want to remove the quotation marks, delete them in the DTS Copy Tables dialog box.
5.8.2 Using the DTS Test FeatureThe DTS Test feature has improved functionality and now supports global variables and lookups. However, the DTS Test feature does not support data lineage columns in Microsoft ActiveX(R) scripts in Test mode.
5.8.3 Changes to the Execute Package Dialog BoxWhen you execute a DTS package in the DTS Import Wizard, DTS Export Wizard, or DTS Designer, extra columns have been added to the Execute Package dialog box to display start time, end time, and duration. These new columns are not available if the package is run with a user password.
In addition, transfer notification information is provided during package execution.
5.8.4 Data Transformation Services Error MessagesDTS Error messages have been improved and now supply OLE DB provider-specific information, and information on the operation that failed.
5.8.5 Use of the SET keyword in Microsoft Visual Basic ScriptsActiveX assignment of object references to DTS global variables in Visual Basic, Scripting Edition scripts now follows standard Visual Basic SET syntax in all cases.
Use SET when you want to assign an object reference; otherwise, the default value of the object will be assigned.
If a global variable contains an object reference, use both SET and .Value to reassign the object reference. For example, in the statements below:
5.8.6 Tests Now Support Global Variables and LookupsThe DTS user interface has a test option in two dialog boxes:
5.9 SQL Server 7.0 and Exchange 5.5You must explicitly configure memory usage in SQL Server if you run both a SQL Server 7.0 and a Microsoft Exchange version 5.5 server on the same computer. SQL Server will not operate properly if you leave the SQL Server minimum dynamic memory option set at the default value of 0.
To address a known memory issue that occurs when the two products are run together, you must set the SQL Server 7.0 minimum dynamic memory (or sp_configure min server memory option) to the amount of memory required to support the peak processing load of SQL Server. In this environment, SQL Server will not acquire enough memory to reach the maximum dynamic memory setting (or sp_configure max server memory option). Instead, SQL Server will usually run with the amount of memory specified in the minimum dynamic memory option. The minimum dynamic memory setting must therefore be sufficient to run SQL Server when it is operating at high capacity.
To determine the memory needed by SQL Server, monitor the memory used by SQL Server under the following conditions:
For more information on setting the SQL Server memory options, see "Server Memory Options" in SQL Server Books Online.
5.10 The French Version of SQL Server Books OnlineThe original French version of SQL Server Books Online had an incorrect table of contents. The French version of the Database Components SP1 includes a self-extracting file that contains a new French SQL Server Books Online file with a corrected table of contents.
To install the corrected French version of SQL Server Books Online:
5.11 SQL Server Clustering White PaperThere is a white paper named "How to Install SQL Server 7.0, Enterprise Edition, on Microsoft Cluster Server: Step by Step Instructions." This white paper supplements the clustering information in SQL Server Books Online. For more information about the white paper, see http://www.microsoft.com/sql/prodinfo/previousversions/whitepapers.mspx
Contact us for more help
Connect with Answer Desk for expert help.