MS SQL Basics Tutorial: Web Assistant Wizard

20.5.1 Web Assistant Wizard Features

Web Assistant Wizard is a Web Publishing wizard provided by SQL Server. It is simple and practical, and can be used to generate database Web pages, even if it is a Greek web technology.

The main features of Web Assistant Wizard are the use of SQL Server data to generate standard HTML files. Web Assistant Wizard typically generate HTML files by using Transact-SQL query statements or stored procedures, develop HTML file generation and update schedules, publish server Management reports, and 20.5.2 use Web Assistant Wizard Before the preparatory work

Before you use Web Assistant Wizard, you need to do some preparation work.

1 Set permissions

The following permissions are required to run the Web Assistant Wizard: Create PROCEDURE permissions in the selected database, select permissions on the selected columns, and permissions for creating files in SQL Server.

2 Creating the necessary queries

If you want to use programs such as stored procedures in Web Assistant Wizard for data queries, you need to define them in advance.

3 check if the SQL Agent service has started

The Web Assistant Wizard requires the use of the SQL Agent service. It is best to set the SQL Agent service to start automatically when the server is started, otherwise the services required for many Web content will not be available.

20.5.3 Publish Web pages using Web Assistant Wizard

In SQL Server 2000, the Web Publishing node under the Management folder in the SQL Server 7.0 directory tree is removed, so you need to use the Select Start Web Assistant Wizard from the wizard list box.

(1) Select the database to publish in the directory tree, then select the "Wizards" menu item from the Tools menu and bring up the wizard list box, as shown in Figure 20-9. Then select Web Assistant Wizard from "Management".