Microsoft SQL Server Retrieve information about the database See if Enterprise-specific features are being used

Help us to keep this website almost Ad Free! It takes only 10 seconds of your time:
> Step 1: Go view our video on YouTube: EF Core Bulk Extensions
> Step 2: And Like the video. BONUS: You can also share it!

Example

It is sometimes useful to verify that your work on Developer edition hasn't introduced a dependency on any features restricted to Enterprise edition.

You can do this using the sys.dm_db_persisted_sku_features system view, like so:

SELECT * FROM sys.dm_db_persisted_sku_features

Against the database itself.

This will list the features being used, if any.



Got any Microsoft SQL Server Question?