I wish I could do that but I was ordered by the management and the senior DBA to have a post deployment script in place.Any work arounds? or non recommended...
I used the inserted and deleted but the inserted row always has the new values rather than the old value. Not sure what I am doing wrong. It can't be...
Thanks for your reply. I was trying to work with what to told and I still have the same problem. The trigger works but the row insertion is done after...