Whilst changing the SET options will fix your issue for the time being, you really should always have the ANSI options set because they're required for things such as indexed views, indices on computed columns, etc to be set. Also, some client-side libraries will issue SET options themselves which turn on the ANSI defaults. Fix your table structure or, if you're happy with the truncation, explicitly put the truncation in there using SUBSTRING or LEFT.