List of users in windows group

• Tara-1044200

  SSCoach

  Points: 15951

  More actions

  August 31, 2010 at 12:41 pm

  #237497

  Is there any other way of getting list of members from any windows group other than using

  EXEC xp_logininfo

  when i use this i am getting list for some groups but not for all groups, what is the trick?

• odanwada

  SSCrazy

  Points: 2133

  More actions

  September 1, 2010 at 1:31 am

  #1214771

  Hi,

  Try the following

  DECLARE @LoginName sysname

  DECLARE @sql NVARCHAR (2000)

  BEGIN

  DECLARE cur_Loginfetch CURSOR FOR

  SELECT [name] FROM master.sys.server_principals WHERE TYPE = 'G'

  OPEN cur_Loginfetch

  FETCH NEXT FROM cur_Loginfetch INTO @LoginName

  WHILE @@FETCH_STATUS = 0

  BEGIN

  EXEC xp_logininfo @LoginName , 'members'

  FETCH NEXT FROM cur_Loginfetch INTO @LoginName

  END

  CLOSE cur_Loginfetch

  DEALLOCATE cur_Loginfetch

  RETURN

  END