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...

The code which worked for me is extremely simple.

ALTER TRIGGER [dbo].[trg_History] ON [dbo].[Amount]

FOR UPDATE

AS

INSERT INTO History

(ID,

Amount1,

Amounttype

)

SELECT

ID,

Amount1,

Amounttype

FROM

deleted

Sean,

I apologize for my previous post. The deleted works perfectly. Thanks you very much.

And thank you Steve..

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...

Hi Gail,

I just want to hold the changes of the row. If the row has no change then I don't want to populate the History table. Thats the reason when...

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...