SQL Determine if Enterprise features are in use

 

You can determine if any SQL Enterprise version features are in use in a database by checking the sku features table.

This query lists all edition-specific features that are enabled in the current database

SELECT feature_name FROM sys.dm_db_persisted_sku_features ;
GO

Note that you must be on SQL 2008 or higher and have view database state permissions in order to see the query results.

 

Comments are closed.