select * from sys.sql_logins---拷贝出password(哈希密码)
CREATE LOGIN test1
WITH PASSWORD = 0x0100DBF387CCF45DAE93115E80D18962C1DB0CC7DCB8A027F93F hashed, ---可以与拷贝出来用户账户的密码一致
sid= 0xB08B6E953A82674F84EA34800A5E76D6,
CHECK_POLICY = OFF; -----不强制密码策略
CREATE LOGIN test1
WITH PASSWORD = 0x0100DBF387CCF45DAE93115E80D18962C1DB0CC7DCB8A027F93F hashed, ---可以与拷贝出来用户账户的密码一致
sid= 0xB08B6E953A82674F84EA34800A5E76D6,
CHECK_POLICY = OFF; -----不强制密码策略
----------------------------------------------------------------------------
可用于镜像用户不一致情况处理:删除镜像用户,创建新用户
ALTER LOGIN login_name { <status_option> | WITH <set_option> [ ,... ] | <cryptographic_credential_option> } <status_option> ::= ENABLE | DISABLE <set_option> ::= PASSWORD = 'password' | hashed_password HASHED [ OLD_PASSWORD = 'oldpassword' | <password_option> [<password_option> ] ] | DEFAULT_DATABASE = database | DEFAULT_LANGUAGE = language | NAME = login_name | CHECK_POLICY = { ON | OFF } | CHECK_EXPIRATION = { ON | OFF } | CREDENTIAL = credential_name | NO CREDENTIAL <password_option> ::= MUST_CHANGE | UNLOCK <cryptographic_credentials_option> ::= ADD CREDENTIAL credential_name | DROP CREDENTIAL credential_name