Home Forums SQL Server 2005 SQL Server 2005 Security Changing Logins DOMAIN for Users RE: Changing Logins DOMAIN for Users
K. Brian Kelley
SSC Guru
Points: 114562
More actions
November 5, 2007 at 7:04 pm
#748471
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