tag:blogger.com,1999:blog-6818257984018916419.post1926990188956158623..comments2024-01-26T06:00:42.884-08:00Comments on Jon Morisi's SQL Blog: Configure a policy to check that the BUILTIN\Administrators group is in the sysadmin server roleJon Morisihttp://www.blogger.com/profile/11048505964243402700noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-6818257984018916419.post-70100261832348593662014-04-24T15:32:54.797-07:002014-04-24T15:32:54.797-07:00I'm not sure how you're going about it, al...I'm not sure how you're going about it, all I can say is what's above worked for me at the time that I did this. Be sure to click the links and read through the references. <br /><br />The one thing I learned is that policy-based management only covers a small subset of what we as DBA's would like to do and as a result I do not find it very useful. I've been in dozens of customer environments and have yet to find anyone using policy-based management. My personal opinion is that policy-based management is one of those features that isn't very useful.Jon Morisihttp://www.jonmorisissqlblog.comnoreply@blogger.comtag:blogger.com,1999:blog-6818257984018916419.post-59218178421835406542014-04-24T15:16:26.513-07:002014-04-24T15:16:26.513-07:00Excellent post, but I'm hoping you can help me...Excellent post, but I'm hoping you can help me out as I'm trying to implement this. When I attempt to past in the ExecuteSQL(.... command in the field, and set the value to sysadmins, it will not let me save it, and says the property 'expressionNode' is not set. Seems like I can only use the facets that are pre-built in, and nothing else. Anonymoushttps://www.blogger.com/profile/09576759220790371129noreply@blogger.com