Hi Jeff,

Please guide me in re writing the trigger for two scenarios which you have advised ... I'm very much interested in doing

That ... I have given the details...

Hi Jeff,

1 . ChangeDate (datetime2(3), not null)

2. ChangeUserId (Varchar(12), not null)...

Hi Jeff,

The first columns in the audit table are

ChangeDate (datetime2(3), not null)...

Hi Jeff Moden,

I am sorry for the late reply, I ran into some issues.

Thanks very much for your detailed explanation !!! Didn't expect this much clarity in explanation 🙂

I...

Hi Eirikur Eiriksson,

Thanks Very much for the clear explanation !!! Couldn't have asked for more 🙂

Hi Jeff,

Thanks verymuch for your suggestion. As you said I found the separate triggers...