The information in this article applies to:
BUG# 13578 (6.0, 6.50) (sqlserver) SYMPTOMS
Adding a foreign key constraint on a primary key column using ALTER TABLE
can fail with the following error:
This problem occurs when the child table has a multicolumn primary key already defined and both primary keys for the child and parent tables use non-clustered indexes. The problem does not occur if:
WORKAROUNDAny of the following will allow you to work around the problem:
STATUSMicrosoft has confirmed this to be a problem in Microsoft SQL Server version 6.0 and Microsoft SQL Server 6.5. This problem does not occur in Microsoft SQL Server 6.5 U.S. Service Pack 2. For more information, contact your primary support provider.Additional query words: sysconstraints sysreferences
Keywords : kbbug6.50 kbbug6.00 |
Last Reviewed: March 31, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |