I'm in favour of it on behalf of Scottish self-governance, and as a Brit from the NW of England I can only imagine that the feeling that the government in London doesn't give a damn about the provinces is far worse than it is where I grew up. However, overall I think it would be a disaster for both countries. Scotland is much more Pro-EU and Anti-Conservative than the rest of Great Britain, so one likely outcome would be a Conservative victory in the next General Election, resulting in Cameron's promised referedum on EU membership going ahead with a likely victory for the anti-EU crowd in the referendum. Given the likely reaction from the rest of the EU to this, I don't imagine this would work out very well for the rest of the UK.
I'm also deeply concerned by the fact that Salmond's default response to any argument as to a potential problem is accuse people of being "wrong", "bullying", or whatever, but has in almost every instance failed to provide a plan for what the SDP will actually *do* to address the point should they be successful in getting a "Yes" vote. I'm really starting to think they have no idea what they are going to do in the event of gaining independance, other than to thrash out a plan in the aftermath of the vote - as if a half-baked plan is going to work for anyone. Finally, even if Scotland gains independance and manages a successful transition to higher GDP and wealth, does anyone *seriously* think that those benefits are going to be distributed where they are needed, and not simply end up in the back pockets of the politicians and business leaders that get to determine how the new nation is going to work?