Re: Change logins domain in SQL2000 with Windows 2000

From: Ron Talmage (rtalmage@prospice.com)
Date: 10/31/02 

From: "Ron Talmage" <rtalmage@prospice.com>
Date: Thu, 31 Oct 2002 10:28:25 -0800

Javier,

If you change domains you will have to resolve the logins. You can use
sp_change_users_login to resolve them. See BOL.

Ron 

--
Ron Talmage
SQL Server MVP
"Javier Rosas" <jrosashe@accival.com.mx> wrote in message
news:7ac701c2808b$fa37de10$3bef2ecf@TKMSFTNGXA10...
> Hi all,
>
> I will upgrade WinNT to Windows 2K and I will upgrade SQL7
> to SQL2K, too.
>
> I have a dude, I need to change my users to another
> domain, with a procedure and a tool, they mantain the same
> policy permissions in OS, my question is: what's up with
> my users in SQL?  Do I need to add each login again and
> asign permissions again or exist any procedure to change
> all SQL logins with the same permissons when they change
> of domain?
>
> I think, it's like renaming the login in syslogins or
> sysxlogins.
>
> Anybody help me?
>
> Thanks in advance.
> Javier Rosas
Quantcast