BUG: Stored Procedure Remains After Execution by Sp_makewebtask (201042)



The information in this article applies to:

  • Microsoft SQL Server 7.0
  • Microsoft SQL Server 2000 (all editions)

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.

Modification Type:MajorLast Reviewed:10/17/2003
Keywords:kbBug kbpending KB201042