• Divine Flame (8/29/2012)


    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

    Thanks

    I came across this script a while ago, I wasn't sure if it would take the SID as well

    Thanks for this