Win Surprise Gifts!!!
Top 5 Contributors of the Month
Post New Question
Subscribe to Forum
Can I Send mail using SQL Server
February 12, 2011
I need to send mail using SQL server. Can i do that. What SQL statement i need to write to send email using database.
Thanks In Advance
Posted Date: February 12, 2011 Points: 10
Yes. you can send Mail through SQL Server.
you have two ways..
1. SQL Mail (Using MAPI)
2. Database Mail (Using SMTP)
Database Mill is the replacement of SQL Mail. From SQL server 2005 onwards Database Mail is recommended one instead of SQL Mail.
Try to proceed with Database Mail..
1. You have to configure the Database Mail(Management --> Database Mail --> right click...)
2. Restart the SQL Server Agent Service as It take effect.
3. Define the Mail profile and an account for that profile.
4. Choose the profile you want to set as default in SQL Server Agent Service.
5. Use "sp_send_dbmail" to send mail through Database Mail...
If not I then who, If not now then when
Posted Date: February 13, 2011 Points: 5
Thanks a lot Pandian..
Posted Date: February 28, 2011 Points: 20
Yes you can
You can use SQL mail under management node to send the mail.
Hope this helps.
To post reply
Related Questions Related Questions
How do I send E-mail via the Microsoft exchange server?
How to Send Mail Asynchronously in asp.net
how to send e-mail from site to admin
Display InBox Image on Server Computer when Client Send Message to Server in VB.NET
Automatic Mail Send on Scheduled Date time in Asp.net
Send Mail Promting throw out-look
How to identify a mail which is sent from c#.net is send, bounce and open by the receipent?
Sending a mail from sql server
Latest Forum Questions From The Same Category
Help to get SQL output
how to restore my sql database from my hosting provider?
SQL query to update date range
Add allowance to employee table is wrong or true according to my case
how to remove trailing zeroes in a decimal in sql server
Required Union All Result in two different column
Sql Multiple table data retrival
Table Translation records
How select huge Data from sql without take long time?
Passing using parameter in store procedure get the top3 record from the table
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more
Quick Links For Forum Categories:
Hall of Fame
Terms of Service
Tell A Friend