Microsoft KB Archive/275518

= BUG: Updating Text Column with Instead Of Trigger Inside of a Stored Procedure Causes AV =

PSS ID Number: 275518

Article Last Modified on 10/3/2003

-

The information in this article applies to:


 * Microsoft SQL Server 2000 (all editions)

-



This article was previously published under Q275518



BUG #: 236494 (SHILOH)



SYMPTOMS
When you attempt to update a text column inside of a stored procedure when an Instead Of trigger is placed on the table, an access violation may be raised, and you may receive the following error message:

ODBC: Msg 0, Level 19, State 1

SqlDumpExceptionHandler: Process 51 generated fatal exception c0000005

EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionWrite (WrapperWrite).



WORKAROUND
Perform the update operation outside of the stored procedure.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 2000.

Keywords: kbbug kbpending KB275518

Technology: kbAudDeveloper kbSQLServ2000 kbSQLServ2000Search kbSQLServSearch

-

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

© 2004 Microsoft Corporation. All rights reserved.