Listing members of NT Group login

Does anybody have any experience with listing all the members who belong to
a
login that is a Windows Authenticated group using SQL Server 2k. My hunch i
s
that I will probably have to write some .net code using the activedirectory
namespace. anybody'exec xp_logininfo 'domain\group','members'
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"MSSQLServerDeveloper" <MSSQLServerDeveloper@.discussions.microsoft.com>
wrote in message news:4D2CBEAB-6E96-46CE-B088-D7EBDCACAA11@.microsoft.com...
> Does anybody have any experience with listing all the members who belong
> to a
> login that is a Windows Authenticated group using SQL Server 2k. My hunch
> is
> that I will probably have to write some .net code using the
> activedirectory
> namespace. anybody'|||Thanks - I took it a little further because I needed the results in a table
-
create table ##li(
an nchar(128),
ty char(8),
priv char(9),
mln nchar(128),
pp nchar(128))
INSERT INTO ##li
EXEC xp_logininfo 'SAIC-US-WEST\CorporateITSDBA_Admins', 'members'
select * from ##li
"Jasper Smith" wrote:

> exec xp_logininfo 'domain\group','members'
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "MSSQLServerDeveloper" <MSSQLServerDeveloper@.discussions.microsoft.com>
> wrote in message news:4D2CBEAB-6E96-46CE-B088-D7EBDCACAA11@.microsoft.com..
.
>
>