January 11, 2017 at 6:28 am
Is there a way to impliment sql server change tracking on only a handful of columns in a table as opposed to the whole table
January 11, 2017 at 7:31 am
No, but you can
[font="Courier New"]ENABLE CHANGE_TRACKING
WITH (TRACK_COLUMNS_UPDATED = ON)[/font]
so that column-level changes are tracked, and then use [font="Courier New"]CHANGE_TRACKING_IS_COLUMN_IN_MASK[/font] to identify the columns that were changed.
January 11, 2017 at 9:05 am
is there a wat to get the value of the data change?
January 11, 2017 at 9:12 am
Would a trigger work?
January 11, 2017 at 11:09 am
i suppose it will have to
January 11, 2017 at 1:48 pm
unless i'm missing something it appears "change data capture" would do what i need. We're going to be building this in sql server 2016
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply