June 12, 2009 at 4:28 am
I just upgrade my server to SQL Server 2005. Now in application i get following error message
Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).
nested triggers are disabled and no nested stored procedure is used in DB. The error occurs mostly in those stored procedures which are using nested views. What may be reason for this problem.
Regards
DBDigger Microsoft Data Platform Consultancy.
June 12, 2009 at 7:49 am
Check 2 settings:
Server: nested triggers
Database: recursive triggers.
Read BOL on these subjects, if you wish to know about this, or check this: http://msdn.microsoft.com/en-us/library/aa175801.aspx
Greetz,
Hans Brouwer
June 12, 2009 at 8:02 am
I further tracked down that no triggers are involved in my case. Problem lies in some views that are using some User Defined Functions that are again accessing the views. These views were working ok in SQL Server 2000. Also these are working fine on my test server that i upgraded to SQL Server 2005 recently. I want to know some setting that is missing after upgrade.
Thanks and Regards
DBDigger Microsoft Data Platform Consultancy.
June 12, 2009 at 8:10 am
Then I cannot help you...
Greetz,
Hans Brouwer
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply