SQL Server Performance

Native Error: 217

Discussion in 'SQL Server 2005 General Developer Questions' started by thanesh, Oct 25, 2008.

  1. thanesh New Member

    Dear All,
    In one of my table have 3 triggers for insert,delete and update. While updating the table i am geting the below error please help me. First time I am seeing this error.
    Index #0 Message: Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32). NativeError: 217 Source: Microsoft OLE DB Provider for SQL Server SQLState: 42000
  2. satya Moderator

    The error is self explanatory, somewhere in your code you exceeded the maximum nesting level of 32.
    Also check your database for triggers and if the database option "Recursive triggers" is enabled you might want to disable that. If the error is not caused by triggers then you need to find out which stored procedure or function may causing the issue and you can find running profiler at that time to see what is happneing.

Share This Page