It's a manual process, I use inserts from ,

i checked out the sp_serveroption, but it doesn't work.

Thanks anyway

both servers are configured exactly the same.

administrator on both of the machines, same username and password, the works?

yip, to check compatibility :

exec sp_dbcmptlevel , 'databasename'

to change

exec sp_dbcmptlevel , 'databasename', *

* to the desired level

Thanks, the encryption works, any suggestions on where to find the decryption