Please see attached.
begin 600 SqlQCasdel.DOC
this one?Quote:> Does SQL Server support automatic cascade deletes for situations such as
With triggers. I guess that you already have the answers, andQuote:> If so, how does one implement this feature?
I prefer, however, to do all modificatione in stored procedures. Benefits
include: abstraction, less dependencies (for the client programs), you
really _have_ to think (design) before you write yur client apps, security
(you don't have to GRANT DELETE to a user), etc...
So perform the cascading function in a procedure, and you can keep your
constraints and drop your (cascading) triggers!
MCSE, MCSD, MCT, SQL Server MVP
Cornerstone Sweden AB
Quote:> Please see attached.
> Darsh Mann