We set up a stored procedure that does backup, restore, and backup of a user specified database. At the end of the stored procedure, an e-mail is sent back to us that gives the output/results of the backups and restores. Actually, the results are in an attachment (a .txt file).

Here's the problem; The attachment is showing only the first 45 lines of the file and truncates the rest.
But, when we do xp_sendmail to send the file (outside of the stored procedure), it shows the entire file.
And, we ran this stored procedure countless times in a test environment and didn't have the problem. When we moved it to a different server is when the problem started.
Any ideas?

Thanks,
Ben Reeder