July 24, 2019 at 6:46 pm
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
July 25, 2019 at 1:30 pm
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