"From where did this brilliant notion spring?"
The Independence referendum 2014 and the Devo Max referendum of (IIRC) 1979 are no doubt two of the "three failed attempts". For the third, he could be referring to either Scotland's original independent status which they had to give up after the failure of the Darien Project, or the Jacobite War of 1744-45.