Triggers

Hi,

We are making some changes and I'd like to know if this can be done with a trigger.

I have Table1 which is the master table and Table2 which is the history table. Currently we have over 100 places where Table1 is inserted to and deleted from. After that Table2 is dealt with.

The table structures are a bit different and a couple of the columns in Table2 come from stored procedure variables.

What we want it to put a trigger one Table1 to do the insert into Table2 for us. This will fix any chances that Table1 is changed without Table2 being changed also.

Since Table2 has a different structure and 2 columns come from procedure variables, how can I access those variables?

We do not want to go to 100 places and update everything. Also, this does away with the trigger and the tables can become out of sync....

Thanks! Received on Thu Feb 26 2009 - 11:01:50 CST