Home Forums SQL Server 2008 Data Corruption (SS2K8 / SS2K8 R2) String or binary data would be truncated. Error when inserting empty table results into TEMP table RE: String or binary data would be truncated. Error when inserting empty table results into TEMP table

  • November 19, 2013 at 4:43 am

    #1667355

    It might be possible that there are rows with length > 15 selected early on in the query plan which are filtered out later.

    If you change the query, the query plan might change as well and in some part of the plan the maximum length is violated.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP