How to view members of a Windows group using SQL

In many large environments we often see that there are a lot of Windows groups in your SQL server as logins, but do you know exactly who the users are of those groups? Consider also the servers with Windows Groups that are part of the system administrator roleand the power that they have. How can you tell which Windows users are actually the members of that group? In this video tutorial, Scott will show you a great script in SSMS that will show you how to determine the members of Windows Groups, as well as some other fun things you can do with the procedure.

Highlights from this video:

* Identifying groups vs users, adding new Windows groups as logins to SQL Server
* Login limitations in SSMS ( SQL Server Management Studio)
* Executing the user-identifying stored procedure
* Adjusting the parameters of the stored procedure