Home Forums Article Discussions Article Discussions by Author Discuss content posted by Eric Russell Query accounts, domain groups, and members who have admin membership. RE: Query accounts, domain groups, and members who have admin membership.

  • February 9, 2012 at 8:23 am

    #1445112

    mw162 (2/9/2012)

    Really useful thanks. Was only looking at this myself yesterday but didn't go the extent of group members. I've amended the script slightly for our use to show the is_disabled status of each principal. This way I can also see the status of each sa account for mixed mode instances. I also ran the script in Management Studio 2008 against all registered servers in a local server group to see the full picture across our landscape: http://msdn.microsoft.com/en-us/library/bb964743.aspx%5B/quote%5D

    That's a good point. At one point I had the is_disabled column, but I'll add it back again.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho