Home Forums SQL Server 7,2000 General Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32) RE: Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)

  • March 24, 2009 at 1:34 am

    #964993

    shishir999_ril (3/23/2009)

    In my SP, I'm trying to delete the No. of rows on the basis of some conditions.

    So, that query is acting as recurssive. Is there a way to change that option.

    That shouldn't be a recursive query unless you're explicitly calling a function from within itself. Post the query please?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass