It seems like the majority don't. But from what I read its likely they're going to be sneaky and hold a referendum after the Commonwealth Games in Glasgow, i.e. capitalise on that sense of national pride. Also they're letting 16/17 year olds vote which is stupid.
Well, the SNP want to be separate. It's not all that clear if the people themselves are overly fond of the idea.
Interesting, what would be the benefits of the 'separation' for Scotland?