August 29, 2017 at 3:50 pm
If a database table does not have a last modified date time column is there a way to determine when that column was last updated or inserted into a table? I want to run an ETL against a table and only extract records that are recently changed or inserted.
I've heard auditing is an option. Doesn't that cause a performance hit?
Thanks for any constructive feedback.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
August 29, 2017 at 4:19 pm
No, not without a modified column, and that must have a default of GetDate() or SysDateTime() or a trigger.
August 30, 2017 at 5:39 am
Joe Torre - Tuesday, August 29, 2017 4:19 PMNo, not without a modified column, and that must have a default of GetDate() or SysDateTime() or a trigger.
There's more to it than just adding a date column with a default, as I am sure you know.
Change Tracking may be worth investigating.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply