As I know we can check the members of any login group through command 'xp_logininfo 'mssql\SQL 2005', 'members'' similarly am looking command to find out login group for any member.
Example:Domain user 'mssql\test' that is related to Domain Group 'mssql\SQL 2005', SQL server have so many login group available so it is time taking to check member for all group and find related group for member so looking any command to find related group of member.
Solution could be on SQL command or OS command.
asked Jul 05, 2012 at 04:39 AM in Default
I am not sure what you are after, but should not the use of account_name and 'all' option gives the desired result?
answered Jul 05, 2012 at 05:46 AM