use of features in editions

• sqlfriend

  SSC Guru

  Points: 52794

  More actions

  November 29, 2012 at 5:20 pm

  #267520

  in our enviroment developer use developer edition, but our production server is standard edition.

  Is there a way to setup in policy-based management to raise an alarm

  whenever Enterprise Edition features are used for developers?

• Chris Harshman

  SSC-Forever

  Points: 42192

  More actions

  November 30, 2012 at 6:44 am

  #1564336

  there's a dynamic management view that could help:

  sys.dm_db_persisted_sku_features

  http://msdn.microsoft.com/en-us/library/cc280724.aspx

  maybe use this in a scheduled SQL Agent job and e-mail you if rows are returned?

• sqlfriend

  SSC Guru

  Points: 52794

  More actions

  November 30, 2012 at 11:20 am

  #1564509

  Thanks, that will work, I will give it a try