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.
We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed.
Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…