I was recently investigating a server where an Enterprise evaluation edition was installed. Surprisingly they were not sure the drive for the enterprise edition and were not aware of any enterprise features used. If I were to recommend them SQL standard is a better way forward I had to be sure that no enterprise features were used. Then I recalled a licencing statement from a script of Brent Ozar. I have slightly changed his query to suit my need to find the databases with Enterprise feature. EXEC dbo . sp_MSforeachdb ' if exists( SELECT 1 FROM ?.sys.dm_db_persisted_sku_features) select ''?''' ;