I need to copy a table from one database to another one whenever it is updated. I have a stored procedure to do it but it does not run when the orginal table is updated. How do I trigger it to run on update?
What is the easiest way to tranfer the data upon update? Replication?
you can use replication, but that is more complicated. look at triggers in BOL and start there. If you go the replication route, then you are using triggers with it anyway because replication uses triggers to do it's thing.