Distributed Transactions

J can touch data from different database and different serwer using
OPENDATASOURCE, but can I
1. run transaction on set of operations made on fifferent databases
running on the same sql server
2. run transaction on set of operations made on different databases
running on different sql server
M.
Hi
Have you looked at using linked servers and the documentation on "BEGIN
DISTRIBUTED TRANSACTION" in Books online?
John
"MerlinXP" <MerlinXP_NOSPAM@.NOSPAM_poczta.onet.pl> wrote in message
news:u7pV4sHBGHA.3064@.TK2MSFTNGP10.phx.gbl...
>J can touch data from different database and different serwer using
>OPENDATASOURCE, but can I
> 1. run transaction on set of operations made on fifferent databases
> running on the same sql server
> 2. run transaction on set of operations made on different databases
> running on different sql server
> M.