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.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 SQL DBMail sending query as email body . . .

Author  Topic 

carriehoff
Starting Member

29 Posts

Posted - 2012-03-29 : 09:59:41
Hi all,

I've written some SQL to send an the results of a query in an email using DBMail. Everything is working great, but in the body of the email, there are about 20,000 dashes preceding the results.

Does anybody know why, and how I can get rid of them.
I assure you, these dashes are not part of the query results.

Thanks,
Carrie

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2012-04-03 : 14:45:47
sounds like you have some sort of looping happening with some left over PRINT statements. please verify

<><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion
Go to Top of Page
   

- Advertisement -