What is the best way to implement intranet security in SQL2000 with integrated security

We try to use integrated security in a 2000 environment. The problem that
we have is SQL don't have a good way to query NT Groups/users unless we switch
to Active Directory which will be years away for the company. We hack into
the system stored procedure to find an undocument way to get NT Group which
works in 7 but fail to work in 2000. Now, we found a work around using xp_logininfo.
Although it is not perfect but it works. I wonder is there any better way
to do Intranet with integrated security. I could not found anything on MSDN
site.


Thanks.

What is it that you want to know? What NT groups an NT based user is in?
What users are in a given NT group? I'm not clear on exactly what you're
after....


--
Rob Vieira
Visit www.ProfessionalSQL.com Today. It's new and improved!

"Lawrence Lau" <llau@primeRestaurants.com> wrote in message
news:3a6da15d@news.devx.com...
>
> We try to use integrated security in a 2000 environment. The problem that
> we have is SQL don't have a good way to query NT Groups/users unless we
switch
> to Active Directory which will be years away for the company. We hack into
> the system stored procedure to find an undocument way to get NT Group
which
> works in 7 but fail to work in 2000. Now, we found a work around using
xp_logininfo.
> Although it is not perfect but it works. I wonder is there any better way
> to do Intranet with integrated security. I could not found anything on
MSDN
> site.
>
>
> Thanks.