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

(2021-July-30) A picture is worth a thousand words, the same way a visual database schema...

You might be asking why on earth would you want to get a database...

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

Hi Guys, I have an SQL Server 2012 Express database that I would like...

Comments posted to this topic are about the item Deploying SQL Server Automatically

I well realize data compression is a subject to a few variables, such as...