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)

  • January 23, 2009 at 12:29 am

    #931660

    It means you're calling a procedure, view or function from your procedure, and then from that proc calling another, etc 32 levels deep. Or it could be recursive with the proc calling itself.

    Either way, you're going to have to track down where that is coming from and change the code so that the nesting level isn't anywhere close to that deep. There's no way to change the maximum nesting level.

    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