Query accounts, domain groups, and members who have admin membership.
This script leverages master.sys.server_principals and xp_logininfo to return accounts, domain groups, and members in a SQL Server admin fixed role.
2012-02-09
5,997 reads
Eric Russell
Blogs
Daily Coping 2 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Presenting on Ethics in Modern Data at Houston HASSUG/SQL BI Group July 2020 Meeting
By Will Assaf
Looking forward to presenting with my wife Christine Assaf our talk on Ethics in...
MVP for Another Year 2020-2021
By Tim Radney
Early this afternoon I received an email from Microsoft presenting me with the 2020-2021...
Forums
Daily Coping 2 Jul 2020
Today’s tip is share a happy memory with someone who means a lot to...
Query taking more than 4 hrs. - Any recommendations/suggestions?
One of our stored procs has been running for more than 4 hrs. and...
Unusual use of the WHERE clause
I am working an exercise problem where the solution provided has a WHERE clause...
Ask SSC