show users in NT Groups

,

Another documented SP, which is useful for tracking Quick Login Info.

xp_logininfo
--This will give you a list of all Account Names on SQL Server instance

xp_logininfo '<Group or Login>'
xp_logininfo 'SQL Administrators'
--This will List the acount information 

xp_logininfo 'SQL Administrators','members'
--This will List all the available users in the Group with Mapped Login names

Rate

2 (1)

Share

Share

Rate

2 (1)