columnsToMonitorDuringUpdate ability to know which columns were updated

Oct 4, 2016 at 8:48 AM
Is there a way to know exactly which fields were updated when getting a notification event ?
In my situation, I'm monitoring a lot of fields, but using columnsToMonitorDuringUpdate will only tell me that one/several fields have been updated, but not which ones.

according to trigger declaration, I don't think it's possible now as it would requires to send more "metadata"
Oct 4, 2016 at 6:08 PM
Oct 6, 2016 at 10:22 AM

Thanks for the answer, however it won't help because I need to monitor all of them :)
I will double check if I can live without this information or if I have to switch to Change Data Capture or Change tracking. But I kind of like the stateless/push way of sql broker :)

thanks again.