Post reply

Help

  • March 25, 2004 at 2:38 pm

    #84057

    I got two servers SERV_A (DATABASE_A -> TABLE_A) AND SERV_B (DATABASE_B -> TABLE_B)

    When i execute DML(INSERT,UPDATE AND DELETE) on TABLE_A that should effect TABLE_B.

    How can i do this, if you have any ideas please help me.

    Note: replication is not an option.

     

  • March 25, 2004 at 2:49 pm

    #500499

    If I understand you correctly you want either triggers or views. Look them up in Books Online.

  • March 25, 2004 at 2:53 pm

    #500500

    Thanks, Trigger worked for me.

  • March 26, 2004 at 5:33 am

    #500618

    You also might consider linked servers.

  • March 26, 2004 at 6:26 am

    #500626

    you must use a trigger

    CREATE TRIGGER tr_ins_tableA

    ON tableA

    FOR insert AS

    --insert into server B; must be linked

    INSERT INTO ServerB.DataBaseB.dbo.tableB

             (col1,

             col2,

             col3,...

             )

             SELECT 

                ins.col1,

                ins.col2,

                ins.col3,...

             FROM inserted ins

Viewing 5 posts - 1 through 4 (of 4 total)

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