Home / server / Questions / 96476
Accepted
blueberryfields
Asked: 2009-12-22 13:50:01 +0800 CST

Does my SQL Server database use any Enterprise Edition only features?

  • 772

I have a SQL Server 2008 database, up on an Enterprise Edition server. I am wondering if I can move it over to a standard enterprise edition server. Is there any way for me to test the database to see if this type of move is possible, before attempting it?

sql-server

1 Answers

  1. Best Answer

    sys.dm_db_persisted_sku_features

    select * from sys.dm_db_persisted_sku_features

    This will not include though any application layer reliance on an EE feature, eg. query optimisations leveraging indexed views. But at least you will know whether the database can be attached safely to a SE instance (no compression, no partitioning, no TDE, no change capture).

    • 3