Eric Russell

Interests: “Public opinion is a weak tyrant compared with our own private opinion. What a man thinks of himself, that it is which determines, or rather indicates, his fate.” - Henry David Thoreau

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.61 (23)

2012-02-09

6,156 reads

Being aligned to a global cloud like Microsoft Azure you have choices. Whether that...

I started a poll today on the naming for future SQL Saturdays. You can...

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

We have no prior experience of using XE. Yes, our DBA group uses server...

Comments posted to this topic are about the item Easing Back to the Office

Comments posted to this topic are about the item Missing Data

Visit the forum

See possible answers