BUG: Stored Procedure Remains After Deleting Web Wizard File

ID: Q201041

The information in this article applies to:
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 this to be a problem in SQL Server version 7.0.


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          : SSrvEntMan SSrvGen SSrvStProc SSrvWeb kbbug6.50 
Version           : winnt:7.0
Platform          : winnt 
Issue type        : kbbug

Last Reviewed: January 23, 1999