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 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy