INF: Workaround for Changing the File Path of a Report in SQL Web Publishing (317862)
The information in this article applies to:
- Microsoft SQL Server 2000 (all editions)
- Microsoft SQL Server 7.0
This article was previously published under Q317862 SUMMARY
If you use the Web Assistant feature in SQL Server, you may want to change the path to which the publication files (.htm) are written without having to drop and re-create the publication.
By design, there is no way to change the path of a published Web page.
This article discusses a workaround that you can use to change the file path.
WORKAROUND
When you create a publication, also create a script file that contains all the elements of the publication. To create the script file click Write Transact-SQL to file in the last screen of the Web Assistant Wizard. When you click Write Transact-SQL to file, the Web Assistant Wizard creates a script file that contains the sp_makewebtask stored procedure. Now, if you need to change the file path, you can use the script file the Web Assistant Wizard created to re-create the file after you drop the publication.
| Modification Type: | Major | Last Reviewed: | 10/17/2003 |
|---|
| Keywords: | kbinfo KB317862 |
|---|
|