InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 16:31:04 GMT20http://www.sqlservercentral.com/Forums/Topic823975-1526-1.aspxI also posted this on the SQL Server 2005 Security forum and got the answer to use [b]IS_SVRROLEMEMBER[/b] which solves my problem.Wed, 02 Dec 2009 06:02:45 GMTjm99http://www.sqlservercentral.com/Forums/Topic823975-1526-1.aspxThanks for the advice. So it looks like I've got to:1) Create a linked server to OLE DB Provider for Microsoft Directory Services2) Find out which Windows Group(s) the user belongs to3) Determine the superset of server-roles that are applicable to the Windows Groups returned in step 2.A piece of cake considering my LDAP is very rusty :crazy:Mon, 30 Nov 2009 10:51:11 GMTjm99http://www.sqlservercentral.com/Forums/Topic823975-1526-1.aspxYou can get the list of Active Directory users for every Group create in SQL Server.RegardsSun, 29 Nov 2009 16:36:31 GMTsupport.sqlhttp://www.sqlservercentral.com/Forums/Topic823975-1526-1.aspxWhenever a user logs into SQL Server 2008 via a Windows group how can I determine which server roles are applicable to that user when only the windows group is listed in sys.server_principalsThe user and suser functions return information to the user's windows login not the group that they entered SQL Server by.Help appreciated.Tue, 24 Nov 2009 09:22:08 GMTjm99