tag:blogger.com,1999:blog-6664701585971860985.post365602788645264268..comments2023-06-28T16:58:07.380+01:00Comments on SQL Server 365: Determining Active Directory Group MembershipAnonymoushttp://www.blogger.com/profile/16118372390680186915noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-6664701585971860985.post-43197166123062627302012-01-26T09:43:02.787+00:002012-01-26T09:43:02.787+00:00Thanks for the advice Brian, I will have a look in...Thanks for the advice Brian, I will have a look into it. I still keep meaning to use Powershell more, but find the vast majority of the things I need to do day to day I can achieve faster in T-SQL.Anonymoushttps://www.blogger.com/profile/16118372390680186915noreply@blogger.comtag:blogger.com,1999:blog-6664701585971860985.post-12711508828343398212012-01-25T15:36:32.989+00:002012-01-25T15:36:32.989+00:00Rather than using xp_logininfo, I would recommend ...Rather than using xp_logininfo, I would recommend using something like PowerShell, outside of SQL Server, to ensure all the nested groups get handled properly, as well as situations where you may have to go cross-domain/cross-forest. I have seen cases where xp_logininfo doesn't return everything or returns a 0x5 error.K. Brian Kelleyhttp://gkdba.wordpress.com/noreply@blogger.com