Getting SQL Instance Edition or service pack for SQL 2012

October 2, 2013By Maarten PeetersSQL No Comments

I have posted the below query before for SQL Server 2005, 2008 and 2008 R2 on and it is still usable for SQL Server 2012 SELECT SERVERPROPERTY(‘Edition’) AS ‘Edition’, SERVERPROPERTY(‘ProductVersion’) AS ‘ProductVersion’, SERVERPROPERTY(‘ProductLevel’) AS ‘ProductLevel’, SERVERPROPERTY(‘ResourceLastUpdateDateTime’) AS ‘ResourceLastUpdateDateTime’, SERVERPROPERTY(‘ResourceVersion’) AS ‘ResourceVersion’ GO (It is possible you need to change the ‘)