Post reply

How to find out what Service Packs I have installed for SQL Server 2000

  • April 12, 2006 at 2:17 pm

    #632194

    okay - will take your word for it!

    But on the msn download site this is what they have (see below) and it does not indicate in any way

    that it's the os sp and not the sql server sp...splly. when they say - "execute one of the following

    queries" which to me indicates that they're all equal so you need to run only one of them

    1.4 Identify the Current Version of SQL Server 2000

Before running Setup, you must identify the version of the Database Components instance that is being upgraded.

To identify the installed version of SQL Server 2000 Database Components

   1. Execute one of the following queries against an instance of the database engine by using isql, 
osql, or Query Analyzer.
          * SELECT SERVERPROPERTY('ProductLevel')

          * SELECT @@VERSION

          * SELECT SERVERPROPERTY('ProductVersion')
   2. Find out your version of Database Components by means of the following table.
      SQL Server 2000 Version and Level @@VERSION Product Level
      SQL Server 2000 Original Release         8.00.194 RTM
      Database Components SP1                 8.00.384 SP1
      Database Components SP2                 8.00.534 SP2
      Database Components SP3, 
      SP3a or MSDE 2000 Release A.         8.00.760 SP3
      Database Components SP4                 8.00.2039 SP4

      Note   Your product version may be different than these values if you 
      applied a hotfix after installing the product or after installing a previous service pack. For example, 
      @@VERSION returns a value of 8.00.818 after you apply the security fix MS03-031 to SQL Server 2000 SP3a.
   3. (Optional) If you are not sure whether you are running an edition of the SQL Server 2000 database engine 
      or MSDE 2000, use isql, osql or Query Analyzer to execute the following query against the instance in question.
        * SELECT SERVERPROPERTY('Edition')

      If this query returns "desktop engine," you are running an instance of MSDE 2000; otherwise, you are running an 
      instance of SQL Server 2000 database engine.

    ps:But will continue to rely on "SERVERPROPERTY('productlevel')" & properties window in EM!!







    **ASCII stupid question, get a stupid ANSI !!!**

Viewing post 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply