How to send email using trigger. When new Data is inserted?

Accepted answer

It is a system procedure which is located in msdb database.

If you wana have a look into procedure than go to query window and select msdb DB and type sp_helptext sp_send_dbmail.

Hope it will help you

While implementing

Profile Name is Not Valid ?

How to fix this issue? Please help me.

Thank You Sir.

You have given link thats allright but one store procedure i'm not able to undertand.

see the link :

https://stackoverflow.com/questions/10755469/send-e-mail-from-a-trigger

What is the code of this store procedure name. Please help me as soon as possible?

EXEC msdb.dbo.sp_send_dbmail

Hello Ansari,

Please have look on below links. It might be helpful for you

https://stackoverflow.com/questions/10755469/send-e-mail-from-a-trigger?utm_medium=organic&utm_source=google_rich_qa&utm_campaign=google_rich_qa

https://www.codeproject.com/Questions/308591/Send-an-email-from-SQL-Server-Trigger

https://www.experts-exchange.com/questions/28399463/SQL-trigger-to-send-an-email-to-a-person-after-an-update.html