Creating loginswith passwords


  • Hi,

    If I have a login on one SQL Server instance and I want to create it on another instance I can right click the login and select Script login as > CREATE To > New Query Editor Window. It's then possible to copy and paste the script to the new SQL Server instance and run it.

    If there is a password it is encrypted. If a script is run with an encrypted password does the new security get created with the actual password or is it the characters that get output with the encryption?

    I hope that makes sense.



    Monday, July 01, 2013 3:54 PM


All replies