To identify which SQL Server version, service pack and edition you are using

To determine which version of Microsoft SQL Server 2005/2008 is running, connect to SQL Server 2005/2008 by using SQL Server Management Studio, and then run the following Transact-SQL statement.

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

Output

9.00.2047.00

SP1

Standard Edition (64-bit)