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,
Quote:
|
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