The chief executive of Scottish Rugby has been sacked with immediate effect following an investigation into his conduct.