-
e-mail attachment sent by stored procedure truncated
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|