Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
n/a
deleted
35 Posts |
 Posted - 2004-07-22 : 12:01:53
|
| I am working on an automated TSQL script to send issues to a bank. I am using xp_Sendmail and attaching the results of the query. This is a Stored Procedure that will run nightly. The attachement that is being sent with the email contains hidden characters. Before each letter, or space, in the file there is a "null character" (this shows up as &0 on the UNIX system at the bank). If I run the query in Query Anaylzer and copy/paste the results into notepad I do not get the hidden characters. I only get the hidden characters if I use the xp_sendmail to attach the results.Does anyone have any clue on how to attach the results without the hidden characters?TIAPaul |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2004-07-23 : 00:25:12
|
| Perhaps if you post the query and some data and table structures then somebody could have a better chance at helping you solve the problem.Duane. |
 |
|
|
|
|
|
SendMail - Attached Results