Identify the Current Version of SQL Server 2000

Identify the Current Version of SQL Server 2000 To identify the installed version of SQL Server 2000

Database Components

Identify the Current Version of SQL Server 2000 To identify the installed version of SQL Server 2000 Database Components.

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')

Find out your version of Database Components by means of the following table

SQL Server 2000 Version and Level	@@VERSION
SQL Server 2000 Original Release	8.00.194
Database Components SP1	8.00.384
Database Components SP2	8.00.534
Database Components SP3, SP3a or MSDE 2000 Release A.	8.00.760
Database Components SP4	8.00.2039

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.e
(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.

Knowledge Exchange about Php Java, Asp.Net, SEO At Narola Infotech