Post reply

Script to Create SQL Server Logins. Not the Database Users

  • October 10, 2011 at 10:13 pm

    #390582

    Hi,

    I've been given work to migrate SQL 2000 database to SQL 2005 standard Edition.

    I have to script out Sql server logins which are stored in Master database.

    I know how to script Database users by generate SQL scripts -> but dont know how to generate Sql logins. 🙁

    Is there any script available that can generate create login for all the sql logins in SQL 2000.

    Please let me know.

    Thanking in Advance.

    .

  • October 10, 2011 at 10:42 pm

    #1392659

    sp_help_revlogin

  • October 10, 2011 at 11:52 pm

    #1392671

    Right click on any DB -> All Tasks -> Generate SQL Script

    goto tab "options" and check "Script SQL Server logins (Windows Ans SQL Server logins)"

    I Have Nine Lives You Have One Only
    THINK!

  • October 11, 2011 at 2:29 am

    #1392710

    See here for details: How to transfer logins and passwords between instances of SQL Server

    -- Gianluca Sartori

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

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