SQL Server - How to send an email in SQL Server | FoxLearn

preview_player
Показать описание
How to enable and configure Database Mail using the Database Mail Configuration Wizard in SQL Server 2019.

Database Mail is a solution for sending e-mail messages from the SQL Server Database Engine to users.

Database Mail is a component that can send emails using SQL Server Engine. Using Database Mail, an administrator or a developer can send query output to an end user. DBAs can configure it to get email alerts and notifications. Database Mail uses SMTP (Simple Mail Transfer Protocol) to deliver emails to recipients.

A Database Mail account contains the information that SQL Server uses to send e-mail messages to an SMTP server

how to configure database mail in sql server using gmail
sql server database mail gmail smtp
sql server database mail smtp authentication
Рекомендации по теме
Комментарии
Автор

I didn't know this was possible, wow What an amazing channel! Thank you for this sharing all your knowledge with us...

prismapuntodeventa
Автор

Thank you helped.
Question:
Does this work for email or hotmail?

Also please make a video on how to connect to a ip host? I really need it for a project thank you!

I love your videos since 2018.
I wish you 20 million subs or more!

speedsterkawaii
Автор

sql 2012. sending email not working. The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2024-02-17T04:06:01). Exception Message: Cannot send mails to mail server. (The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.7.0 Authentication Required.

jonathanuy
Автор

thanx, can you plz show us how to loop through rdlc without reportviewer and send it as email attachments to relevent emails.

AK-Star
Автор

What is the purpose of this? Great video

SKglitches
Автор

where is the my database mail button ı cant see ı need helpppp

nyks
Автор

How to attach database backup on the email?

hassanzein