TR_SITE_UPDATED (Trigger)

                
                    create trigger [dbo].[TR_SITE_UPDATED] on [dbo].[SITE] after update not for replication
                    as
                    begin
                        -- Do not run if no records were updated

                        if (select count(*) from INSERTED) > 0 and update(HIERARCHYPATH)
                        begin
                            declare @CHANGEAGENTID uniqueidentifier
                            select top 1 @CHANGEAGENTID = CHANGEDBYID from INSERTED;
                            
                            declare @CONTEXTCACHE varbinary(128) = CONTEXT_INFO()
                            set CONTEXT_INFO @CHANGEAGENTID;
                        
                            delete from dbo.SITEPERMISSION
                        
                            if @CONTEXTCACHE is not null begin
                                set CONTEXT_INFO @CONTEXTCACHE
                            end;
                    
                            exec dbo.USP_SITEPERMISSION_UPDATEPERMISSIONS
                            exec dbo.USP_APPUSERSITEBRANCH_UPDATESITES null, @CHANGEAGENTID
                        end
                    end;