by Marc Dziedzi » Fri, 05 Feb 1999 04:00:00
I have a need to perform a cascading delete via a trigger. The problem
is that the initial delete from the table violates a foreign key constraint.
Is there any way to perform a "Before Delete" action in a trigger in SQL
Server?
Thanks -- Marc
by Tibor Karasz » Fri, 05 Feb 1999 04:00:00
No, SQL Server does not implement "before" triggers.
Remove your foreign keys, disable them (NOCHECK) or perform cascading in sp
or client app.....
--
Tibor Karaszi
MCSE, MCSD, MCT, SQL Server MVP
Cornerstone Sweden AB
Please do not respond by e-mail unless explicitly asked for.
> I have a need to perform a cascading delete via a trigger. The problem
>is that the initial delete from the table violates a foreign key
constraint.
>Is there any way to perform a "Before Delete" action in a trigger in SQL
>Server?
>Thanks -- Marc
1. Cascade Delete and Cascade Update on SQL 7
Hi,
Is it possible to implement a kind of cascade delete and cascade update
on SQL 7 ?
I know that's already on SQL2000, but we still having some servers using
SQL7.
Is it possible through a trigger or something ?
Thanks in advance,
John Gooch,
3. cascade update , cascade delete
4. Problem with IN in a stored procedure
5. Cascading deletes, without cascade
7. HELP! Creating delete trigger for cascade delete
8. Stale data - How to refresh???
9. cascade delete vs delete transact sql
10. Multiple FK w/ CASCADE DELETE gives SQLERR: 274 no delete permission
11. Question about regular delete and cascading delete.
12. delete trigger or cascade delete, which one??