• SQLSACT (8/29/2012)


    How do I create the Logins with the same SID?

    Is there a process for this?

    Thanks

    Use sp_help_revlogin stored procedure provided by Microsoft at below link to generate the script of logins with their SID on primary server & execute the same script on secondary server.

    http://support.microsoft.com/kb/918992


    Sujeet Singh