Viewing post 16 (of 16 total)
To a certain extent, you can query if the Domain Admins are in the group of the builtin\administrators. Try this:
exec xp_logininfo 'BUILTIN\Administrators', 'members';
Note: it returns only the highest privilege level...
July 6, 2010 at 6:48 pm
#1189385