Hi,
I use merge replication to collect data from a number of agents into a central location (HQ), then process the data in the HQ.
The data that is being sent in comes from a number (4) different tables.
I'd like to be sure that processing (in the HQ) starts only when all data has been received.
Can anyone tell whether data is transferred in a single transaction or not?
If so, what is the isolation level of that transaction? Is data visible only when the transaction complete?
In SQL Server 2005 can I configure how a publication be