A while back, I wrote a script to generate the Alter/update statements by way of chaning the Old_domain to New_domain.  Below is the script;

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

--SQL 2000 migration script for DBA use,...