How to build a Service Broker Endpoint

Hi

first of all I should say I don't know anything about

Serviec Broker

I just want to use the SP_Send_dbmail stored procedure

to send an email from SQL Server instance to an email address for example <aa@.yahoo.com>

in the Surface Area Configuration I faced a message indicating there is no Service Broker endpoint for this inctance.

please tell me step by step and in detail what to do to be able to send an email from SQL Server and please try not to confuse me.

thanks.

pooyan.

A Service Broker endpoint is not necessary for using Database Mail. If you have sent mails using sp_send_dbmail and aren't receiving any e-mail messages, then connect to your database and look at the following view:

select * from sys.transmission_queue;

Does this report any messages pending to be delivered?

Rushi

|||

Hi

As you said I executed select * from sys.transmission_queue.

but there was no result set.

what's the problem? can it be because of security limitations? Because I can't execute

sp_send_dbmail stored proc in any database except msdb .

please tell me what to do.

thanks.

pooyan.

|||

sp_send_dbmail only exists in msdb.

Do you see errors in select * from sysmail_log?