Post reply

Insert into a table residing on another instance

  • August 28, 2003 at 8:24 am

    #160630

    Hi All,

    A table trigger was created that will insert every new record into a staging table residing in another database instance on the same server. When a record is inserted into the table, the trigger fails to insert it into the staging table. If the staging table is in the same database instance, the trigger works fine. Could someone advise me how to resolve this problem?

    Thank you very much for your inputs!

    Yichang

  • August 28, 2003 at 8:28 am

    #471833

    Do you use four part qualified name, ie instancename.dbname.dbowner.tablename in your trigger?

    You have to setup linked server to the other instance.

  • August 28, 2003 at 10:08 am

    #471850

    Allen,

    Thanks a lot! It works!

    Yichang

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply