What is the version and edition of MS SQL Server(s)?

Connect to the instance of SQL Server, and then run the following query:

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

The following results are returned:

- The product version (for example, 9.00.4035.00)
- The product level (for example, SP2)
- The edition (for example, Enterprise)