Has anyone done a "Script as Create to..." on a SQL account then ran the script on another server? I am trying to get a user account onto another se3rver and I don't know the password. I run this command...
CREATE LOGIN [testuser] WITH PASSWORD=N'Ÿ m|qePF“‹*Q† 097', DEFAULT_DATABASE=[DBEMPTY], DEFAULT_LANGUAGE=[us_english]
GO

This was generated by doing the "Script as Create.....blah blah blah" but the password is not the same.
Is there a process to copy an account from one server to another that will bring the password over with it?

Thanks