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 Dennis Post,
Change @NewSMTP to a valid server name or IP address or leave NULL if you just want to generate the accounts as they are.
To skip the ping test, simply change @TestPing to 0.
If you have many accounts then it might be necessary to remove
@SQL = @SQL +
from the SELECT statement.
This will return each accounts TSQL in table format.
For SMTP authentication users, remember to change each users password before you run the generated script.
If there is only one account or only one password for multiple accounts then set the @PW variable.
Trying to audit account creation and permission changes
how to properly change the service accounts
CHANGING DB-OWNERSHIP TO SA ACCOUNT
Changing dbo_login Account to differnt one
WMI problems when changing to domain account - can't even change back.