Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

support TRACK_COLUMNS_UPDATED #1156

Closed
waynebrantley opened this issue Dec 6, 2024 · 1 comment
Closed

support TRACK_COLUMNS_UPDATED #1156

waynebrantley opened this issue Dec 6, 2024 · 1 comment
Labels
enhancement New feature or request Triage: Done

Comments

@waynebrantley
Copy link

Add support for TRACK_COLUMNS_UPDATED.

Currently this is implemented to take the primary key data in the change tracking table and use that to return the 'rows' that change so we can take action on them.

It would be nice to know what columns changed so we can decided if such action is necessary. SQL Server supports this with the TRACK_COLUMNS_UPDATED feature.

Expose this data (if sql server feature is enabled) in the SQL Trigger.

https://learn.microsoft.com/en-us/sql/relational-databases/track-changes/enable-and-disable-change-tracking-sql-server?view=sql-server-ver16#enable-change-tracking-for-a-table

@VasuBhog VasuBhog added enhancement New feature or request Triage: Done labels Dec 10, 2024
@VasuBhog
Copy link
Contributor

Hi @waynebrantley, this is a duplicate of #710. Please upvote and discuss the issue there.

@VasuBhog VasuBhog closed this as not planned Won't fix, can't repro, duplicate, stale Dec 10, 2024
# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
enhancement New feature or request Triage: Done
Projects
None yet
Development

No branches or pull requests

2 participants