Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
By David A. Long,
Microsoft's Transfer or Drop the logins and the passwords between instances of SQL Server 2005 script:
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
Generate Insert script
Generate Script File Name
Generated script to update statistics
Generate scripts for all databases
A script generator for standard security compliance.