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

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

Answer

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