FIX: Xp_makewebtask Procedure May Cause Access Violation (180778)
The information in this article applies to:
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.
| Modification Type: | Major | Last Reviewed: | 3/14/2006 |
|---|
| Keywords: | kbBug kbfix KB180778 |
|---|
|