December 22, 2007 at 3:15 am
Hi,
am doing a project with SQL 2005 as backend.my database is in a shared
SQL server. i want to know that is it possible to send email through SQL in a a shared server?Plz help me out.
thanks in advance,
rekha
December 26, 2007 at 7:22 am
Hi,
If the server is configured to use Database mail you can use this stored procedure : sp_send_dbmail
December 27, 2007 at 11:04 pm
hi,
It is not configured to database mail.is their any other options to send mail?
Thanks in advance
regards,
Rekha
December 31, 2007 at 3:42 am
The best option is to configure the server to use DB Mail. DB Mail is easy to set up and is very reliable. With DB Mail, if your outgoing mail server is not available, all messages are automatically queued until they can be sent. SQL also keeps stats on DB mail usage.
Any other way of sending mail is likey to be either harder to set up or be less reliable.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply