TR_SYSTEMROLEAPPUSERSITE_UPDATED (Trigger)

                
                    CREATE trigger dbo.TR_SYSTEMROLEAPPUSERSITE_UPDATED on dbo.SYSTEMROLEAPPUSERSITE after update not for replication
                    as
                    begin
                        if exists (select top 1 1 from INSERTED)
                        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 from INSERTED where INSERTED.SYSTEMROLEAPPUSERID = SITEPERMISSION.SYSTEMROLEAPPUSERID

                            if @CONTEXTCACHE is not null begin
                                set CONTEXT_INFO @CONTEXTCACHE
                            end;
                        end

                        exec dbo.USP_SITEPERMISSION_UPDATEPERMISSIONS
                    end