BUG: Generated scripts include ON INSERT/ DELETE CASCADE statements when scripting SQL Server 7.0 compatible features (275912)
The information in this article applies to:
- Microsoft SQL Server 2000 (all editions)
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.
| Modification Type: | Minor | Last Reviewed: | 12/21/2004 |
|---|
| Keywords: | kbBug kbpending KB275912 |
|---|
|