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