Hi I am new to sql sever 2012. I have problem in sending email from the SSMS or from writing script. currently i have window 7 and sql server 2012. i have followed the instructions to enable the database mail and created a mail profile also. when i tested it. the email did not send out, but it is in MSDB mail tables. I think that I did not use the correct SERVER NAME for the smtp when i created the database mail account. Could anyone please tell me what did I miss and what are the logical steps that i need to do to make the send mail feature work in sql server 2012? I am doing this for personal use and learning. I try to write stored procedure to send out email from sql server to all the tenants. Before i can make i t works I need to be able test the send email from the Database Mail. what server name i need to use when i create the database email account? I really appreciate you step in to help. thanks
Thank you I will take a look later. I did try to add SMTP from window, but i could not find the component from the list of features. hope the link above will point to the location get it. i will update you later when i have a chance to work on it. thanks for your time and advices.