Microsoft KB Archive/317862

= INF: Workaround for Changing the File Path of a Report in SQL Web Publishing =

Article ID: 317862

Article Last Modified on 10/17/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft SQL Server 7.0 Standard Edition

-



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.

Keywords: kbinfo KB317862

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.