what is the quick and easy way to sync passwords across the Sybase instances

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

.