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!

Search results for query: *

  1. shabata

    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...
  2. shabata

    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...

Part and Inventory Search

Back
Top