Microsoft KB Archive/158842

= BUG: NOCHECK Does Not Allow Modifications to an Fkey Reference =

Article ID: 158842

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q158842



BUG #: 14592 (Windows NT: 6.50)



SYMPTOMS
The NOCHECK option for the ALTER TABLE command does not allow a modification to a column or row that is referenced by a foreign key constraint.



WORKAROUND
To work around this problem, drop the foreign key constraint before making the modification.



STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Keywords: kbbug kbusage KB158842

-

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

© Microsoft Corporation. All rights reserved.