TR_APPUSER_UPDATE

                create trigger dbo.TR_APPUSER_UPDATE on dbo.APPUSER after update not for replication
                as begin
                    set nocount on;

                    if update(SITEID) begin
                        declare @ID uniqueidentifier;
                        declare @CHANGEAGENTID uniqueidentifier;

                        declare INSERTED_CURSOR cursor local fast_forward for
                            select
                                ID,
                                CHANGEDBYID
                            from
                                INSERTED;

                        open INSERTED_CURSOR;

                        fetch next from
                            INSERTED_CURSOR
                        into
                            @ID, @CHANGEAGENTID;

                        while @@fetch_status = 0 begin
                            exec dbo.USP_APPUSERSITEBRANCH_UPDATESITES @ID, @CHANGEAGENTID

                            fetch next from
                                INSERTED_CURSOR
                            into
                                @ID,@CHANGEAGENTID;
                        end

                        close INSERTED_CURSOR;
                        deallocate INSERTED_CURSOR;
                    end
                end