Hi,
I'm trying to identify if a SQL Server 2005 Enterprise edition box that I have is using any enterprise features (as I'm downgrading to standard edition). I can't use the system sproc "sys.dm_db_persisted_sku_features" as its not supported on 2005.
I found a nice article that can identify if the 2 database-level features are being used (partitioning & VarDecimal storage format). Article is located here:
http://www.trycatchfinally.net/2013/04/identifying-sql-server-2005-enterprise-edition-features-in-use/
unfortunately it does not check for server-level features. Does anyone know how I would check for this? Any nice scripts or advice you would like to share would be most appreciated.
Thank you,
J.