Very Computer

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.

Could you please shed some lights on me ?

Thanks in advance.

Sent via Deja.com http://www.deja.com/
Before you buy.

Sorry ...

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.

Thanks again.

Quote:> 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.

> Could you please shed some lights on me ?

> Thanks in advance.

> Sent via Deja.com http://www.deja.com/
> Before you buy.

--
Visit http://winhorse.hypermart.net for more horse racing tips !

Sent via Deja.com http://www.deja.com/
Before you buy.

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.

A couple of thoughts:
(1) Do you have a mail client configured on the server? In other words, can
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?

--Charles

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
aware of:
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).

Good luck,
jaime

Winhorse --

Have you configured an Outlook profile for SQL Server to use?  Or will it
be using your profile?  Use Control Panel / Mail to build a profile named
"SQLServer".  You can test it by entering "outlook /profiles" at a
command prompt, choosing your new profile name, and sending yourself a
message.  If that works, SQL Mail should work.

In SQL Enterprise Manager, right-click on the mail icon and enter the
name of the profile there.  (You'll probably want to tell SQL Executive
to automatically start SQL Mail and enter the profile name there, as
well.)

Then...
        exec master..xp_startmail 'SQLServer'
should respond with
        The command(s) completed successfully.

Followed by

should respond with
        Mail sent.

--
Paul Beda
There is no x in my address...

Hi ,

Thanks for your suggestion. I tried to start SQL Mail and I got

Error 22030: A MAPI error (error number 273 occurred. MapiLogonEx
Failed due to MAPI error 273: MAPI Logon failed

Sent via Deja.com http://www.deja.com/
Before you buy.

Log into the SQL Server machine using the same NT account as the MSSQLServer
service is using. Create the mail profile using that account. You cannot use
LocalSystem.

--
Tibor Karaszi
MCDBA, MCSE, MCSD, MCT, SQL Server MVP
Cornerstone Sweden AB
Please reply to the newsgroup only, not by email.

Quote:> Hi ,

> Thanks for your suggestion. I tried to start SQL Mail and I got

> Error 22030: A MAPI error (error number 273 occurred. MapiLogonEx
> Failed due to MAPI error 273: MAPI Logon failed

> Sent via Deja.com http://www.deja.com/
> Before you buy.