BUG: Access Violation After Update of a Text Column (152797)
The information in this article applies to:
This article was previously published under Q152797 SYMPTOMS
An Update statement that modifies a text column may cause an access
violation. For this to occur, a text column must be updated, and the update
statement must include a cross database join as well as at least two other
natural joins between two more tables from the same database.
WORKAROUND
Split the query into two queries and use an intermediate table or temporary
tables to get the desired result set.
STATUS
Microsoft has confirmed this to be a problem in SQL Server 6.5. We are
researching this problem and will post new information here in the
Microsoft Knowledge Base as it becomes available.
| Modification Type: | Minor | Last Reviewed: | 3/2/2005 |
|---|
| Keywords: | kbBug KB152797 |
|---|
|