FIX: Xp_makewebtask Procedure May Cause Access Violation

• Microsoft SQL Server version 6.5

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 version 6.5. This problem has been corrected in U.S. Service Pack 5a for Microsoft SQL Server version 6.5. For information about downloading and installing the latest SQL Server Service Pack, see http://support.microsoft.com/support/sql/.

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          : SSrvErr_Log SSrvGPF SSrvStProc SSrvWeb kbbug6.50 kbfix6.50.SP5 
Version           : winnt:6.5
Platform          : winnt 
Issue type        : kbbug 

Last Reviewed: April 21, 1999