You have 2 options.
- You can run the following SQL query:
SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)
- You can check the version of the sqlservr.exe file, below is a list of how the version breaks down:
SQL Server 2005
SQL Server 2005 RTM 2005.90.1399 SQL Server 2005 Service Pack 1 2005.90.2047 SQL Server 2005 Service Pack 2 2005.90.3042 SQL Server 2000
SQL Server 2000 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