sql server
use Enterprise Manager:
Expand a server group.
Right-click a server; then click Properties.
Click the Server Settings tab.
In the Server behavior box, select or clear Allow triggers to be fired
which fire other triggers (nested triggers).
sql:
EXEC sp_configure 'nested triggers' , '1'
RECONFIGURE
