Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
trigger insert into a linked server
I've got the answer!!! Here it is : I marked the option : "Apply distributed transactions" in "Connexions" in the properties of both servers in Entreprise Manager. Then I addes "SET XACT_ABORT ON" at the beginning of my trigger my trigger : Code: CREATE TRIGGER [triggeressai] ON...- shabata
- Post #2
- Forum: Microsoft SQL Server: Setup and Administration
-
trigger insert into a linked server
Hi guys! This is my first thread on tek-tips.com, and I'm from France...excuse my english. I work with two linked servers (say A and B). From a table T1 of A I have set up a trigger insert which launch an insert on a table T2 of B. But it doesn't work. Error is ole/db provider returned...- shabata
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Setup and Administration
