Domain Collapse. Sql permission question.

Internally sql server uses SID of NT users to link them
with sql logins. I don't know if NT will preserve SIDs
when users are migrated to another domain. If it does then
users can login with Domain2\user1 and still have same
permissions in sql server based on their SID stored in
sysxlogins table, though their username will be displayed
as Domain1\user1. You can update sysxlogins table and
change users display name.
If users are assigned new SID by NT then I am afraid you
have to add them again and assign permisstions.
hth.

>--Original Message--
>We are in the process of collapsing a domain. How do i
change the database permissions to reflect the new domain
names. Example Domain1\user1 is migrated to Domain2. user1
is now Domain2\user1. In SQL, the user is still displayed
as Domain1\User. Any idea. Thanks in advance.
>.
>When they are migrated to nt the sid stays the same. so the permission shoul
d be ok from your info. Thanks for the help.