Post reply

Generate a script for logins

  • March 30, 2009 at 8:42 pm

    #201672

    I would like to move a database from one server. In this move, I need a script to copy all logins only related to this database to the new environment. Does anyone have the script?

    The move can be from SQL 2000 to SQL 2000, SQL 2000 to SQL 2005, or SQL 2005 to SQL 2005.

    Any input will be greatly appreciated in advance.

  • March 31, 2009 at 2:39 am

    #968900

    You may find this article useful.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • March 31, 2009 at 8:47 am

    #969178

    Thank you for your input. The article you introduced is for transferring all logins on a server. What I would like to do is to transfer logins only related to the database I would like to move.

    Any other idea?

    Many thanks once again.

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

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