Thanks to all of you for your input on this.

1.) Yes, we re-installed and updated all components

2.) Did this yesterday, the problem still occurred last night.

3.) Wish I could. If it...

All maintenance is being done on weekends when production is offline and NO jobs are scheduled during the week. I turned everything off to eliminate them as potential problems.

The server...

Yes to all your questions.

The error almost ALWAYS starts with the machinedatahistory table. I do a select on the table and then an add/update.

I open and close the connection string...

IMHO, I would just use a new int PK. As long as the original PAS keys are retained in the new table, or put into a cross reference or lookup...

Aghh... that's probably what I was missing.

Good catch!! thanks!

This is what I expected, although I was hoping to glean a trick or 2 from the list.

Thanks anyway, I am already implimenting the suggestions above.

Journeyman:

Thanks for the prompt response. As for your questions:

I'd first want to know what on the system is up, running, and using the databases in a way that defeats...

Well, the type of replication I need is Transactional, but MSDE installs do not support this (ARGH!!!).

I guess I will have to mainatin my own internal transactional replication schema instead. 

Do triggers...

The synchronization I am most concerned with is from remote locations to enterprise server only, although there are other tables that are being synchronized from enterprise to remote (control tables).

Concerning...

I really appreciate the support. This is my first really BIG project and I tried to think of all possibilities and solutions. Unfortunatly, being a 1 man shop with very...

In a nutshell...

This application is designed to collect data at remote locations, display the data on a production monitor, send the data to an enterprise server for management access via a web...

Guus, thanks for the reply. I think I found a solution to the problem with one exception, but I have a work around for that. What I did:

1. I exported...

Running this now!!!

Thanks for all the help! It is truly appreciated.

Thanks, that is exactly whjat I was looking for.

Now, applying these settings is fairly straight forward, but if they start to cause issues, how do I revert back to default...

Are you using ADO,OLE DB, or some other DB access architecure?

What language? VB,C/C++, PHP, JAVA, other...?