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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-25 : 16:14:58
|
Mikael writes "Hi
I have two SQL Servers... Server A and B has both have a table calle tableA. Whenever someome makes an update in Server A on tableA I want the same update to made to Server B in tableA. I've tried using a trigger in Server A.tableA but i always get the following error message:
Server: Msg 7392, Level 16, State 2, Procedure testing, Line 8
Could not start a transaction for OLE DB provider 'SQLOLEDB'.
[OLE/DB provider returned message: Cannot start more transactions on this session.]
MS DTC is started and I've added server B with sp_addlinkedserver.
Any ideas of what I have to do? I've searched the Internet for quite some time now, but haven't been able to find an answer.
Thanks in advance,
Mikael
SQL Server 7.00.623
Win NT 4.0 Service Pack 5" |
|
|
|
|
|
Using triggers to update a database on a different SQL Server