Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

Web Assistant Procedures Option

SQL Server 2005

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.

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.

The following example enables the Web Assistant procedures.

sp_configure 'show advanced options', 1;
sp_configure 'Web Assistant Procedures', 1;
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft