MS SQL Determine Enterprise Features Posted on May 19, 2014 by torrancejones Use the following to determine if your MSSQL database has features only available inĀ enterprise versions of the product (partitioning, compression, encryption, etc). select * from sys.dm_db_persisted_sku_features