Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2004

    Unanswered: Linked Servers and Triggers

    I have two servers one on SQL Server 2000 one on SQL Server 7
    I have setup the two servers so that they are linked and have added appropriate logins.
    How it works is a record is inserted into a database on SQL 2000 which has a trigger on it that send the record to a stored procedure on the SQL 7 server, from there this places the record into a table, which calls a trigger. Now this all works fine when I use the query analyser however when I don't use it, the record does not get inserted anywhere. Now I have stepped through it and it works up until the last trigger, if I remove that everything works fine. However the code in this trigger works fine, as when I use the quuery analyser everything works just as it should.

    Does anyone have any suggestions as to how I can get this to work?

    Thanks :-)

  2. #2
    Join Date
    Oct 2003
    Look into heterogenous queries in BOL.

  3. #3
    Join Date
    Jul 2003
    San Antonio, TX
    Make sure the last trigger is compiled using requirements of heterogeneous queries.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts