SQL Server and the Web FAQ
The following section lists some commonly asked questions and answers about SQL Server 2000 and the Web.
| Q1: | What type of permissions does the SQL Server Web Assistant user have to have to create a Web Assistant Job? |
| A1: | The Web Assistant user must have SELECT permissions on the table columns specified in the query and CREATE PROCEDURE permissions in the database in which the query will run. The account in which SQL Server is running must have CREATE FILE account permissions. |
| Q2: | What should I enter as the path for the HTML page created by the Web Assistant Wizard? |
| A2: | You can enter a local directory on the SQL Server, or alternatively you can enter any location that is accessible to the SQL Server via HTTP (Hypertext ... |
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
