SQL Server Management Studio – How to determine Product Version, Edition, and Level

How to determine what version of SQL Server Management Studio you are running can be determined within SQL Server Management Studio by performing a SQL Query.

Here’s how:

1) Open Microsoft’s SQL Server Management Studio
2) Connect to a database server
3) Click ‘New Query’ from the toolbar.
4) Past the following query and execute:

 

SELECT SERVERPROPERTY('productversion') as ProductVersion
SELECT SERVERPROPERTY('edition') as EDITION
SELECT SERVERPROPERTY ('productlevel') as Level

Your results should look something like this:

Leave a Reply

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