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.


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

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

SQL 2005


SQL2008 R2


Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.