SQL SERVER
패스워드까지 그대로 로그인(계정) 옮기는법
bedbmsguru
2018. 10. 27. 22:41
SELECT 'CREATE LOGIN ' +name + ' WITH PASSWORD = ' + CONVERT(varchar (max), LOGINPROPERTY( name, 'PasswordHash'), 1 ) + ' HASHED, SID=' + CONVERT( varchar(max ), sid , 1) FROM sys .server_principalsWHERE name in ('drm_dev', 'MyLogin2') AND type = 'S'