Microsoft KB Archive/201041

= BUG: Stored Procedure Remains After Deleting Web Wizard File =

Article ID: 201041

Article Last Modified on 11/21/2003

-

APPLIES TO


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

-



This article was previously published under Q201041



BUG #: 42817 (SQLBUG_70)



SYMPTOMS
After you have defined a Web Assistant Job Task and then you delete that Web Assistant's HTML file, the created stored procedure is not deleted as well.



WORKAROUND
To work around this problem, do the following:


 * 1) In SQL Enterprise Manager, open the stored procedure pane for that database.
 * 2) Select the stored procedure and manually delete it by pressing the DELETE key and clicking Drop All in the Drop Objects dialog box.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



MORE INFORMATION
Steps to Reproduce the Problem:


 * 1) In SQL Server Enterprise Manager, select the SQL Server. On the Tools menu, click Wizards.
 * 2) Under Management, select Web Assistant Wizard and click OK.
 * 3) Using the master database, accept all the default options and add all columns. On the Schedule the Web Assistant Job dialog box, select When The SQL Server Data Changes.
 * 4) When complete, manually delete the HTML file that the Wizard created. By default, this file is named WebPage1.htm in the Mssql7\Html directory.
 * 5) In Enterprise Manager, open the tree structure under the master database and click the stored procedure pane. Here you will see the created stored procedure that generates the results for this WebPage1.htm file. This stored procedure has a default name of "master Web Page 1".
 * 6) Click to select this stored procedure and the press the DELETE key.
 * 7) On the Drop Objects dialog box, click Drop All.

Additional query words: ent man entman SEM

Keywords: kbbug kbpending KB201041

-

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

© Microsoft Corporation. All rights reserved.