Correct - sorry I did not clarify. Also, if you are using SQL 7 and want to cascade deletes using nested triggers, you have to explicitely set the server to allow for a nested trigger (a trigger that is fired by another trigger).
-----Original Message----- From: Mike Bruce [mailto:[EMAIL PROTECTED]] Sent: Monday, March 18, 2002 12:17 PM To: CF-Talk Subject: Re: Cascading deletes ? in MS-SQL>>> This assumes that you are using SQL2000. if you are using 7, you will have to create the trigger yourself. Mike ----- Original Message ----- From: "Mark A. Kruger - CFG" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, March 18, 2002 10:35 AM Subject: RE: Cascading deletes ? in MS-SQL>>> > On the delete query you use the "with cascade" key word. Check out books > online for more info. > > -----Original Message----- > From: Tyler Silcox [mailto:[EMAIL PROTECTED]] > Sent: Monday, March 18, 2002 8:57 AM > To: CF-Talk > Subject: Cascading deletes ? in MS-SQL>>> > > > Is there an easy way to set up cascading deletes in Enterprise Manager or do > I have write my own triggers for all my relational tables? > > Tyler Silcox > email | [EMAIL PROTECTED] > > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
