Copy Code Trigger Definition

                
                    CREATE trigger TR_INTERACTIONSITE_T2BDELETE on dbo.INTERACTIONSITE after delete not for replication
                    as 
                    begin
                        -- TAIntegration data sync

                        if dbo.UFN_B2T_CONTEXTISSYNC() = 1
                            update 
                                dbo.B2TROWS
                            set 
                                SYNCSTATUSCODE = 11
                            where 
                                BBECID in(select ID from DELETED)
                                and BBECTABLE = 'INTERACTIONSITE'
                    end