Export (0) Print
Expand All
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.

ms175576.note(en-US,SQL.90).gifNote:
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;
GO
RECONFIGURE;
GO
sp_configure 'Web Assistant Procedures', 1;
GO
RECONFIGURE
GO
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft