TR_SITE_INSERTED (Trigger)

 
                create trigger dbo.TR_SITE_INSERTED on dbo.SITE after insert not for replication
                as
                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;