Posted by Erland Sommarskog on 09/30/68 11:49

Jeff North (jnorthau@yahoo.com.au) writes:
> On Sat, 3 Jun 2006 17:34:14 +0000 (UTC), in
> comp.databases.ms-sqlserver Erland Sommarskog <esquel@sommarskog.se>
><Xns97D7C71728295Yazorman@127.0.0.1> wrote:
>>| I can't really say what might be the problem
>>| in this case, but I guess that if you add triggers into the mix, there
>>| can be intersting results.
>
> No triggers at present but it looks as though triggers might be the
> only option.

What I wanted to say that combination of cascading DRI (had it been
permitted) and triggers in this case could have lead to interesting
results. And since a trigger could be added later, my suspicion that the
mere possibility is enough to disallow the multiple cascade path.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: My article on Dynamic Search Conditions
• Prev in forum: Re: Trigger to populate table or database
• Thread view: Re: Referential Integrity problem

[Reply to this message]