How do I tell the version and edition of my SQL Server?

Run the following T-SQL statement against the master database:

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

Compare results to documentation at http://support.microsoft.com/kb/321185



Article ID: 18
Last updated: 29 Oct, 2019
Revision: 3
Installation & Upgrades -> How do I tell the version and edition of my SQL Server?
https://faq.freightware.biz/index.php?View=entry&EntryID=18