http://www.independence1st.com/content/polls.shtml
not the most up to date opinion poll, but useful nonetheless.
There seems to be healthy support for the referendum. If such a referendum were to take place and the result came back as no, it might mean that the independence/devolution constitutional debate would blow over for a few years like it did after the 1979 poll.
