nelson.muller (11/21/2013)
I understand the best practices and I am quite experienced with SQL server. I haven't seen this error before. Unfortunately the procedure is over 2,000 lines long and has a very complex process in a complex data model. Let me try to rephrase my question. The error is:Msg 217, Level 16, State 1, Procedure MyNotification, Line 75
Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).
The call to MyNotification is done within a begin/end catch. Does that mean there is a nesting inside MyNotification, or is the error because there is a recursive CTE between the begin/end try? Thanks again.
There is nesting of some kind or other going on somewhere in your code right around line 75.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/