You need to set up a mail profile for the SQL server service account. You
can find information on how to do this by looking up SQL Mail in the Books
Online. You then need to start the mail services and make sure SQL can
start and stop the mail service. There are a couple bugs you should be
1. Use the Client Network Utility to make sure the default network library
is set to Named Pipes. If not you will get an unable to log on to SQL
server error when you use xp_sendmail.
2. If you want to use sp_processmail to have SQL process incoming email
queries, you have to manually edit the sp_processmail procedure. The
need to change those to varchar(128).
> A couple of thoughts:
> (1) Do you have a mail client configured on the server? In other words,
> you log on to the SQL server machine and send mail from there?
> If you can't, that's the place to start.
> (2) Did you get any error messages from xp_sendmail?
> > Hi Gurus,
> > May I know how to configure my store procedure in SQL Server to send
> > e-mail ? I tried to click on the property and can't find any parameter
> > or codings that I can refer.
> > To add on, I tried this in SQL Query Analyser in the following syntax.
> > exec master.dbo.xp_sendmail
> > I didn't receive any e-mail in my account.
> > Please advise on what I should configure other than calling this
> > procedure.
> > Could you please shed some lights on me ?
> > Thanks in advance.
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.