Post reply

SQL Logins/Roles Moving from SQL 2000 to SQL 2005

  • December 24, 2008 at 10:39 am

    #197784

    I'm migrating from SQL 2000 to SQL 2005 on another server. Is it possible to script out the users from SQL 2000 and re-create them on SQL 2005? If so, would their password from SQL 2000 carry over onto the new server?

    Thanks.

    Roger

  • December 24, 2008 at 10:50 am

    #917499

    Yes, look search the web for the stored procedure sp_help_revlogin. That will get you everything you need to script out the logins. That should work fine on 2005 as well.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • December 24, 2008 at 2:08 pm

    #917566

    Thank you for pointing me in the right direction. Found what I needed at

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

    Roger

  • December 26, 2008 at 2:29 am

    #917715

    U can generate SQL login scripts from Right click on database-->task-> Generate script

    and select only logins.

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply