Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32) error
This error involves in calling a recursive trigger, function or procedure in the database.
To disable the recursive or nested triggers, you need to execute the following in the MS SQL 2005
SP_CONFIGURE 'nested_triggers',0 GO RECONFIGURE GO
or, you can set TRIGGER_NESTLEVEL() < 2
List list 'recusive trigger config.
To list all trigger in database
select so.name [Trigger], so2.name [Table] from sysobjects so join sysobjects so2 on so.parent_obj = so2.id and so.xtype = 'tr' order by so2.name