Export users from role

  • Hi guys,

    I wonder if there is any way to export the users belong to a role (system or user) from a system table.

    I only can export the roles name to text file from EM and in the sysusers table I only can see the database users name and the roles name.

    I would like to export the database users that belongs to a role.

    Thanks

  • Have you tried sp_helprolemember?

    John

  • I didn't remember this sp. It worked perfectly.

    Many thanks for your help

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply