• It should be;

    SELECT 'EXEC sp_grantlogin [' + REPLACE(name, 'old domain ', 'new domain') + ']'

    FROM syslogins

    where isntname = 1

    AND name LIKE 'old domain%'

    I tried to use tags and it didn't take.

    K. Brian Kelley
    @kbriankelley