Home Forums SQL Server 2014 Administration - SQL Server 2014 Most unhelpful error message? RE: Most unhelpful error message?

  • April 28, 2016 at 12:55 pm

    #1875382

    There's one out there that I've seen since SQL Server 6.5. It reads something like:

    The query failed to process for the following reason(s):

    The operation completed successfully

    The one that drives me the most nuts though is

    String or binary data would be truncated

    SQL knows which column it is but doesn't want to share this info with you. That one drives me the most nuts, especially when it's a really wide table with many columns.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001