The major problem up here for Scots wishing to keep the UK together, is that at the time of the Independence Referendum the EU and the UK Government put out the same message, namely - the only way for Scotland to stay in the EU would be to vote No to independence. That position swayed a lot of people worried about the possible economic consequences.
Last Thursday, what all the politicians thought unthinkable happened, and now the consequence of having voted No is that we are being dragged out of the EU anyway. You could hardly make it up!
If Indyref2 should come along, the only thing that will stop a Yes vote will be the prospect of continuing low to zero revenue from the North Sea, and the colossal current account deficit Scotland would therefore face. Mind you, the likelihood of a completely buggered up economy didn't stop England and Wales voting for "Independence" from Europe.
Much as I would like to see them, I wouldn't hold your breath about P8 being seen on the Moray Firth any time soon, and the Government wont decide on anything at all (P8, HS2, Heathrow runway) until they sort out the developing chaos.