new server, change users domain

[voxinforma]

I am upgrading a sql 7/WinNT setup to a sql2k/Windows2k with Active Directory. My NT domain was called Olddomain and my 2k called Newdomain. Am using NT authentication.

Is there an easy way to modify all my sql users to change them all from olddomain/username to newdomain/username without having to do each by hand?

 

[TheBugSlayer]

Well, I know you can modify the data in syslogins system table but you have to assess the consequences of such actions. I am not sure if changing the domain name in the table alone fixes your problem. Are the passwords the same?