I have a customer master table that includes a field for territory that I need to know when it changes.
I was looking at a job or a trigger (for realtime results) that I could create that would write a record to a table whenever the territory field was changed.
As a job that I would run nightly I can match the customer master accounts in the "Customer Master" table to a "Master Changes" table and if the territories don't match write a new entry with the new territory into the "Master Changes" table. While this would work it only updates every 24 hours or whenever it is run.
Is it possible to create a trigger to do the same in order to acheive near realtime results? If so what might it look like?