locked
Transfer logins between 2005 and 2008 RRS feed

  • Question

  • Hello

    I know the 'sp_help_revlogin' specified below works for transferring logins from 2005 to 2005 isntances

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

    Does this also hold good for transferring logins between instances of 2005 to 2008 and also between 2 instances of 2008?

    Thanks


    Monday, August 13, 2012 3:06 AM

Answers

  • Hi,

    It works for SQL Server 2008 even 2012. As it mentioned below of the thread:

    Applies to
    • Microsoft SQL Server 2005 Standard Edition
    • Microsoft SQL Server 2005 Workgroup Edition
    • Microsoft SQL Server 2005 Developer Edition
    • Microsoft SQL Server 2005 Enterprise Edition
    • Microsoft SQL Server 2008 Standard
    • Microsoft SQL Server 2008 Workgroup
    • Microsoft SQL Server 2008 Developer
    • Microsoft SQL Server 2008 Enterprise
    • Microsoft SQL Server 2012 Standard
    • Microsoft SQL Server 2012 Developer
    • Microsoft SQL Server 2012 Enterprise

    Cheers


    MCP, MCTS, MCITP

    • Proposed as answer by Olaf HelperMVP Monday, August 13, 2012 4:49 AM
    • Marked as answer by Satya Krishna Monday, August 13, 2012 1:43 PM
    Monday, August 13, 2012 3:24 AM