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

Leave a Reply

Your email address will not be published. Required fields are marked *