Archiving sales orders can error with 'String or binary data would be truncated ...'

Problem

Executing the sales order archiving function errors with this message. Can apply to 7.00.175 and 7.01.00 databases.

SQL skills are required

A working knowledge of SQL Management Studio is required to complete this task

The error is caused when there are sales orders with Email logs which have message bodies greater than 255 characters in length.

Another cause of the error is when the PrintlogID is greater than 20 characters in length.

Download and apply the attached modified stored procedure to correct the issue. The issue has been correct in 7.01.01 under DEV-5934.