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:
…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).
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.