CREATE TRIGGER AtualizaDataAlteracaoSegmentos
ON dbo.Segmentos
AFTER INSERT,UPDATE
AS
BEGIN
    Begin tran
      update Segmentos
      set DataAlteracao = GETDATE()
       where Id = (select ID from inserted);

    Commit;
END;

ALTER DATABASE NomeDoBanco SET RECURSIVE_TRIGGERS OFF

IF NOT UPDATE(DataAlteracao)
BEGIN
   update Segmentos
      set DataAlteracao = GETDATE()
    where Id = (select ID from inserted);
END

IF TRIGGER_NESTLEVEL() <= 1
BEGIN
   update Segmentos
      set DataAlteracao = GETDATE()
   where Id = (select ID from inserted);
END