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
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