The job executes an sp on the local server, which does an insert, update and delete. All of these are done on the local server. It should not be connecting...

Hi,

No environment variables are used in this job.

Hi John,

Thank you for replying,

The attempted change will be the result of an import from and oracle db which is an automated process.

Is it possible to prevent the character from...

Hi John,

Thanks for your reply. That works a treat.  I have been asked additionally to be able to provide the details of the row that was affected by the insert....

John,

Thank you for your reply.  Is there away that the offending characters can be removed. The data is imported from another db and certain characters should be removed.