TR_AUDITS_DELETE

            CREATE TRIGGER [dbo].[TR_AUDITS_DELETE] ON [dbo].[AUDITS] AFTER DELETE 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,
                    '1'

                FROM DELETED