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 2000 Forums
 SQL Server Development (2000)
 SQL Mail

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-11-15 : 10:06:32
scott writes "I am trying to use SQL Mail on a SQL Server 7.0/WINNT box to send out emails confirming that a customer order has been received. Using xp_sendmail, I can get a message to generate. Now I want to include the order information along with this message, so I am also using the @query parameter. However, the text of my messages now includes the text of the query that I am submitting with the xp_sendmail procedure. I can't find a way to suppress this and I can't even find an example of this happening to anyone else. All sample emails I've seen generated with xp_sendmail do not have this problem. Is there anyway to suppress the query text?"
   

- Advertisement -