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.
2012-02-09
5,842 reads
Eric Russell
Blogs
DBA Myths: The system sessions are the ones with a session_id 50 or less
Anecdotally any session_id that’s 50 or less is going to be a system session...
SQL Undercover TV – Encrypting SQL Backups
In this episode, David looks at how we can encrypt our SQL Server backup...
Using volumes in SQL Server 2019 non-root containers
I’ve seen a few people online asking how to use docker named volumes with...
Forums
Numeric and Decimal
Comments posted to this topic are about the item Numeric and Decimal, which is...
Maintenance Window for SQL Server Critical Alerts
Hello, We had some sql server have issues on some production servers. We actually...
Capturing all Error messages caused by SQL Server code
Hello - The ERROR_MESSAGE() is capturing only the last message in the error stack...
Ask SSC