SQL Mail error

Question

Post reply

SQL Mail error

winiar

SSC Enthusiast

Points: 102
More actions
October 24, 2007 at 3:18 am

#70437

When I run procedure xp_sendmail I'm getting error bellow: (error from job)
Executed as user: dbo. xp_sendmail: failed with operating system error 123 [SQLSTATE 42000] (Error 18024) Associate instruction is not be ready [SQLSTATE HY007] (Error 0) xp_sendmail: failed with operating system error 123 [SQLSTATE 42000] (Error 18024). The step failed.
In Query Analyzer error like:
xp_sendmail: failed with operating system error 123
SO: Windows 2003 Server
DB: SQL Server 2000 SP3
I use Outlook 2003
Any help would be appriciate.
Thanks in advance.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

VaiydeyanathanVS Hall of Fame Points: 3053 More actions · Answer 1

http://www.sqlmag.com/Article/ArticleID/96056/sql_server_96056.html

Lanny Irwan Ten Centuries Points: 1020 More actions · Answer 2

Hi,

Just curious. Are you able to execute xp_sendmail with outlook 2003 before this incident?

Sugesh Kumar One Orange Chip Points: 27311 More actions · Answer 3

If you want to send mails prefer using OLE procedures than using SQL MAIL. the script is available in this site.

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com

Vidhya Sagar SSCrazy Eights Points: 8216 More actions · Answer 4

Refer the below link

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q290058

I think this may help you.

Regards..Vidhya Sagar
SQL-Articles

winiar SSC Enthusiast Points: 102 More actions · Answer 5

Thanks all of you

Problem was file in @attachements argument.

I resolve this problem by write little program in vb.net which is fired in job.

The xp_sendmail procedure sends email (with outlook 2003) with attachements but only when @attachments argument is set null but . In other case attachements is empty 🙁