The information in this article applies to:
SYMPTOMS
If a table has a column of a user-defined data type with a rule associated
with that data type, and if this table only has a single row, attempting to
UPDATE or INSERT INTO this table based on a table join with another table
may cause:
The above error will occur even if that single row does not satisfy the join condition. WORKAROUNDInstead of binding the rule to the data type, bind it to the table column only. STATUSMicrosoft has confirmed this to be a problem in SQL Server version 4.2 for OS/2 and Windows NT. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available. MORE INFORMATION
For example, the following script generates error 513 even if no row
should be affected:
NOTE: If a join is not involved or if the table x has zero or multiple rows, the problem will not happen.
Keywords : kbprg SSrvProg kbbug4.20 SSrvWinNT |
Last Reviewed: March 20, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |