See Sammy Larbi's post: http://stackoverflow.com/questions/997628/how-do-i-increase-the-maximum-allowed-attachment-size-for-email-sent-using-msdb

In the Object Explorer frame of SQL Server Management Studio, expand the "Management" folder. Open the Database Mail configuration wizard.

Click Next-> Choose the radio...

Please check this out on step by step instructions on setting a Table Article 'Download-Only'.

https://msdn.microsoft.com/en-us/library/ms151233(v=sql.105).aspx

Regards

You may want to check this article by Aaron Bertrand. He explains various methods to split values in a string separated by delimiter such as #.

http://sqlperformance.com/2012/07/t-sql-queries/split-strings

Also check...

See if the fix suggested by DarrenMB helps to resolve your issue. http://stackoverflow.com/questions/17029073/cannot-connect-to-sql-server-named-instance-from-another-sql-server

-Thanks