Getting SQL Instance Edition or service pack for SQL 2012

I have posted the below query before for SQL Server 2005, 2008 and 2008 R2 on http://www.sharepointfire.com/?p=138 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 ‘)

 

image

Getting SQL Instance Edition or service pack for Microsoft SQL Server

I was working on a manual for implementing SCOM 2012 and I needed to document the SQL edition. I founded an select query a couple years ago what I’m using ever since. This query shows the edtion, productversion, productlvl and some more data.

I thought why not make a blog about it for people who are starting to use SQL.

Script

SELECT
SERVERPROPERTY(‘Edition’) AS ‘Edition’,
SERVERPROPERTY(‘ProductVersion’) AS ‘ProductVersion’,
SERVERPROPERTY(‘ProductLevel’) AS ‘ProductLevel’,
SERVERPROPERTY(‘ResourceLastUpdateDateTime’) AS ‘ResourceLastUpdateDateTime’,
SERVERPROPERTY(‘ResourceVersion’) AS ‘ResourceVersion’
GO

Below are 2 screenshots. 1 is from SQL 2005 and the other is SQL 2008 R2.

SQL 2005

image

SQL2008 R2

image