• I remember having a lot of problems when the default collation changed from 2005 to 2008.

    Many of them were solved by using COLLATE DATABASE_DEFAULT. Just a hint, not more 😉