Knowledge Base

BUG: Stored Procedure Remains After Execution by Sp_makewebtask

Article ID: 201042

Article Last Modified on 10/17/2003

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

This article was previously published under Q201042

BUG #: 52589 (SQLBUG_70)

SYMPTOMS

After executing the sp_makewebtask system stored procedure to create a Web Task, an internally generated stored procedure is created such as: web_19981206123328134702 (note that the format of this procedure is: web_year/month/day/time stamp). These stored procedures remain in the database where sp_makewebtask was executed.

WORKAROUND

These internally generated stored procedures can be ignored or deleted if you choose.

STATUS

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

Keywords: kbbug kbpending KB201042