|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
November 10th, 2003, 11:45 AM
|
|||
|
|||
|
xp_sendmail not working
i am having trouble testing my sql mail. i set everything up between my exchange client and my mapi settings...i can run the test connection in sql server 7, but when i write the test query to send an email message, the query analyzer says that it is executing the query...but never stops. any help would be appreciated. here's the query i'm using.
xp_sendmail @recipient = 'aliaga61@earthlink.net', @message = 'test'
|
|
#2
November 18th, 2003, 08:45 PM
|
|||
|
|||
|
Did you try calling xp_startmail just in case a mail session for the SQL Server service account isn't already running?
If you're using Windows 2000, XP si .Net don't come with a MAPI profile installed like Windows NT 4. So you have to intall localy Exchange Server, Outlook (not Outlook Express) or other messaging system witch install a MAPI profile, in order to enable SQL Server to send emails.
|
|
| Viewing: ASP Free Forums > Database > Microsoft SQL Server > xp_sendmail not working |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
