Using SQL Server usp

CodeCharge Studio

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> ASP

Using SQL Server usp

Author

Message

mljonzs

Posts: 124

Posted: 06/09/2009, 6:59 AM

I am using a SQL Server USP in a DB trigger to handle some things when a table gets updated. Occasionally, depending on data, an email needs to be sent out. The usp uses the msdb.dbo.sp_send_dbmail and works quite well but it give a message

Quote :

Mail queued. (Microsoft OLE DB Provider for SQL Server)

in CodeCharge.

I have the SET NOCOUNT ON in the stored proc but this does not suppress this message.

Does anyone know how to ignore this so it does not get handled by CodeCharge as an error?

Thanks!
MLJ
_________________
What does not begin WITH God, will end in failure!

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home | Search | Members | Register | Login