SQL | How to send Email from SQL Server ? Database Notifications

preview_player
Показать описание
In this SQL Tutorial, we write SQL statements to send a database notification email through SQL Server.

If you need to configure your gmail id for the database notifications, then you will need to create an App Specific password in Gmail and use that password in the SQL Server. Please follow below steps to create the App Specific password.

Go to Gmail account settings , and click on security tab
Add 2 step verification (if you don't have)
Click on "App Password"
Select application device or add new one (Select 'Other' when it askes you to select an app you want to connect to, then enter in whatever name you want to give the app and generate a
new password.)
You will get new password to use in your app

Must Do Data Analytics Certifications -

Google Data Analytics Professional Certificate

Google Advanced Data Analytics Professional Certificate

Please do not forget to like, subscribe and share.

For enrolling and enquiries, please contact us at
Рекомендации по теме
Комментарии
Автор

Very very knowledgeable video.
Thanks mam for valuable efforts

AbhishekKumar-gfdb
Автор

Can you please explain how to use XMLAGG in SQL with realtime examples?

dkentertainments
Автор

I don't have such database mail option in my sql server. I'm using sql server management studio 2022. what can i do? please reply

mazooths
Автор

Mam, can you show how to send mail with attachment

sriram
Автор

How to set up a mail profile to send mail through an external server using IMAP protocol ?

victorstecenko