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.
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …