database trigger on delete RRS feed

  • Question

  • Hello,

    Today we saw that some rows got deleted in our Dataware House. Normally rows are never deleted, they are just marked as deleted because we want to keep the history. Now there are two important questions :

    How can we detect who or what deleted this rows ?

    How can we prevent that they are being deleted ?

    We have around 450 tables and I think around 250 ETL packages.

    Constantijn Enders

    Friday, March 8, 2013 10:08 AM


All replies