Maximum stored procedure, function, trigger, or view nesting level exceeded error v2012 SP2
Symptoms
When creating a customer record, an error occurs.
Error/warning messages
Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).
Reason
Recursive triggers was enabled at the DB level.
Resolution
Disabling recursive triggers.
1. open SQL management studio
2. Right click on the Changepoint database and select properties
3. Go to Options.
4. In the miscellaneous section ensure that 'Recursive Triggers enabled' is set to FALSE.