• I've found that you can do a surprising amount of new stuff in a database with compatibility level 8..

    I say surprisingly because I didn't expect to be able to use any of the new features of 2005.

    I would echo what's been said before that changing the compatibility level from 8 to 9 isn't something you should do without considering the implications. Why was the compatibility 8 to begin with? There may be a\ good reason.