943276 wrote:Yes, and I know three ways to do this:
Here is a situation: business proces requires modifications in 3 databases. in each database there is a procedure to do the job, lets say p1 on database d1, p2 on d2, p3 on d3.
Is it possible to call p1, then p2, then p3 in a way that if any error occurs during one of them all changes done so far on those databases can be rollbacked? In other words, is is possible to treat all calls to those procedures as a part of one transaction (ie. all or nothing)?