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

1
2
3
4
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

Ads