I have setup a log shipping for disaster recovery for SQL 2k standard edition.

The DTS Transfer Login task could not transfer the login password changes
properly to the standby server. All user logins are standard sql logins. It
looks like if the login already exists in the standby server, even though
with different SID, nothing will be updated.

I have worked around that by clean up the sysxlogin table in standby server,
every time before the scheduled DTS task running.

I have experience with the other option to script syslogin table in the
source server and apply the script to the destination server. That works.

Could any SQL guru advise me if the DTS transfer login task can handle the
login password change?

Thanks,

Frank