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_principals
WHERE name in ('drm_dev', 'MyLogin2')
  AND type = 'S'