none
Creating loginswith passwords

    Question

  • 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.

    Cheers

    Paul

    Monday, July 01, 2013 3:54 PM

Answers

All replies