The chief executive of Scottish Rugby has been sacked after what is understood to be an inappropriate, undisclosed relationship with a junior employee came to light.