• UTF-8 is not supported anymore for SQL Server 2008 (R2?), see http://msdn.microsoft.com/en-us/library/ms188365.aspx and go to CODEPAGE.

    There's more info on the web as to why, but in short that's why it worked on SQL Server 2005 but not 2008 (R2).