columnsToMonitorDuringUpdate ability to know which columns were updated

Oct 4, 2016 at 7: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"
https://tabledependency.codeplex.com/wikipage?title=SqlTableDependency%20Constructor
Coordinator
Oct 4, 2016 at 5:08 PM
Oct 6, 2016 at 9:22 AM
Hi,

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.