you just need the char(10) for a newline !
(I use this all the time)

declare @CoverUp varchar(16)

select @CoverUp = ['True'|'False'] --> make your choice

if CoverUp = 'True'

...

My advice is to dump maintenance plans.

The two word solution is - Ola Hallengren

https://ola.hallengren.com/

I just 'dare' to be 'dull' !

As a DBA we are kind of the last line of defense unfortunately.

All of the issues that happen, especially as of late (subscribe to Krebs on Security) are usually not...

Try this:

declare@max_attachment_sizeint,-- in bytes

@average_rowsizeint,-- in bytes

@number_of_rowsint,-- used for the TOP in the dynamic select

@dynamic_selectvarchar(8000)-- dynamic select statement

select @max_attachment_size=paramvalue

from msdb.dbo.sysmail_configuration

where paramname = 'MaxFileSize'

select@average_rowsize=used_page_count*1024/row_count

from sys.dm_db_partition_stats

where object_id=object_id('sysmaintplan_log')

select @number_of_rows=@max_attachment_size/@average_rowsize

IF EXISTS(SELECT TOP 1 1 FROM...

you'll need to up the attachment size in your database main configuration.

exec msdb.dbo.sysmail_configure_sp 'MaxFileSize', '10000000'

I would start looking here first: procname=SCHApiOrder.SCHOrder.SCHOrdersSave_v3 line=198

Next I would change your table variable, @ReturnOrders_TEMP_TABLE, to a real #temp_table.

I am curious about "insufficient buffer memory" ...

My advice is to contact the source provider of the EDI file - plain and simple.