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 Gordon Klundt,
I wrote this procedure mainly as an exercise in converting varbinary to a usable string in a CTE, but it ended up being a suitable replacement for a procedure (two procedures, actually) that have annoyed me for a while.
Here are the reasons I like this script better than sp_help_revlogin:
Hope this is useful to someone, good luck and enjoy.
script to create indexes existing in a database
Error with Create Login Script
Compare the logins and users on two instances and generate a TSQL script to make them the same.
Script out Logins and Users for Every Database in a SQL instance