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 |
|
Bex
Aged Yak Warrior
580 Posts |
 Posted - 2005-03-11 : 05:20:25
|
| I was experimenting with ways to send emails to myself (using xp_sendmail)in the event of invalid data being entered into a database. However, during this experimentation, a colleague accidently processed a live file (consisting of thousands of records) in the test area. I proceeded to receive hundreds of email alerts....ooooops! Since this has happened, if I try to use xp_sendmail, it doesn't seem to do anything, just goes on and on and on and on.....you get my drift! Can anyone tell me what I have done or what I can do to rectify the situation??? Thanks in advanceHearty head pats |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-03-11 : 05:28:11
|
| recycle the mail session by issuing a xp_stopmail followed by an xp_startmail.See if this fixes your xp_sendmail issue.-ec |
 |
|
|
Bex
Aged Yak Warrior
580 Posts |
Posted - 2005-03-11 : 06:48:43
|
| HiyaThanks for you response. Unfortunately, it has not seemed to have made a difference. Before, the mail would be sent instantly, but now, it just goes on and on and when I try and close the query, it freezes QA. Could it be the mailbox is full due to my bungle with the error mails as I did not issue the xp_deletemail command in the sproc? If so, how can you empty the mail box (if this is a possible cause)?Hearty head pats |
|
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-03-11 : 10:03:57
|
| I haven't used xp_sendmail before, but have you tried restarting the SQL services? |
|
|
|
Bex
Aged Yak Warrior
580 Posts |
Posted - 2005-03-11 : 10:56:47
|
| Erm, I am not sure. This may sound really dumb, but what does that involve?Hearty head pats |
|
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-03-11 : 10:59:49
|
| Just have the server admin pull up the server services and restart the MS SQL Server and SQL Server Agent services. It does not require a restart of the server itself, but will interrupt access to the SQL server instance. |
|
|
|
Bex
Aged Yak Warrior
580 Posts |
Posted - 2005-03-11 : 11:05:11
|
| Oooh, ok. I shall give it a go! Thanks for the advice!Hearty head pats |
|
|
|
|
|
|
|
|
SQL Mail - No longer can use