You can then explicity name the 2nd db you are trying to access (e.g. insert into [db2].dbo.[tablename]...)
I think then it should be possible to have a transaction that covers both dbs, as long as the same connection is used for both
I havent checked using cftransaction, although I have done something similar within a stored procedure with serializable isolation, which may be worth exploring.
You don't seem to have specified which db you are using - though I imagine something similar may be possible in most RDBMS's.
HTH
Dan
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
