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?

Thanx it was great help.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.