Web-Related Stored Procedures
A few stored procedures are involved in the process of generating and updating Web pages with SQL Server data. They are sp_makewebtask, sp_runwebtask, and sp_dropwebtask. The sections that follow cover the details of each of these very powerful stored procedures.
sp_makewebtask
sp_makewebtask is a system stored procedure that receives a multitude of input parameters. This stored procedure is responsible for generating a Web task that publishes XML data. If you review the Transact-SQL file created in the final step of the Web Assistant Wizard, you will see that it executes the sp_makewebtask stored procedure. All of the options that you selected in the wizard appear as parameters to the stored procedure (see Figure ...
Get Alison Balter's Mastering Access 2002 Enterprise Development now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
