There's absolutely no way the Spanish would allow Scotland to join the EU.
A friend of mine, somewhat cynically (and also joking), quipped that the fastest way to take Scottish independence off the agenda would be for England to hold a referendum on whether we still wanted them to be part of...