Issues with Policy Based Management condition excluding databases

• coreyjbaum

  SSC Eights!

  Points: 922

  More actions

  December 1, 2015 at 10:26 am

  #322943

  I have a policy that requires that a stored procedure be of a certain schema and prefix, this has worked for a long time, but im finding that i need to exclude the system databases from this. I have been trying to create another condition of the database facet to exclude databases.

  For the facet im using the following

  != 'master'

  AND != 'tempdb'

  AND != 'msdb'

  The condition creates fine, but when i try to attribute the condition to the policy i get the following error when trying to save it.

  Operation 'Alter' on object 'ObjectSet[@Name='Stored Procedure Schema / Prefix Policy_ObjectSet']' failed during execution. (Microsoft.SqlServer.Management.Dmf.UI)

  Invalid target filer: StoredProcedure. Only filters that restrict the first level below the Server node are allowed.

  The transaction ended in the trigger. The batch has been aborted. (Microsoft SQL Server, Error: 34016)

  Although i find that when i only have one database in the condition it works fine ?