Hi SQL Gurus
I need to capture changes in SQL Source tables.
Design approach is - put triggers on all of them and any change, create a corresponding message in SSB Queue.
Further application is polling this queue to process the message and fire a SQL Stored proc to get the underlying table data.
Issue is say table has 50 columns that falls in various sections of a CUSTOMER (say) I just need to process those details that changed rather than complete row. Is there a way of knowing what was the change exactly?