April 28, 2004 at 11:45 am
I am trying to use xp_logininfo to get a list of people within an NT group. This group has been given access to the server and database. Problem is that the procedure doesn't return any information even though there are users within the group (verified by the NT command "net group").
It is SQL Server 2000 running on NT 2000. Anyone have any idea what the deal is?
Thanks,
George
April 28, 2004 at 12:28 pm
Try running xp_logininfo with no parameters.
It will show info for all nt users and groups.
April 28, 2004 at 12:49 pm
But what I need is a list of all users within a particular group. Running it without any parameters will not do this. Thanks for the feedback though.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply