Policy based managment - import error

  • I am trying to import policies, I don't see them in mgmt. stud0, however I get error they already exists.

    what I am missing ?

    (for some strange reason your site does not work on chrome)

    Attachments:
    You must be logged in to view attached files.
  • The policies would be listed in msdb in syspolicy_policies_internal if you wanted to check that table. Or the view syspolicy_policies. Maybe try another version of SSMS and see if that's the issue with displaying the policies.

    Sue

  • ty , I  fixed em  it by running/executing

    select 'EXEC msdb.dbo.sp_syspolicy_delete_policy @name= '''+ name + ''';' from msdb.dbo.syspolicy_policies_internal where is_system=0

    union

    select 'EXEC msdb.dbo.sp_syspolicy_delete_object_set @object_set_id =' + cast(object_set_id as varchar) from syspolicy_object_sets where is_system=0

    union

    select 'EXEC msdb.dbo.sp_syspolicy_delete_condition @name =''' + name + ''';' from syspolicy_conditions_internal where is_system=0

     

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply