TR_SITE_UPDATED (Trigger)

 
                create trigger dbo.TR_SITE_UPDATED on dbo.SITE after update not for replication
                as
                begin
                    if 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;