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: