July 16, 2009 at 5:30 am
Hi i would like to know how can send mails from my sql server 2005 database.
July 16, 2009 at 7:46 am
You have to configure Database Mail in management studio. It is listed under the Management folder.
Once configured you can use the sp_send_dbmail stored procedure to send email.
See books online on both the above for more details.
July 16, 2009 at 7:49 am
Is Database mail enabled on your SQL server?
If not (http://www.sql-server-performance.com/articles/dba/email_functionality_p1.aspx)
Once enabled:
How to use databasemail
July 16, 2009 at 7:50 am
Another tutorial on enabling db mail:
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply