Cascading Deletes

I have to SQL 2000 Server setups. It seems I have different builds on them.
The problem one is (told to me from SQL Analyzer) 8.00.194 the working one
is 8.00.760. In the problem one I can not setup a cascading delete from
Enterprise Manager. Anyone know why? Getting the problem updated is going
to be a bear. Anyone know a work around to add my Cascading Delete?
ChrisJust create your foreign key in T-SQL:
ALTER TABLE your_table DROP CONSTRAINT your_constraint
GO
ALTER TABLE your_table ADD CONSTRAINT your_constraint
FOREIGN KEY (referencing_column)
REFERENCES referred_table (primary_key_column)
ON CASCADE DELETE
Jacco Schalkwijk
SQL Server MVP
"Chris, Master of All Things Insignificant" <chris@.No_Spam_Please.com> wrote
in message news:OXzfERwAFHA.2788@.TK2MSFTNGP15.phx.gbl...
>I have to SQL 2000 Server setups. It seems I have different builds on
>them. The problem one is (told to me from SQL Analyzer) 8.00.194 the
>working one is 8.00.760. In the problem one I can not setup a cascading
>delete from Enterprise Manager. Anyone know why? Getting the problem
>updated is going to be a bear. Anyone know a work around to add my
>Cascading Delete?
> Chris
>|||Ya I tried that too:
ALTER TABLE Holiday ADD CONSTRAINT TestContraint
FOREIGN KEY (FK_CallFlow)
REFERENCES CallFlows (PRI_ID)
ON CASCADE DELETE
And get this error:
Server: Msg 156, Level 15, State 1, Line 4
Incorrect syntax near the keyword 'ON'.
"Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid> wrote
in message news:evqjAqwAFHA.2180@.TK2MSFTNGP12.phx.gbl...
> Just create your foreign key in T-SQL:
> ALTER TABLE your_table DROP CONSTRAINT your_constraint
> GO
> ALTER TABLE your_table ADD CONSTRAINT your_constraint
> FOREIGN KEY (referencing_column)
> REFERENCES referred_table (primary_key_column)
> ON CASCADE DELETE
>
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Chris, Master of All Things Insignificant" <chris@.No_Spam_Please.com>
> wrote in message news:OXzfERwAFHA.2788@.TK2MSFTNGP15.phx.gbl...
>|||> ALTER TABLE Holiday ADD CONSTRAINT TestContraint
> FOREIGN KEY (FK_CallFlow)
> REFERENCES CallFlows (PRI_ID)
> ON CASCADE DELETE
...
on delete cascade
AMB
"Chris, Master of All Things Insignifican" wrote:

> Ya I tried that too:
> ALTER TABLE Holiday ADD CONSTRAINT TestContraint
> FOREIGN KEY (FK_CallFlow)
> REFERENCES CallFlows (PRI_ID)
> ON CASCADE DELETE
> And get this error:
> Server: Msg 156, Level 15, State 1, Line 4
> Incorrect syntax near the keyword 'ON'.
>
> "Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid> wro
te
> in message news:evqjAqwAFHA.2180@.TK2MSFTNGP12.phx.gbl...
>
>|||Nope, same error message? Anyone know what's going on?
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:7750E15C-8940-41A5-A88C-6446146737A0@.microsoft.com...[vbcol=seagreen]
> ...
> on delete cascade
>
> AMB
> "Chris, Master of All Things Insignifican" wrote:
>|||Perhaps the database has compatibility level lower than 80?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Chris, Master of All Things Insignificant" <chris@.No_Spam_Please.com> wrote
in message
news:%23HU5f$yAFHA.2180@.TK2MSFTNGP12.phx.gbl...
> Nope, same error message? Anyone know what's going on?
> "Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in messag
e
> news:7750E15C-8940-41A5-A88C-6446146737A0@.microsoft.com...
>