FIX: Xp_makewebtask Procedure May Cause Access Violation

Concurrent execution of the xp_makewebtask extended stored procedure may cause a handled access violation (AV). After the AV, the SQL Server stops responding. The SQL Server errorlog will contain a message similar to the following:

To work around this problem, either minimize the number of calls to xp_makewebtask, or serialize the calls to the procedure.

Microsoft has confirmed this to be a problem in SQL Server 6.5. This problem has been corrected in Service Pack 5a for Microsoft SQL Server 6.5.For more information, click the following article number to view the article in the Microsoft Knowledge Base:For more information, contact your primary support provider.

The xp_makewebtask extended stored procedure is called by the SQL Server Web Assistant to generate Web pages. Optionally, a task may be created to run on a recurring basis so that a new HTML file can periodically be generated as data is updated. Use of this stored procedure to dynamically build Web pages for every hit on a Web page is not preferred, because technologies such as Active Server Pages (ASP) are better suited for that purpose.