Web Assistant Procedures Option

Use the Web Assistant Procedures option to enable the Web Assistant procedures on this server. The possible values are:

  • 0 indicating Web Assistant procedures are not available (default)
  • 1 indicating Web Assistant procedures are available

The following procedures are enabled by this option:

  • sp_makewebtask
  • sp_dropwebtask
  • sp_runwebtask
  • sp_enumcodepages

The setting takes effect immediately without a server stop and restart.

Note

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.. Use Reporting Services instead.

To use the Web Assistant, you must also run the Web.sql script, available in the Microsoft SQL Server installation location, in the MSSQL.x\MSSQL\Install folder.

Examples

The following example enables the Web Assistant procedures.

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Web Assistant Procedures', 1;
GO
RECONFIGURE
GO