November 16, 2012 at 5:43 am
Is there a tsql script that can give me details (name, condition, created by etc) of all the policies created on my sql server?
November 16, 2012 at 5:48 am
You should be able to knock one up quick using msdb.dbo.syspolicy_################ tables
November 16, 2012 at 11:37 am
but the condition is given in code, not the actual condition
how do i get the actual condition?
November 19, 2012 at 2:05 am
You will need to shred the XML into its parts to rebuild the condition as it look in the GUI.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy