How to download file from sql stored procedure

Download Microsoft Edge More info. Contents Exit focus mode. Is this page helpful? Please rate your experience Yes No. Any additional feedback? Submit and view feedback for This product This page.

View all page feedback. In this article. Felix Hooker is a data recovery expert in DataNumen, Inc. For more information visit www. Your email address will not be published. Share Now:. Set up the following columns for a table tblStaff. Create a new workbook. When you send email in above simple SQL stored procedure, if it returned an error, please have a look at the following tips:. If your server address is correct, you should check if your DNS server setting is correct.

This error means there is a problem with networking connection to SMTP server. You can use Windows built-in Telnet command to detect the networking connection. If the networking connection to your SMTP server is good, it should return a message like If it returns Could not open connection to Please have a look at the following screenshot:.

Therefore, many email providers also provide an alternative port to receive email from such users. But if the connection is ok, telnet returns a flash cursor. Password is always case-sensitive. For anti-spam policy, most SMTP servers do not accept the email to outbound domain without user authentication. If SMTP server returns an error, it usually returns description about this error. Some descriptions also include a HTTP link, you can go to this linked web page to learn more detail.

You can also use the following codes to generate a log file to learn all SMTP session between client and server.