Replication in a single transaction

[DKK]

We are using Transaction Replication across 3 DB's. Data from DB1 needs to be replicated to DB2 from where it goes to DB3. There are no independent updates in DB2 and DB3. We are using SQL Server 2005 & Push replication.

We need the replication to be in a single transaction. So, for an insert, the rows should be present in DB1, DB2 and DB3 or in none at all. There should not be a situation where the data is not replicated completely.

The MS-SQL docs are ambiguous about this feature. Does Transaction Replication provide this feature? If not, how can our requirement be met?

Thanks

[ck9663]

We are using Transaction Replication across 3 DB's. Data from DB1 needs to be replicated to DB2 from where it goes to DB3. There are no independent updates in DB2 and DB3. We are using SQL Server 2005 & Push replication.

We need the replication to be in a single transaction. So, for an insert, the rows should be present in DB1, DB2 and DB3 or in none at all. There should not be a situation where the data is not replicated completely.

The MS-SQL docs are ambiguous about this feature. Does Transaction Replication provide this feature? If not, how can our requirement be met?

Thanks

Can't you do a DB1 goes to DB2 then DB1 also goes to DB3?

-- CK

[DKK]

Can't you do a DB1 goes to DB2 then DB1 also goes to DB3?

-- CK

DB2 and DB3 are closely related in structure whereas DB1 is quite different. Replicatiing Data from DB1 to DB2 involves some logic but once this is done, DB2 to DB3 is quite straightforward.
Some books i browsed told me that MS-SQL uses distributed transactions to handle this in Transaction Replication, provided the DT Coordinator is running. Will need to test this to confirm but any help/insight will be appreiciated.