January 17, 2002 at 10:53 am
How can I tell if a PC is running SQL 2000 Personal Edition, Developer's Edition, Standard, or Enterprise Edition? "Select @@version" doesn't help me at all.
TIA,
Bill
January 17, 2002 at 1:32 pm
Using Enterprise Manager, go to the Server/PC you want to investigate, right click SQL_Server_Name, Properties. On the "General" tab you'll see the version information you're looking, including SQL Server version, O/S version, Memory and Server Collation.
cabby2583
Always Learn!
January 21, 2002 at 9:48 am
Are you running this from QA. If so, get the results in text and you should see standard edition or enterprise edition in the text.
From the SP2 readme:
Service Pack 2 for Microsoft SQL Server 2000
November 9, 2001
© Copyright Microsoft Corporation, 2001. All rights reserved.
Contents
1.0 Introduction
1.1 Identifying the Current Version of SQL Server or Analysis Services
2.0 Downloading and Extracting SP2
2.1 Database and Analysis Services SP2 Files
2.2 Desktop Engine SP2 File
3.0 Service Pack Installation
3.1 Back Up Your SQL Server Databases
3.2 Back Up Your Analysis Services Databases
3.3 Make Sure That the System Databases Have Enough Free Space
3.4 Stop Services and Applications Before Running SP2 Setup
3.5 Install Database Components SP2
3.6 Install Analysis Services SP2
3.7 Install Desktop Engine SP2
3.8 Restart Services
3.9 Restart Applications
3.10 Installing on a Failover Cluster
3.11 Installing on Replicated Servers
3.12 Applying SP2 to Non-Writable Databases or Filegroups
3.13 Uninstalling SP2
3.14 Reapplying SP2
4.0 Unattended Installations
4.1 Redistributing Database Components SP2 Client Components
5.0 Documentation Notes
5.1 Database and Desktop Engine Enhancements
5.1.1 Installing New Instances of the Desktop Engine
5.1.2 Using Chinese, Japanese, or Korean Characters with Database Components SP2
5.1.3 Hash Teams Removed
5.1.4 Affinity Mask Switches Added
5.1.5 SQL Server Agent Logs Account Information
5.1.6 Filtered Indexed View
5.2 Analysis Services Enhancements
5.2.1 Remote Partitions
5.2.2 Updated Analysis Services Redistributable Client Setup
5.2.3 Support Enabled for Third-Party Data Mining Algorithm Providers
5.2.4 Installing Analysis Services on a Computer With Updated Client Files
5.3 Replication Enhancements
5.3.1 Transactional Replication Update Custom Stored Procedure
5.3.2 Transactional Replication UPDATE Statements on Unique Columns
5.3.3 Restrictions Removed from Concurrent Snapshot Processing
5.3.4 Transactional Replication Scripting Custom Stored Procedures
5.3.5 Merge Replication Retention-Based Meta Data Clean Up
5.3.6 Backup and Restore Issues for Merge Replication
5.3.7 Restoring Replicated Databases from Different Versions of SQL Server
5.3.8 A New -MaxCmdsInTran Parameter for Log Reader Agent
5.3.9 Restriction on non-Unique Clustered Indexes
5.3.10 A New –maxnetworkoptimization Command Line Argument for Snapshot Agent
5.4 Meta Data Services
5.4.1 Meta Data Browser Exports in Unicode
5.5 Data Transformation Services
5.5.1 DTS Wizard No Longer Limits String Columns to 255 Characters
5.5.2 Security Context Logged for DTS Packages Run by SQL Server Agent
5.5.3 SQL Server Agent Proxy Account Improvements
5.6 Enhancements to the Virtual Backup Device API
5.6.1 Capturing Multiple Databases in a Single Snapshot
6.0 English Query Enhancement
7.0 DB-Library and Embedded SQL for C
1.0 Introduction
This release of Service Pack 2 (SP2) for Microsoft® SQL Server™ 2000 is provided in three parts:
Database Components SP2 provides updates for the database components of an instance of SQL Server 2000, excluding instances of the SQL Server 2000 Desktop Engine. Database Components SP2 includes upgrades to:
The data engine.
Database client tools and utilities such as SQL Server Enterprise Manager and osql.
Database client connectivity components, such as the Microsoft OLE DB Provider for SQL Server 2000, the SQL Server 2000 ODBC driver, and the client Net-Libraries.
Analysis Services SP2 provides updates for the SQL Server 2000 Analysis Services components of a SQL Server 2000 installation, including:
Analysis Services.
Analysis Services client components, which include Analysis Manager and the Microsoft OLE DB Provider for Analysis Services.
Database client connectivity components, such as the Microsoft OLE DB Provider for SQL Server 2000, the SQL Server 2000 ODBC driver, and the client Net-Libraries.
Desktop Engine SP2 provides updates for the database components of an instance of the SQL Server 2000 Desktop Engine (also referred to as MSDE 2000), including:
The data engine.
Database client connectivity components, such as the Microsoft OLE DB Provider for SQL Server 2000, the SQL Server 2000 ODBC driver, and the client Net-Libraries.
These three parts of SP2 can be applied individually, as follows:
SQL Server 2000 sites can use Database Components SP2 to upgrade their database components without upgrading their Analysis Services components or instances of the SQL Server 2000 Desktop Engine.
Analysis Services 2000 sites can use Analysis Services SP2 to upgrade their Analysis Services components without upgrading instances of the Desktop Engine or their database components.
Desktop Engine sites can use Desktop Engine SP2 to upgrade instances of the Desktop Engine without upgrading Analysis Services or instances of other editions of SQL Server 2000.
NOTE: If you have separate instances of both the Desktop Engine and other editions of SQL Server on the same computer, you will need to apply the Desktop Engine SP2 to the Desktop Engine 2000 instances and the Database Components SP2 to the other instances of SQL Server 2000.
For more information about installing the Desktop Engine, see Section 2.2 Desktop Engine SP2 File; and Section 3.7 Install Desktop Engine SP2.
NOTE: Desktop Engine SP2 is the only service pack part made available in Portuguese (Brazil), Swedish, and Dutch, because SQL Server 2000 Desktop Engine is the only version of SQL Server 2000 produced for those languages. The SQL Server 2000 components upgraded by Database Components SP2 or Analysis Services SP2 are not available in these languages. Portuguese (Brazil), Swedish, and Dutch users who want to apply Service Pack 2 to a version of SQL Server other than the Desktop Engine must download the Service Pack 2 files that match the language of the edition they will upgrade, such as downloading the English-language Service Pack 2 files if they are running an English-language version of SQL Server 2000. You will find download instructions below in Section 2.0 Downloading and Extracting SP2.
Details of Database Components SP2 Installation
Database Components SP2 Setup automatically detects which edition of SQL Server 2000 is present on the instance of SQL Server 2000 being upgraded, and only upgrades the components that have been installed for that instance. For example, when the service pack is applied to a computer running SQL Server 2000 Standard Edition, it will not attempt to upgrade components that ship only with SQL Server 2000 Enterprise Edition.
Database Components SP2 can be applied to a single default instance or a named instance of SQL Server. If multiple instances of SQL Server 2000 need to be upgraded to SP2, you must apply SP2 to each instance. When one instance on a computer with one or more instances of SQL Server 2000 is upgraded to SP2, all of the tools will be upgraded to SP2. There are not separate copies of the tools for each instance on a computer.
Removing SP2
When the service pack is installed, it makes changes to the system tables for maintenance reasons, and it also upgrades user and distribution databases that are members of a replication topology. Due to these changes, SP2 cannot be removed easily. To revert to the build you were running before you installed SP2, you must first uninstall the instance of SQL Server 2000. Then you must reinstall that instance of SQL Server 2000. If you were running SQL Server 2000 SP1, then you will need to reapply SP1 to the instance. For more information about uninstalling SP2, see Section 3.12 Uninstalling SP2
NOTE: To remove SP2, you must have a backup of the master, model, and msdb databases, taken immediately prior to applying SP2. For more information, see Section 3.1 Back Up Your SQL Server Databases; and Section 3.2Back Up Your Analysis Services Databases.
Additional Information about SP2
A list of the fixes contained in this service pack is provided in Microsoft Knowledge Base article Q306908. Each fix listed in Q306908 has a link to a Knowledge Base article describing the problem addressed by the fix. These articles are published at the Microsoft Product Support Services Knowledge Base.
To find articles about SP2 fixes in the Knowledge Base
Select SQL Server from the My search is about list.
Select Specific article ID number from the search by list.
Enter Q306908 in the My question is about field.
Click the Go button.
Follow the links to the FIX articles to see information about each fix.
Any information relevant to SQL Server 2000 Service Pack 2 that was not available in time to be included in this Readme file will be published in Microsoft Knowledge Base article Q306909. This article is available at the Microsoft Product Support Services Knowledge Base.
To find additional SP2 issues in the Knowledge Base
Select SQL Server from the My search is about list.
Select Specific article ID number from the search by list.
Enter Q306909 in the My question is about field.
Click the Go button.
QFE Fixes
If you received a QFE fix after October 3, 2001, the fix is not likely to be included in SP2. Please contact your primary support provider about a QFE fix against SP2.
1.1 Identifying the Current Version of SQL Server or Analysis Services
Use the following techniques for finding out which version of SQL Server or Analysis Services you have installed.
SQL Server
To identify which version of SQL Server 2000 you have installed, type SELECT @@VERSION at the command prompt when using the osql or isql utilities or in the Query window in SQL Query Analyzer. The following table shows the relationship between the version string reported by @@VERSION and the SQL Server 2000 version number.
@@VERSION SQL Server 2000 version
8.00.194 SQL Server 2000 RTM
8.00.384 Database Components SP1
8.00.532 Database Components SP2
If you are not sure which edition of SQL Server 2000 you are running, view the last line of output returned by SELECT @@VERSION. The last line should match one of the following:
Desktop Engine on Windows NT 5.0 (Build 2195: Service Pack 2)
Enterprise Evaluation Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
Personal Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
NOTE: The beginning of the line indicates the SQL Server edition. This is followed by current operating system information.
Steve Jones
January 21, 2002 at 10:07 am
Thanks Steve!
I was typing "select @@version" in Query Analyzer and displaying the results in "grid mode". And I didn't scroll far enough to see the info I wanted. "Text mode" clearly displayed what I wanted and that is a lesson I'll remember.
Bill
January 21, 2002 at 10:16 am
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply