xp_sendmail error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

xp_sendmail error

Author

Topic

tran008
Starting Member

38 Posts

Posted - 2004-06-10 : 13:09:01

I get the following error when I try to excute the query below. Anyone encounter this before?

thanks

Server: Msg 18025, Level 16, State 1, Line 0
xp_sendmail: failed with mail error 0x80004005

declare @FileNameLoc varchar(50)

set @FileNameLoc='\\server1\shared\daily_report_'+convert(char(8),getdate(),112)+'.txt'

exec master..xp_sendmail
@recipients='user@email.net',
@subject='Report',
@message='Daily report....',
@attachments=@FileNameLoc

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-06-10 : 13:17:14

I've encountered lots of different errors with SQL Mail. Most of our problems were resolved by installing Outlook 2002/XP on the Win2k server, which is what MS recommended. Other ways to fix the problems are to restart the SQLSERVERAGENT service, reboot the server, or restart SQL Mail with xp_stopmail and xp_startmail.

Tara

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources