How to determine the version and edition of SQL Server and its components

Just run the following query:

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

Release        Product                           Version 

SQL Server 2005 Service Pack 4        9.00.5000.00 

SQL Server 2005 Service Pack 3        9.00.4035 

SQL Server 2005 Service Pack 2        9.00.3042 

SQL Server 2005 Service Pack 1        9.00.2047 

SQL Server 2005 RTM                       9.00.1399 

SQL Server 2008 R2 Service Pack 1   10.50.2500.0 

SQL Server 2008 R2 RTM                  10.50.1600.1 

SQL Server 2008 Service Pack 3        10.00.5500.00 

SQL Server 2008 Service Pack 2        10.00.4000.00 

SQL Server 2008 Service Pack 1        10.00.2531.00 

SQL Server 2008 RTM                       10.00.1600.22 

More info: http://adf.ly/8OXyp