I honestly don't think Scotland has the nerve to go it alone...nor do I think it's actually a good idea. All 'marriages' have their ups and downs and now is no different.
What I can see happening for the foreseeable future is that the SNP in Scotland takes a page out of the Parti Quebecois manifesto in Canada. In other words, keep voting for an independence-oriented party, but don't really swallow the whole independence is the way forward mantra. In doing so, Quebec has pulled a lot of power towards itself through concessions, but is smart enough to realise it would be cooked if faced with independence.
A lot of people in Scotland are also fully aware just how bad the post-independence blues and subsequent economic meltdown was in Ireland.
The romantic notion of the nation state loses its way in an increasingly centralised EU.