I have a table that is now date sensitive, but was not before.
most of my tables have a column that identifies when the record was added or inserted into the table.
My problem is this.
this table is generated by an application that i have no access to as far as how it populates a table.
is there a way for me to add a column to a table that auto senses when the add takes place and populates a "dateadded" column automatically.
i also have to make sure that this new column doesn't effect the application in anyway.
obviously this solution would not be retroactive and i am ok with that.