The previous period of time cost Dickens, finally got the SQL Mail configuration and use.
_rambo want me to sort out the documents for everyone to share.
I'll describe the process of configuring my SQL Mail once.
I use SQL Mail primarily to accomplish this function:
> Users register online, the system will randomly generate the password sent to the user registered email
> Send content to the user's email when the forum post has a reply
Because the above procedure is done in the stored procedure, it avoids the foreground program's
Transmission processing, and no need to use third-party components to complete, feel more convenient.
1. In order to use SQL Mail, first of all your server has SMTP service, I do not install Win2000 Server comes with SMTP, but with imail6.04 SMTP, feel more stable, more powerful.
2. Install a mail system, I installed Outlook 2000, I found that when configuring message profile, if
Instead of installing Outlook, you use a different third-party program, and the Win2K Chinese server cannot find the mail item in Control Panel.
3. After you install Outlook and then refresh the control Panel, you will find the mail item, double-click the configuration for the message, and a name for the configuration file (assuming Myprofile), so that you can use it later in SQL Mail to set the properties in the configuration file.
4. Start Outlook (set to use Myprofile as the default profile), test to send and receive messages, and verify that Outlook is working correctly.
5. Start SQL Server with the current domain account, in the Enterprise Manager Support Service, click the SQL Mail properties, you can see in the profile selection, the Myprofile configuration file that you just defined appears (you can also define multiple profiles), Select this configuration file for testing, SQL will return the information to successfully start and end a MAPI session, if there is an error or no mail profile is found, it must be the account you started SQL Server with a problem
6. Now you can send SQL Mail in Query Analyzer with xp_sendmail, which is in the following format:
xp_sendmail {[@recipients =] ' recipients [; ... n] '}
[,] [@message =] ' Message ']
[,] [@query =] ' Query ']
[,] [@attachments =] attachments]
[,] [@copy_recipients =] ' Copy_recipients [; ... n] '
[,] [@blind_copy_recipients =] ' Blind_copy_recipients [; ... n] '
[,] [@subject =] ' Subject ']
[, [@type =] ' type ']
[,] [@attach_results =] ' Attach_value ']
[,] [@no_output =] ' Output_value ']
[,] [@no_header =] ' Header_value ']
[,] [@width =] width]
[,] [@separator =] ' Separator ']
[,] [@echo_error =] ' Echo_value ']
[,] [@set_user =] ' User ']
http://www.bkjia.com/PHPjc/631154.html www.bkjia.com true http://www.bkjia.com/PHPjc/631154.html techarticle The previous period of time cost Dickens, finally got the SQL Mail configuration and use. _rambo want me to sort out the documents for everyone to share. I'll just set me up. The process of configuring SQL Mail describes a ...
