what is the quick and easy way to sync passwords across th..

Hi all,

I have 2 Sybase instances where I have 'few' common logins. I wanted to
dump the passwords from one sybase instance to another instance.

I tried to do 'select name, password from master..syslogins where
name=&interested_logins&' .. from the instance1 and tried to upload them
to the instance2 with the 'update master..syslogins set
password=&password_from_instance1& where name=&name&', but this seem to
actually generate the md5sum for the password field in the syslogins
table. I guess I used to prefix '0x' in the password field while
updating and that seem to take care of syncing the passwords across the
instances for the few common logins but now that seem to not work.
Probably I could be missing something here.

I am wondering if there is a quick & easy to way around this?

Regards, Nikhil