SQL Server Email Articles

Configuring Email in SQL Server 2000

A couple of days back I was asked to configured database email for a DB Server which was hosted on a SQL Server 2000 environment. Configuring a database email in SQL Server 2000 is somewhat different than the SQL Server 2005 environment as there is no GUI available in SQL Server 2000. The following steps […]

Sending Email to Different Domains using SQL Server

Out of the  box, SQL Server’s database mail feature does not allow sending mails to different domains. Error message is: The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2009-11-30T09:44:39). Exception Message: Cannot send mails to mail server. (Mailbox unavailable. The server response was: […]

SQL Server Email Alerts Notifications

As  DBAs, we are often required to set up alert notification emails for various tasks. For example, there might be a requirement to set up notification alerts if a particular backup job fails. A while back, I  came across the situation where I was asked to write a script which sent an email alert to […]