August 15, 2008 at 6:58 am
I'm attempting to send email in SQL Server 2005 Express by calling the system stored procedure sp_send_dbmail; however, I get the following error message:
Error 14636, Level 16, State 1, Procedure sp_send_dbmail, Line 95, Message: No global profile is configured. Specify a profile name in the @profile_name parameter.
I don't see an option in SQL Server Management Studio Express for configuring a profile. Can someone please explain to me how to send email in SQL Server 2005 Express.
August 15, 2008 at 7:10 am
Have a look at the following and see if they point you in the right direction...
http://www.mssqltips.com/tip.asp?tip=1100
http://www.databasejournal.com/features/mssql/article.php/3626056
-Luke.
August 15, 2008 at 7:12 am
Scratch that... I just realized you were using Express... According tot he below you can't use database mail with SQL express...
August 15, 2008 at 7:14 am
Thanks, Luke. Is there a work-around or an alternative to using sp_send_dbmail to send email?
August 15, 2008 at 7:27 am
I don't know if this will work with 2005, but there is a custom extended stored procedure called xp_smtp_sendmail available here that worked great in 7.0, 2000. Your other option is to write a CLR procedure for sending mail. That actually shouldn't be that difficult.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 15, 2008 at 7:48 am
Thanks, Jack.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply