Does an update statement in update trigger, fire trigger again?

Question

If I use an update statement in an update trigger, does that update statement in update trigger causes fire trigger?

Answer 1

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

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

Answer 2

By default, a trigger doesn't fire himself.