Features are restricted to specific editions of SQL Server

0 947
Reading Time: < 1 minute

sys.dm_db_persisted_sku_features :

dynamic management view to list edition-specific features that are enabled in the current database.

If no features that may be restricted by a specific edition are used by the database, the view returns no rows.

To determine whether a database uses any features that are restricted to specific editions, execute the following statement in the database:

 

SELECT feature_name FROM sys.dm_db_persisted_sku_features;  
GO

 

Author Profile

I make SQL Server faster and more reliable. Database administration isn’t about passing a certified exam, or about pointing and clicking your way through a crisis. Database administration is about applying the right solution at the right time, avoiding risk, and making robust choices that get you home each night in time for dinner with your family .

My areas of specialty are:

• SQL Server 2019-2008 performance tuning.

• Designing high availability and disaster recovery solutions.

• Securing SQL Server

• SSIS , SSAS

• Designing Data warehouse

Leave A Reply

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More