Microsoft KB Archive/272319

= BUG: ALTER TABLE NOCHECK CONSTRAINT Excluded When Scripting Database =

Article ID: 272319

Article Last Modified on 10/16/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q272319



BUG #: 58318 (SQLBUG_70)



SYMPTOMS
Use the SQL Server Query Analyzer and perform the following:
 * 1) Create a table.
 * 2) Alter the table to add a constraint.
 * 3) Alter the table again and put a NOCHECK constraint on the same table.

When scripting the table by using the SQL Server 7.0 Enterprise Manager, the NOCHECK syntax is excluded.



WORKAROUND
If you have a copy of the SQL Server 2000 SQL Enterprise Manager available, use that version instead to script the table.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0.

Keywords: kbbug kbpending KB272319

-

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

© Microsoft Corporation. All rights reserved.