Did Microsoft enhance Declarative Referential Integrity (DRI) support in SQL Server 2000?
Microsoft hinted several years ago that it would support cascading DRI and disappointed many people when that feature didn't make SQL Server 7.0. With SQL Server 2000, however, the wait is over. SQL Server 2000 supports cascading DRI, a feature that Microsoft Access users have enjoyed for years. What's the difference between previous SQL Server versions' restrictive DRI and cascading DRI? ...