Cycles or multiple cascade paths

Hi,
How does Child table cause
cycles or multiple cascade paths? Why it cannot be handled by SQL Server?
USE TempDB
GO
CREATE TABLE Parent(
Col1 INT PRIMARY KEY
)
GO
CREATE TABLE Child(
Col1 INT REFERENCES Parent(Col1)
ON UPDATE CASCADE,
Col2 INT REFERENCES Parent(Col1)
ON UPDATE CASCADE
)
GO
Thanks in advance,
Leila
Please, look at http://support.microsoft.com/kb/321843
WBR, Evergray
Words mean nothing...
"Leila" <Leilas@.hotpop.com> wrote in message
news:OdAxv6uQGHA.5036@.TK2MSFTNGP12.phx.gbl...
> Hi,
> How does Child table cause
> cycles or multiple cascade paths? Why it cannot be handled by SQL Server?
> USE TempDB
> GO
> CREATE TABLE Parent(
> Col1 INT PRIMARY KEY
> )
> GO
> CREATE TABLE Child(
> Col1 INT REFERENCES Parent(Col1)
> ON UPDATE CASCADE,
> Col2 INT REFERENCES Parent(Col1)
> ON UPDATE CASCADE
> )
> GO
>
> Thanks in advance,
> Leila
>