I need to identify which of my many Enterprise Edition instances can be safely downgraded to Standard Edition. My understanding was that I could check that with this DMV:
SELECT * FROM sys.dm_db_persisted_sku_features ;
GO
The documentation says "If no features that are restricted by edition are used by the database, the view returns no rows"
However, this DMV is also returning 0 rows for my 2012 & 2014 instances that are using AlwaysOn Availability Groups (i.e. an Enterprise-only feature), so when I run it against my CMS it gives me misleading results.
I've Googled this, but I can't find anything to suggest that this DMV has been replaced. Do any of you know of a replacement or better way to do this?
Thanks