How to migrate logins along with roles RRS feed

  • Question

  • I have configure database mirroring in my server

    After I perform fail over from my principal to mirror server i have used sp_help_revlogin stored procedure to transfer logins from one instance to other all the logins got transferred.

    I want to know whether there is any script to transfer logins along with server roles.

    If for example a login named user1 is having a role setup admin in instance1 then he should be transferred to second instance with the same role, is this possible.



    Saturday, January 21, 2012 8:02 AM