TR_AUDITS_UPDATE

            CREATE TRIGGER [dbo].[TR_AUDITS_UPDATE] ON [dbo].[AUDITS] AFTER UPDATE NOT FOR REPLICATION
            AS 

            set nocount on

                INSERT INTO dbo.AuditsLog(
                    [AuditsID],
                    [ClientUsersID], 
                    [AuditDate],
                    [AuditCodesID],
                    [ObjectGuid], 
                    [ObjectTypesID],
                    [Action]
                ) 
                SELECT 
                    ID,
                    ClientUsersID,
                    AuditDate,
                    AuditCodesID,
                    ObjectGuid,
                    ObjectTypesID,
                    '2a'
                FROM DELETED

                INSERT INTO dbo.AuditsLog(
                    [AuditsID],
                    [ClientUsersID], 
                    [AuditDate],
                    [AuditCodesID],
                    [ObjectGuid], 
                    [ObjectTypesID],
                    [Action]
                ) 
                SELECT 
                    ID,
                    ClientUsersID,
                    AuditDate,
                    AuditCodesID,
                    ObjectGuid,
                    ObjectTypesID,
                    '2b'

                    FROM INSERTED