Configuring the Web Assistant Wizard

Before running the Web Assistant Wizard, you must:

• Set appropriate permissions.
  
  
• Choose the database to publish.
  
  
• Create queries.

Setting Permissions

To run the Web Assistant Wizard, you must have:

• CREATE PROCEDURE permissions in the selected database.
  
  
• SELECT permissions on chosen columns.
  
  
• Permissions to create files in the account in an instance of Microsoft® SQL Server™.

Choosing the Database to Publish

The Web Assistant Wizard works with databases created by SQL Server. Select the database to publish in the console tree of SQL Server Enterprise Manager. If the server does not appear in this list, run the Register Server Wizard.

Creating Queries

You can run queries by:

• Using tables and columns you specify.
  
  
• Creating result sets from a stored procedure.
  
  
• Selecting data using Transact-SQL statements.

The Web Assistant Wizard requires that each job be named, and a default name is supplied. For jobs that will run at a later time or for jobs that run on a continuous basis, choose a name that will help you remember the focus of this query.