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
On 24 Jul 2015, at 2:47pm, MM wrote:
> Is it possible to only update table1 in database1 and table2 in database2
> if both succeed?
Open one database.
Use the ATTACH command to attach the second database to the existing connection.
Use this connection for all operations on both databases.
Hello,
Is it possible to only update table1 in database1 and table2 in database2
if both succeed?
Rds,
3 matches
Mail list logo