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,884 reads
Eric Russell
Blogs
How I passed the 70-761 certification exam
By DesertDBA
FUN FACT: I have been a Microsoft Certified Professional for SQL Server for over...
Azure Storage tips
By James-Serra
As a followup to my blog post Azure Data Lake Store Gen2 is GA,...
Managing Agent Jobs on Availability Group Servers
As always, the scripts in this post can also be found on our Git...
Forums
SQL Server Availability Groups, Readable Secondary Backups and Log Chains
Hi all Bit if an unusual one here, and you’ll have to forgive me...
I need to move database with 500 tables from SQL Server to Oracle 19
I have a SQL Server database, that I need to migrate to Oracle 19....
I need to move database with 500 tables from SQL Server to Oracle 19
I have a SQL 2014 database, and two more from 2016, that I need...
Ask SSC