BUG: Stored Procedure Remains After Deleting Web Wizard File (201041)


The information in this article applies to:

  • Microsoft SQL Server 7.0
  • Microsoft SQL Server 2000 (all editions)
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.
Modification Type:MajorLast Reviewed:11/21/2003
Keywords:kbBug kbpending KB201041
©2003 Microsoft Corporation. All rights reserved.