Forum Discussion

Jaipal385's avatar
Jaipal385
Copper Contributor
Dec 25, 2023

trigger between 2 databases

Hi, community, I am trying to create a trigger between 2 different databases on one server.    Query:   CREATE TRIGGER insert_into_pipelines ON [test_1].[dbo].[ag] AFTER INSERT AS BEGIN INS...
Arshad440's avatar
Arshad440
Copper Contributor
Dec 26, 2023

Hi Jaipal385 

I would like to know, In which Database you are using to create Trigger?

test1 or test2?

  • Jaipal385's avatar
    Jaipal385
    Copper Contributor
    Dec 26, 2023
    Arshad440
    Creating a trigger in Table_1 as the original data is loading in Table_1. In my question, I have mentioned creating in Table_2.

    So creating a trigger in Table_2 if there is any new pipelin in Table_1, load that in Table_2.

    Cheers..!

Resources