May 19, 2004 at 6:51 am
I have search all forums on Error 7391 and read all the posts. But i am still having problems canb anyone maybe help. Here is my scenario:-
I have two servers SQL Server 2000 running on a WAN in different domains. On server A I can create a linked server to server B and in QA on server A I can select from tables on server B and I can insert into tables on server B.
However when i write a trigger on a table on server A which does an insert into a table on server B I get a Error 7391.
I have looked at articals on Microsoft KB and read all threads here and tried all they say but with no joy. I am quite new to all of this but aging very quickly today.
Thanks in advance for any help
IP
May 19, 2004 at 10:17 am
DTC needs to running on both servers and the servers need to be able to access each other. Meaning that ServerA has to be in either the DNS host fro ServerB or in the HOSTS file on ServerB and vice versa. I have never used triggers to modify data on linked servers, but I have used stored procedures and this has been my issue.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply