Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jestupinan
Starting Member
6 Posts |
 Posted - 2002-08-20 : 18:19:15
|
| Hi guys, I got this problem:I have a Sp that opens a transaction (Begin Tran) and Updates some local table. So far it's OK, but then, I need to insert on a table located in a remote server but the error 7293: "Only one transaction can be active on this section." raisesI use a linked server and it works fine for Selects and works fine if I insert in a table in the remote server without a transaction.Does anybody can help me here?Thanks!!! |
|
|
chadmat
The Chadinator
1974 Posts |
|
|
|
|
|
Please, help needed on Distributed Transactions