- Microsoft SQL Server Management Studio
- Management --right click Database Mail --enable Database Mail and set an email account and public default profile, as shown below:
You must make sure that your email server (smtp) accepts your connection.
3. Create an operator, e.g. Administrator, which is associated with the email address you defined in database mail, e.g. Administrator@vanstudents.com.
4. Define an alert to use the database mail notification
When I read the text book regarding the alert notification by database mail, I was trying to accomplish it by using Windows Server Performance console. It is actually implemented inside SSMS.
