Shulou(Shulou.com)05/31 Report--

This article mainly introduces "the methods and steps of sending mail through sql stored procedures". In daily operation, I believe that many people have doubts about the methods and steps of sending mail through sql stored procedures. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful for you to answer the questions of "methods and steps of sending mail through sql stored procedures". Next, please follow the editor to study!

Test environment:

1 Windows 2000 Server 2 SQL Server 2000+SP3 3 Microsoft OutLook (Office 2000)

Prepare an Internet mail account:

Test email account: test@xuebuyuan.com Smtp Server smtp.163.com pop3 Server pop.163.com

Step 1: change the email configuration

1 Open Microsoft OutLook, click options on the tools menu, and then click the Mail Services tab. 2 Click reconfigure Mail support. 3 Select "for Enterprise or Workgroup" option 4 to restart Microsoft OutLook

Step 2: add a profile

1 Click Services on the tools menu, and then click the add button. 2 Select Internet email and click OK. The next step is to set up an e-mail account. Please refer to the Microsoft Outlook help file. I won't repeat it here. 4 send and receive email using the configured e-mail account to confirm the success of the configuration.

Step 3: configure the MSSQLSERVER service to adopt a mail profile

1 restart the MSSQLSERVER service (required, otherwise the MSSQLSERVER service will not detect the profile added in the previous step) 2 Open Enterprise Manager-> expand the server-> support services-> right-click "Mail"-> Click the drop-down box, you will find the "Microsoft Outlook Internet Settings" option and click "Test". If a dialog box pops up to show success, congratulations, it's done.

Step 4: enjoy the fruits of your labor

1 Open the query Analyzer of SQL Server

2 enter the following SQL statement to execute exec master..xp_sendmail 'testworthy xuebuyuan.compositional records

All right, go to your mailbox and get your mail.

Note: the above configuration process requires you to log in to Windows 2000 Server with the Windows account used by the MSSQLSERVER service, that is, you should log in to the computer with the same Windows account as the MSSQLSERVER service.

At this point, the study on the method and steps of sending mail through sql stored procedures is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.