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 - 2005-06-21 : 06:36:38
|
| Mildred writes "I have an issue with linked server and hope you are able to help me out.I have sql server 2000 running on windows 2000 server OS say machine AFrom this server I need to insert records through a trigger onto another server running sql server. This remote server has windows 2003 OS lets call it machine BI created a linked server to machine B on machine A.When I run the insert query through the query analyzer it works fine. But when I run it in the trigger it just hangs. I figured out that since a trigger is a part of a transaction it is some problem with the msdtc on the remote server. FYI - MSDTC is running on both machines. I have also given network distributed access for dcom on the remote server.I still get the same problem.Can you help me out here.Thanks. " |
|
|
|
|
|
Problem with linked server