Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Downgrading SQL question Expand / Collapse
Author
Message
Posted Tuesday, August 7, 2012 2:13 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, November 24, 2014 8:29 AM
Points: 598, Visits: 1,651
Hi all - I am wanting to downgrade an instance of SQL but need to ensure we are not using any of the Enterprise features. Is there a way I can do this or is it just a case of going through the list of Enterprise features and seeing if a DB is using it?

Thanks
Post #1341060
Posted Tuesday, August 7, 2012 2:29 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, November 24, 2014 8:29 AM
Points: 598, Visits: 1,651
OK I have found this view sys.dm_db_persisted_sku_features however I am wanting to downgrade form SQL 2005 Ent to Std as such it does not exist.
Post #1341063
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse