Presumably you've already made this work for a transaction involving two tables in the same database? Have you tried attaching a second database with Attach Database and using a similar logic?
In other words, is your question about using multiple databases in a transaction, or about how to perform error trapping after a statement in a transaction so that regardless of how many databases are involved in the transaction (even one) it is, depending on the error status, conditionally rolled back? Today, MM <finjulhich at gmail.com> wrote: > > Hello, > > Is it possible to only update table1 in database1 and table2 in database2 > if both succeed? > > Rds, > >
