TR_SITE_UPDATED

Trigger Definition

				
					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;