Yes, I have been able to run the same program from the command prompt logged in as the same user.

I tried that and it still does not work. However, I am not running an SSIS package (which the db_dts... roles in msdb are generally for) in the job...

Subscriptions can be updated with some forms of Transactional replication (i.e. updateable subscriptions or peer-to-peer replication), but merge replication does give you better control over conflict resolution.

Gabriel,

When trying to encrypt/decrypt data across two databases, you need to take care in how you are creating your symmetric keys. When you create the symmetric keys on each...

Did you have any luck renaming it? I thought in your initial posting that you were unable to rename it. What is the name of the mdf file?...