The Multifunctioning DBA

May 25 2011   10:44PM GMT

SQL Mail issue Update

Colin Smith Colin Smith Profile: Colin Smith

Thanks to Twitter I have had a lot of help with the SQL Mail issue that I am having. Unfortunatly I still have not been able to resolve the issue at this time and I am still waiting on hold for MS to help me out with the main issue that is Outlook will not correctly set up the mail profile for some reason and continues to crash. I did however get some good advice from @sqlsoldier and @sqlconcepts. I had mentioned just doing away with SQL Mail and using database mail instead.. This way I do not care about outlook and the mail profile. My issue was that the DTS packages are using a send mail function and DTS does not support DB Mail. They had the idea of replacing all those send mail functions with a t-sql script and call sp_send_dbmai. I have not yet been able to talk to the app devs about this but it seems to me like this is the way to go.

This is yet again more proof on how AWESOME the SQL community is and how Twitter can be very helpful.

Thanks everyone for your help and if MS ever gets on the phone I will still let you know what they say and if they resolve my issue.

 Comment on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: