Microsoft KB Archive/180778

= FIX: Xp_makewebtask Procedure May Cause Access Violation =

Article ID: 180778

Article Last Modified on 3/14/2006

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q180778



SYMPTOMS
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:

Stored function 'xp_makewebtask' in the library 'xpsqlweb.dll' generated access violation; SQL Server is terminating process.



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



STATUS
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:

197177 INF: How to Obtain SQL Server 6.5 Service Pack 5a

For more information, contact your primary support provider.



MORE INFORMATION
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.

Additional query words: exception crash hang hangs hung wizard

Keywords: kbbug kbfix KB180778

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.