For more complete information see
Get the current installed version of SQL Server:
SELECT @@VERSION AS Version
or nicer:
SELECT SERVERPROPERTY('Edition') AS Edition, SERVERPROPERTY('ProductVersion') AS ProductVersion, SERVERPROPERTY('ProductLevel') AS ProductLevel
shows result like: "9.00.3054.00, SP2, Developer Edition."
or e.g.
select @@microsoftversion / 0x01000000, @@microsoftversion & 0xFFFF
This article is also available in the following languages: