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.
| Author |
Topic |
|
vasu4us
Posting Yak Master
102 Posts |
 Posted - 2006-05-23 : 16:45:35
|
| i am trying to configure a mail acccount on a sql server8.0 to mail alerts at the start/end or failure of a load.i have configured the mail account(distribution group) on the server iam able to send mails but unable to receive mailswhen i try to run a dts package with a task,DECLARE @RowCount int, @msg varchar(255)SET @msg = 'Test start 'EXEC Master.dbo.xp_sendmail @recipients = 'dw@x.net', @message = @msg, @subject = 'start'i get a error msg-Server: Msg 18030, Level 16, State 1, Line 0xp_sendmail: Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default mail client.My mail client is outlook6 and sql ver is 8.0 is it a client problem or do i have to change any settings |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-05-23 : 17:09:40
|
| http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q263556Tara Kizeraka tduggan |
 |
|
|
vasu4us
Posting Yak Master
102 Posts |
Posted - 2006-05-24 : 09:17:20
|
| iam confiused as i said i am using outlook ver6 and in the doc it says microsoft outlook |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-05-24 : 14:29:35
|
| MS recommended to us that we use Outlook 2002/XP version. So try using that instead.Tara Kizeraka tduggan |
|
|
|
|
|
|
xp_sendmail error