set @emailaddress = 'DBMail@company.com' --Email will come from this email address, change it as appropriate, i keep it DBPMail@domain.com so I can easily filter DBMail alerts. set @smtpservername = ...

Find out how to troubleshoot connection problems. View steps to take when you can't use TCP/IP to connect to a SQL Server Database Engine on a single server. These steps aren't in the order of the ...