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 |
|
juicyapple
Posting Yak Master
176 Posts |
 Posted - 2008-05-14 : 09:59:26
|
| I have a store procedure which runs below code. It is working fine for few months until today, all the email cannot be sent out. No idea what is happening as no error message returned. Please help.exec master..xp_sendmail @recipients='xx.xx@xx.com',@subject='Testing',@message='Testing12345' |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-14 : 10:09:47
|
| Is your server 2000 or 2005? |
 |
|
|
juicyapple
Posting Yak Master
176 Posts |
Posted - 2008-05-14 : 10:15:04
|
quote:
Originally posted by visakh16
Is your server 2000 or 2005?
tested on both also not working...tried at query analyzer, get status '..completed successfully', but can't get any email |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-14 : 12:07:50
|
| Have you changed any settings with your mail profile recently? |
|
|
|
juicyapple
Posting Yak Master
176 Posts |
Posted - 2008-06-03 : 20:32:08
|
quote:
Originally posted by visakh16
Have you changed any settings with your mail profile recently?
Problem solved. Found that hardware and network side has change the exchange server. I have to do changes on the setting in sql server side. |
|
|
|
|
|
|
xp_sendmail problem