TR_SYSTEMROLEAPPUSERSITE_UPDATED

Trigger Definition

				
					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