TR_APPUSER_INSERT

                create trigger dbo.TR_APPUSER_INSERT on dbo.APPUSER after insert not for replication
                as begin
                    set nocount on;

                    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