How do determine what Enterprise Edition features are enabled on your database? Well you can use the sys.dm_persisted_sku_features DMV to find what Enterprise Edition features are
enabled on your database.
Learn more about Dynamic Management Views (DMV’s) here
Here’s the query for the same
Running this query will list all edition-specific features that are enabled in the current database. Some of the database changing features restricted to the SQL Server Enterprise or Developer editions are Compression, Partitioning, ChangeCapture etc.
This DMV is also useful in situations where you are planning to move a database from a higher to a lower edition. Eg: From Enterprise to Standard edition. Running the query will tell you if there are any Enterprise Edition features enabled that may not work when you move to a lower edition.
The DMV will return no rows if no features restricted to a particular edition are used by the database.
Did you like this post?
|subscribe via rss||subscribe via e-mail|
|print this post||follow me on twitter|