2 added 438 characters in body
source | link

In SQL Server 2000, I don'tthink you'll have a 2000 instance handy to test right nowdrop and re-create the user, but couldunless you want to reply on crazy hacks like this one:

I don't really recommend that, both because updating system catalogs is dangerous, and also because it beuses undocumented, unsupported, and buggy sp_MSForEachDB (see why I urge you to stay away from that one).

In versions newer than SQL Server 2000, it is as simple as:

ALTER USER foo WITH NAME = bar;

(I honestly forget if this syntax was valid in SQL Server 2000.)

I don't have a 2000 instance handy to test right now, but could it be as simple as:

ALTER USER foo WITH NAME = bar;

(I honestly forget if this syntax was valid in SQL Server 2000.)

In SQL Server 2000, I think you'll have to drop and re-create the user, unless you want to reply on crazy hacks like this one:

I don't really recommend that, both because updating system catalogs is dangerous, and also because it uses undocumented, unsupported, and buggy sp_MSForEachDB (see why I urge you to stay away from that one).

In versions newer than SQL Server 2000, it is as simple as:

ALTER USER foo WITH NAME = bar;
    Post Migrated Here from stackoverflow.com
1
source | link

I don't have a 2000 instance handy to test right now, but could it be as simple as:

ALTER USER foo WITH NAME = bar;

(I honestly forget if this syntax was valid in SQL Server 2000.)