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
>|||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:
> 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
> >