Trouble With Update Trigger Modifying Table Which Fired Trigger

Are there any limitations or gotchas to updating the same table which
fired a trigger from within the trigger?

Some example code below. Hmmm.... This example seems to be working
fine so it must be something with my specific schema/code. We're
working on running a SQL trace but if anybody has any input, fire
away.

Thanks!


create table x
(
Id int,
Account varchar(25),
Info int
)
GO

insert into x values ( 1, 'Smith', 15);
insert into x values ( 2, 'SmithX', 25);

/* Update trigger tu_x for table x */
create trigger tu_x
on x
for update
as
begin
declare @TriggerRowCount int
set @TriggerRowCount = @@ROWCOUNT

if ( @TriggerRowCount = 0 )
return

if ( @TriggerRowCount > 1 )
begin
raiserror( 'tu_x: @@ROWCOUNT[%d] Trigger does not handle @@ROWCOUNT[color=blue]
> 1 !', 17, 127, @TriggerRowCount) with seterror, nowait[/color]
return
end

update x
set
Account = left( i.Account, 24) + 'X',
Info = i.Info
from deleted, inserted i
where x.Account = left( deleted.Account, 24) + 'X'
end

update x set Account = 'Blair', Info = 999 where Account = 'Smith'