Using SQL Server Web Assistant File Options

Use the SQL Server Web Assistant File Options screen to specify file locations, titles, reference text, and reference links.

The SQL Server Web Assistant File Options screen offers these options.

Option Description
Type the filename of the web page Is the full path specification to reference the generated HTML file. This filename is relative to where SQL Server is running. The default file specification is C:\WEB.HTML. You must have adequate privilege to create files in the specified directory.
A template file called Is the full path specification used to reference an HTML template file. This filename is relative to where SQL Server is running. The default is <no template file will be used>. If you use a template file, The Following Information option does not apply.

For more information on using template files, see Using HTML Template Files later in this section.
The following information Specifies whether to use web page formatting options.
What is the title of the Web page? Specifies the title used by your browser when displaying the web page. The default title is "SQL Server Web Assistant."
What is the title for the query results? Specifies the title for the results data. The default results title is "Query Results."
Do you want to include URL links and
reference text in your web page?		 Specifies whether to include one or more URL links to a home page or other location.

Using URL and Reference Text Options

Use these options to include URL links and reference text in your web page.

    To include one URL link And reference text
  1. Select the Yes, Add One URL And Reference Text option.

    Two text box options appear.

  2. Type the internet address of the link.
  3. Type the label for the link.
    To include multiple URL links and reference text
  1. Select the Yes, Add A List Of Urls And Reference Text From A Table option.

    A text box appears.

  2. Type a query that will return a two-column table containing URLs and reference text. The first column must contain the URL. The second column must contain the reference text.