Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Error message

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-01-26 : 08:16:54
SilverWind writes "The enterprise manager allows me to implement the trigger, but gives me the following error message occurs when i try to fire a trigger. What does it mean, and how do i go correct it?

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

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-01-26 : 08:33:21
what on earth are you doing with this trigger?? this message occurs when you try to call
a stored procedure that calles a stored procedure that calles a stored procedure that calles a .... and so on for more than 32 times.
nesting level means calling a sproc from an sproc.

Go with the flow & have fun! Else fight the flow
Go to Top of Page
   

- Advertisement -