Issue
How to identify your SQL Server version and edition
Solution
Run this sql query:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
Results Table:
Version Base Version RTM SP1 SP2 SP3 SP4
SQL 2000 8.0 194 384 534 760 2039
SQL 2005 9.0 1399 2047 3042 4035 5000
SQL 2008 10.0 1600 2531 4000 5500
SQL 2008r2 10.50 1600 2500 4000 6000
SQL 2012 11.0 2100 3000 5058
SQL 2014 12.0 2000
Article ID: 236, Created: January 19, 2009 at 11:41 AM, Modified: June 15, 2016 at 5:02 PM