InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 07:45:26 GMT20http://www.sqlservercentral.com/Forums/Topic612919-391-1.aspxsimilar here[url=http://www.sqlservercentral.com/Forums/Topic1100990-1550-1.aspx?Update=1]http://www.sqlservercentral.com/Forums/Topic1100990-1550-1.aspx?Update=1[/url]I blogged about what I did to solve the problem here[url=http://jonmorisissqlblog.blogspot.com/2011/04/configure-policy-to-checks-that.html]http://jonmorisissqlblog.blogspot.com/2011/04/configure-policy-to-checks-that.html[/url]Fri, 29 Apr 2011 15:49:23 GMTJon.Morisihttp://www.sqlservercentral.com/Forums/Topic612919-391-1.aspxOh, depending on the number of accounts you could identify them explicitly by name in the condition. Fri, 16 Jul 2010 06:15:06 GMTreuben.andersonhttp://www.sqlservercentral.com/Forums/Topic612919-391-1.aspxYes. Me too. The only variables you can pass into an execute string are @@objectname and @@schemaname. Seems a strange thing to be missing also. Fri, 16 Jul 2010 06:12:36 GMTreuben.andersonhttp://www.sqlservercentral.com/Forums/Topic612919-391-1.aspxI'm trying to set up a policy to verify that only specific accounts are members of the sysadmin server role. I have successfully set up other policies, but can't see how to refer to server roles within policy management conditions.Any ideas ? Thank you.Wed, 03 Dec 2008 08:52:04 GMTmps