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 2008 Forums
 Transact-SQL (2008)
 Resend mail from database log

Author  Topic 

Luuk123
Yak Posting Veteran

52 Posts

Posted - 2013-11-27 : 04:03:55
Hi all,

I'm using database mail. I changed my SMTP password but forgot to change it in the database mail settings. I see in the database-mail-log that all emails since the password change hasn't be sent. Can I resend this emails based on the log?

Thanks!

Prav4u
Starting Member

15 Posts

Posted - 2013-11-27 : 04:16:24
check this blog post
http://www.pertell.com/sqlservings/archive/2012/04/resending-failed-emails-through-sp_send_email/


Praveen D'sa
MCITP - Database Administrator 2008
http://sqlerrors.wordpress.com
Go to Top of Page

Luuk123
Yak Posting Veteran

52 Posts

Posted - 2013-11-27 : 04:55:26
Thanks! It worked.
Go to Top of Page
   

- Advertisement -