Post reply

Export users from role

  • March 27, 2007 at 2:37 am

    #176893

    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

  • March 27, 2007 at 3:33 am

    #697080

    Have you tried sp_helprolemember?

    John

  • March 27, 2007 at 4:56 am

    #697093

    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