Microsoft's Transfer or Drop the logins and the passwords between instances of SQL Server 2005 script:
http://support.microsoft.com/kb/918992
Modified the Microsoft example to add:
@include_role = 1 parameter will add generate sp_addsrvrolemember script
@drop_accounts = 1 parameter will add generate DROP instead of CREATE works with @include_role to generate sp_dropsrvrolemember script
Generates the script to limit the LOGINs scripted to those related to a single database (requires search and replace for database name in this script and stored procedure re-creation)
Adds EXISTS logic to eliminate the need to edit script to eliminate error if the object already exists
Adds self-documentation to generated script & execution
Enjoy,
Andy
