In our application for a particular we have to update two databases and a
set of tables in each database.

But the consitency should be maintained, that the whole transaction should
be saved only if all the inserts and updates in both the databases succeed.
Without going for MTS or COM+ what is the alternative way to do that?

Any suggestion or idea will be greatly appreciated.