Post reply

Query behaving differently on different servers.

  • February 27, 2009 at 12:51 pm

    #128099

    I've got a database backup I've restored on several SQL 2005 DEV servers and am running the attached query on them.

    For some it works, for some the query pukes and says:

    Msg 8152, Level 16, State 13, Line 1

    String or binary data would be truncated.

    The statement has been terminated.

    There has got to be something stupid that I'm missing. Anyone have any suggestions?

    The Age field is an INT, and FOLIO2 is CHAR(1).

    Thanks,

    The Redneck DBA

  • March 3, 2009 at 10:12 am

    #952557

    Finally figured it out. There was a database trigger involved that was causing it.

    The Redneck DBA

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

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