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,282 reads

The grade for January is a D. Details below, but just not making a...

Does Context Info work across databases? This post shows it does. Another post for...

Data On Rails is a Data On Wheels project designed to give a platform...

This is specific to 2022, but SQL in general. I will be joining a...

I have a two node SQL Standard 2014 Failover Cluster at the primary site. ...

Hi, I have just moved a DB from an old HP laptop, to a...