Getting More Information From the String or Binary Data Truncated Error

Question

Getting More Information From the String or Binary Data Truncated Error

jonfrisbee

SSC-Addicted

Points: 445
More actions
August 17, 2022 at 12:00 am

#4077153

Comments posted to this topic are about the item Getting More Information From the String or Binary Data Truncated Error

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Keith Foster SSC Rookie Points: 30 More actions · Answer 1

Hi Jon, Thanks for posting, this is wonderful news! Like you I have been frustrated by this error message for years! I have one question, running Sql 2017, do you have to set that dbcc option every time you run or just the once for the server?

jonfrisbee SSC-Addicted Points: 445 More actions · Answer 2

Glad you liked this article.

You can either set the trace flag at a session level, or you can set this for the instance. This article from Simple Talk helped me: https://www.red-gate.com/simple-talk/databases/sql-server/learn/how-to-enable-sql-server-trace-flags/