OK we seem to have found the issue. A consultant had some synonyms in a DB that was pointing to a server that no longer existed. ...

Firstly thanks for all the replies. I verified settings and everything looks good. We verified the firewall is turned off and the ports are not blocked. ...

Thanks for the responses and your help, I greatly appreciate it!!

Thanks I will look into the xp_fileexist

For educational purposes can you give me a rough outline of how to safely give access to xp_cmdshell and bulk administer rights as well...

The developers are using xp_cmdshell and the OS dir command to verify that the file path and file exists before loading the contents and doing further processing. Using a...

I would like to thank each and everyone who took the time to reply. I believe there are some areas that you pointed out where we need to...

Greg,

Thanks for the reply and I will try your solution.

Yes it does suck that we...

I found a bug in the Progress to SQL Server translation. Thanks for your reponses.

I thnik I might have found my problem. I will post more after I do some more testing.

I'm seeing a pattern in the trace file when an update statement committs and when it does not.

I attached a WORD document with a sample from the trace file. ...

The record is there but the update never happened. The record is in the state prior to the update running. Would it help to send a sample of...

Firstly thanks for taking the time to read and respond to my issue. I believe the problem may be widespread but we are testing our new 3rd party replication...