Which edition of MSSQL version is installed on Server?

[spencer]

By using following SQL command in MSSQL 2005 query browser on master database, you can determine which version of Microsoft SQL Server 2005 is running on your server,

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

The result will include:
• The product version (e.g., "9.00.1399.06").
• The product level (e.g., "RTM").
• The edition (e.g., "Enterprise Edition")

MS-SQL Server 2005 version:
Release Sqlservr.exe

RTM 2005.90.1399
SQL Server 2005 Service Pack 1 2005.90.2047
SQL Server 2005 Service Pack 2 2005.90.3042


MS-SQL Server 2000 version:
Release Sqlservr.exe

RTM 2000.80.194.0
SQL Server 2000 SP1 2000.80.384.0
SQL Server 2000 SP2 2000.80.534.0
SQL Server 2000 SP3 2000.80.760.0
SQL Server 2000 SP3a 2000.80.760.0
SQL Server 2000 SP4 2000.8.00.2039

[Rodricks]

You can also use Enterprise Manager or Management Studio and by right clicking on the database instance name and selecting properties. In the general section you can see information such as on the following screenshots.

[spencer]

Hi,

Indeed you are right!! Both processes will show you same result. But its alternate way Same as attached screen-shot..