TR_SYSTEMROLEAPPUSER_UPDATED (Trigger)

                
                    CREATE trigger dbo.TR_SYSTEMROLEAPPUSER_UPDATED on dbo.SYSTEMROLEAPPUSER after update not for replication
                    as
                    begin
                        if update(SECURITYMODECODE) or update(BRANCHSITEID) or update(APPUSERID) begin
                            delete from dbo.SITEPERMISSION from INSERTED where SITEPERMISSION.SYSTEMROLEAPPUSERID = INSERTED.ID
                            exec dbo.USP_SITEPERMISSION_UPDATEPERMISSIONS
                        end
                    end