sys.dm_db_persisted_sku_features (Introduced in SQL Server 2008) DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-in/library/cc280724.aspx
Some features of the SQL Server Database Engine change the way that Database Engine stores information in the database files. These features are restricted to specific editions of SQL Server. A database that contains these features cannot be moved to an edition of SQL Server that does not support them Use the sys.dm_db_persisted_sku_features dynamic management view to list all edition-specific features that are enabled in the current database.
There are four features that captured by this DMV :
· Data Compression
· Partitioning
· Transparent Data Encryption (TDE)
· Change Data Capture
DBAs can identify all edition specific features that are enabled within a user database by using the sys.dm_db_persisted_sku_features dynamic management view.
Query 1 : Check Edition Specific features of select database
SELECT
DB_NAME() DBNAME,
FEATURE_NAME
FROM SYS.DM_DB_PERSISTED_SKU_FEATURES
Remarks
1. To use this DMV, User required VIEW DATABASE STATE permission on the server.
If you liked this post, do like on Facebook at http://www.facebook.com/mssqlfun
Reference : Rohit Garg (http://mssqlfun.com/)
Great Post