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:
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; GO RECONFIGURE; GO sp_configure 'Web Assistant Procedures', 1; GO RECONFIGURE GO