Users in Groups

I have a Security Group on the server, and I assign SQL privileges based upon
that.

Is there a way to see who is in a security group directly through SQL 2005?

Thanks in advance
--
stullhe104

Nevermind.

By reading Dan Guzman's reply to "Domain Logins required if member of Domain
Group?" I was able to investigate xp_loginingo and found:

EXEC xp_loginingo 'SRVR\GRP', 'members'

This works nicely.

Thanks Dan!
--
stullhe104


"Herb" wrote:

> I have a Security Group on the server, and I assign SQL privileges based upon
> that.
>
> Is there a way to see who is in a security group directly through SQL 2005?
>
> Thanks in advance
> --
> stullhe104