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)
 Configuring SQL Mail to NOT return results

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-04-09 : 22:49:25
Michael writes "I need to configure SQL Mail (or, rather, the parameters of sp_processmail or maybe even rewrite that procedure) to execute my quereies--which are all actually updates to a single table--and then NOT send any result. In effect these would be blind updates to the database. We're trying to allow our old vax-based financial system to do this updating (adding or deleting a single record) via smtp mail, but often the 'sender' has an invalid mail address which causes the process to fail.

Any help is appreciated."
   

- Advertisement -