BUG: NOCHECK Does Not Allow Modifications to an Fkey Reference

ID: Q158842

The information in this article applies to:

Microsoft SQL Server version 6.5

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          : kbusage SSrvTran_SQL kbbug6.50 
Version           : 6.5
Platform          : WINDOWS 
Issue type        :

Last Reviewed: April 4, 1999