The DB is restore of a SQL2005 version on SQL2008 so schema is same. Still investigating whats wrong. I suspect some server level setting is causing this issue, however, ANSI_PADDING...