My first guess would be to look for triggers or circular foreign key references. Often times people will declare a cascading delete on a foreign key so when you delete the record, it deletes records in tables that are related to it. But if one of those other tables has a foreign key that points back to the initial table, then the reference becomes circular and you may end up with an error like what you saw because the nesting goes into an infinite loop.
Judah On Wed, Sep 17, 2008 at 9:20 AM, Paul Ihrig <[EMAIL PROTECTED]> wrote: > so i just made a new sql server and moved data from the old. > > every thing is singingly great... > except when i try to delete some thing > > General Details: > [Macromedia][SQLServer JDBC Driver][SQLServer]Maximum stored > procedure, function, trigger, or view nesting level exceeded (limit > 32). > The contents of the tag stack are: > 1 CFQUERY > (264,0) D:\webserver\RittalNet\Admin\popup_results.cfm 2 > CF_POPUP_RESULTS > (245,0) D:\webserver\RittalNet\Admin\popup_results.cfm 3 > CF_POPUP_RESULTS > (1,0) D:\webserver\RittalNet\Admin\popup_results.cfm 4 > CF_POPUP_RESULTS > (1,0) D:\webserver\RittalNet\Admin\popup_results.cfm > > even if i delete a row in the table ion sql ent man. > i get the error > maximum stored procedure, function, trigger, or view nesting level > exceeded (limit 32) > > i am looking at dependencies. > but i am not a DBA and don't really understand what a can tweak or get rid > of? > > help! > -paul > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:269682 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
