I was able to use 'xp_loginingo' to find out the members of BUILTINAdministrators' But I can not use xp_logininfo to find out the members in the specific windows group, I have both window level and Sql server level Admin right. Server: Msg 8198, Level 16, State 12, Procedure xp_logininfo, Line 38 Could not obtain information about Windows NT group/user 'DomainUserGroup'. What may be the potential reason for this failure, lack of the active directory privilege? ------------------ Bug explorer/finder/seeker/locator ------------------
KBAhttp://support.microsoft.com/kb/834124 explains the issue to rsolve. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
