is it possible to change the name of a login is sql server 2000

Hi, is it possible to change the name of a login on sql server 2000 from :
domain1\myuser to domain2\myuser
The authentication is windows mode.
Thank you
Is domain1\myuser owns any objects? If not, probably you can just drop
domain1\myuser and add domain2\myuser.
Lucas
"toutous" wrote:

> Hi, is it possible to change the name of a login on sql server 2000 from :
> domain1\myuser to domain2\myuser
> The authentication is windows mode.
> Thank you
>
|||I need to do a script that automates that for all logins. So yes the logins
might also own objects
Thank you
"Lucas Kartawidjaja" wrote:
[vbcol=seagreen]
> Is domain1\myuser owns any objects? If not, probably you can just drop
> domain1\myuser and add domain2\myuser.
> Lucas
> "toutous" wrote:

is it possible to change the name of a login is sql server 2000

Hi, is it possible to change the name of a login on sql server 2000 from :
domain1\myuser to domain2\myuser
The authentication is windows mode.
Thank youIs domain1\myuser owns any objects? If not, probably you can just drop
domain1\myuser and add domain2\myuser.
Lucas
"toutous" wrote:

> Hi, is it possible to change the name of a login on sql server 2000 from :
> domain1\myuser to domain2\myuser
> The authentication is windows mode.
> Thank you
>

is it possible to change the name of a login is sq

Hi, is it possible to change the name of a login on sql server 2000 from :
domain1\myuser to domain2\myuser
The authentication is windows mode.
Thank you

You cannot change logins for windows accounts.

You will have to add the domain2 logins and then map them to the databases as necessary.

It is possible to change SQL Server logins using sp_changeuserslogin system stored procedure, but I do not believe this will work with windows accounts.

is it possible to change the name of a login is sq

Hi, is it possible to change the name of a login on sql server 2000 from :
domain1\myuser to domain2\myuser
The authentication is windows mode.
Thank you

You cannot change logins for windows accounts.

You will have to add the domain2 logins and then map them to the databases as necessary.

It is possible to change SQL Server logins using sp_changeuserslogin system stored procedure, but I do not believe this will work with windows accounts.