Replication and Triggers

[jeffmoore64]

Hi,
I need to update the value in a column whenever replication adds data to a table. Here is the situation:
table A is kept up to date via replication. Table B is a copy of of Table A, but has an extra column that is updated via a stored proc.
Question:
Is there some way to tie the execution of the stored Proc. to the replication event? Can this be done via a trigger?
TIA
Jeff

 

[ptheriault]

yes, you would create a trigger on table A to insert/update table B. Look up triggers in BOL.

- Paul
- Database performance looks fine, it must be the Network!