Great article, many thanks.

A little background: I am BI developer on top of a sap installation (160 gb+) database.

I do MS SQL 2005 for replication of the live database (Source), which gives me a mirror I can query the live out of.

For a lot of tables, I do not have a flag saying when f.ex. customer basic data was updated last. This means that if I wish to do incremental updates to my datawarehouse, I need to use a tool that compares every column in every row with what is in the DW.

This can get quite heavy on the system.

THEREfore I would like to ask.

Can I by manipulating the Mirror DB Customer Table with a new column f.ex DateOfLastDataChange and creating a trigger writing getdate() on insert/Updates, get a date for when the row was last manipulated?

When I read the article it is about changing an existing column, not creating new ones. This is a problem for me, since I do not have access to our source system which is hosted out-house.

Please advise, or give me more articles to read... by the way, love the site.

best regards

David