DMV to identify database features restricted to specific edition of SQL Server 2008


If you have configured the user database any of below feature of SQL Server 2008 Enterprise Edition

— Data Compression
— Partitioning
— Transparent Data Encryption
— Change Data Capture

Above list of features will internally change the way the database engine stores information within the database files. If a database configured to use any of the above features which are specifically designed to be used in Enterprise Edition of SQL Server 2008, it cannot be moved to other editions of SQL Server 2008.

You can check the above feature by querying the sys.dm_db_persisted_sku_features DMV against database.

SELECT feature_name FROM sys.dm_db_persisted_sku_features ;
GO
Advertisements

One thought on “DMV to identify database features restricted to specific edition of SQL Server 2008

  1. Pingback: @jshah1982 posts DMV to identify database features restricted to specific edition of SQL Server 2008 | sqlmashup

Thanks for the comment, will get back to you soon... Jugal Shah

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s