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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(23)

You rated this post out of 5. Change rating

2012-02-09

6,966 reads

While attending SQLCon and FabCon Europe in Barcelona, there were a lot of announcements...

(This is the second post in a three-part series on how AI is changing...

I had seen these roles in various instances, but never dug into the new...

Comments posted to this topic are about the item Pay for Performance, which is...

Comments posted to this topic are about the item Packing and Decoding Device Status...

Comments posted to this topic are about the item SQL Server Audit Failures

If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?