Is the update instruction updated in the update trigger, does the trigger fire?

Question

If I use the update statement in the update trigger, does this update expression in the update trigger cause the trigger to fire?

Answer 1

Make sure that your database property for RECURSIVE_TRIGGERS set to "off" (which is the default by default) so that it cannot be started recursively.

http://technet.microsoft.com/en-us/library/ms190946.aspx

Answer 2

Please see this blog post for more information on a recursive trigger: http://blog.sqlauthority.com/2007/05/18/sql-server-2005-understanding-trigger-recursion-and-nesting-with-examples /

Answer 3

By default, the trigger does not fire.