Little SQL Server Tricks: Show the Edition of SQL Server

While solving the annoying problem with the *.bacpac files, I was not sure what edition of SQL Server I have installed on my machine. The simplest way to figure out what edition you run is to start SQL Server Management Studio, connect to your SQL Server and right click on the Server node. In the Properties you find an entry for the Product and that shows what edition you use:

The edition is show in the Product entry in the SQL Server properties dialog.

An alternative way to figure out what edition you use is the SQL Server Installation Center. In the Tools section you find the entry “Installed SQL Server features discovery report” that will produce a report like this one and list every part of SQL Server and its edition:


You see every part of SQL Server with their specific product details.

For most use cases the properties dialog in SQL Server Management Studio should be enough. The additional information of the features discovery report can help you if you need to know what different parts of SQL Server run on your machine.

Leave a Comment

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