T-SQL query to find members of a Database Role | SansSQL

Saturday, April 27, 2013

T-SQL query to find members of a Database Role

Here is a T-SQL query to find members of a Database Role

USE SansSQL --Change the Database Name
GO
SELECT USER_NAME(memberuid) AS Member ,USER_NAME(groupuid) GroupName FROM sysmembers
ORDER BY member 


No comments:

Post a Comment