How to Find SQL Server Edition Information

Most recently I had to figure out the edition (Enterprise, Standard, etc.) of SQL Server running on a specific production database server. The client wanted to know to what extent was the database server STIG’d.

I initially ran SELECT @@VERSION but that doesn’t bring back the edition information. So I ran:

SELECT SERVERPROPERTY(‘Edition’)

…and that returned the edition information. I also included the @@VERSION information as that brings back what Service Pack level is applied (see snapshot below).

Find Edition of SQL Server

After seeing this database server was running on SQL Server Standard Edition, I let the client know that Common Criteria Compliance and TDE (Transparent Database Encryption) cannot be enabled as those are Enterprise features.

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.