Maximum stored procedure, function, trigger, or view nesting level exceeded(limit 32)

[punitdam]

I m retreiving some data by using cursor inside which i m calling one recursive user defind function to retrive all child data which is linked to parent. While executing i m getting error stating :
Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)

How can i increase this limit.

Can any body help me?

[huangzhi]

You cannot increase this limit. You must change your program. See http://www.daniweb.com/forums/thread114466.html . Hope this link can give you some idea.

[punitdam]

Thanx it was great help.