LoginWindowsGroupMemberSelect

Technical Article

Select Group Members from Logins

  • Script

Know who all the individual group members are for a given WINDOWS_GROUP login. This script uses the sys.xp_logininfo procedure to find group members for each login on an instance. This is useful when attempting to remove orphaned WINDOWS_LOGINS. May have issues working across your logged in domain.

(1)

You rated this post out of 5. Change rating

2020-03-23 (first published: )

1,620 reads

Blogs

Google Moves Up Post-Quantum Cryptography Timeline

By

In cryptography, the RSA and ECC algorithms which we use primarily for asymmetric cryptography...

The Book of Redgate: No Politics

By

In today’s world, this might mean something different, but in 2010, we had this...

The Burrito Bot: AI-Powered Search in SQL Server 2025

By

A while back I posted about a couple of side projects that I’ve been...

Read the latest Blogs

Forums

Identities and Sequences II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Identities and Sequences II

Using PostgreSQL as a NoSQL Store and a Search Engine

By sabyda

Comments posted to this topic are about the item Using PostgreSQL as a NoSQL...

Is Your Time "Free"?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Your Time "Free"?

Visit the forum

Question of the Day

Identities and Sequences II

In thinking about the differences between the identity property and a sequence object, which of these two guarantees that there are consecutive numbers (according to the increment) inserted in a single table?

See possible answers