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

Today’s coping tip is to find a new way to use one of your...

And no, the answer is not because you want to be a Microsoft MVP....

Today’s coping tip is to avoid saying “I should” and make time to do...

Hi. In source SQL Instance target linked server has been created and connection tested...

Hello, so I have a part number, and I want to display it in...

I have this column in sql server that has value of "dog,cat,mouse" so I...