Copy Code Trigger Definition 

                
                    create trigger dbo.TR_SYSTEMROLEAPPUSERSITE_INSERTED on dbo.SYSTEMROLEAPPUSERSITE after insert not for replication
                    as
                    begin
                        delete from dbo.SITEPERMISSION from INSERTED where INSERTED.SYSTEMROLEAPPUSERID = SITEPERMISSION.SYSTEMROLEAPPUSERID
                        exec dbo.USP_SITEPERMISSION_UPDATEPERMISSIONS
                    end