Microsoft KB Archive/275912

= BUG: Generated scripts include ON INSERT/ DELETE CASCADE statements when scripting SQL Server 7.0 compatible features =

Article ID: 275912

Article Last Modified on 12/21/2004

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q275912



BUG #: 236591 (SHILOH)



SYMPTOMS
When you script a table that contains an ON INSERT/DELETE CASCADE clause, and you select both the Only script 7.0 compatible features and Script PRIMARY keys, FOREIGN keys, defaults, and check constraints check boxes, the generated script contains the ON INSERT/DELETE CASCADE syntax. When you attempt to run the script against SQL Server 7.0, a syntax error message occurs.



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



MORE INFORMATION
This behavior is not generic to scripting all of the new SQL Server 2000 features. For instance, if you select the Only script 7.0 compatible features and Script triggers check boxes, an INSTEAD OF trigger will not be scripted.

Keywords: kbbug kbpending KB275912

-

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

© Microsoft Corporation. All rights reserved.