sp_send_dbmail: Failing When Adding Attachment
After fighting with this for half a day I took SQL out of the equation and tried to perform the same task using Power Shell. This also failed, my network guy ran a PCAP between SQL and relay server and we have identified the issue.
File was getting to the relay server but for whatever reason on that particular SQL server (AWS) by the time the file made it to relay the file was fragmented, wasn't sending the full file.
This SQL box was built before my time by someone who 'DID' SQL, it has several setup and config issues so I am pushing for a rebuild.