>I rewrote the Trigger as:
>
>CREATE TRIGGER [testing] ON [dbo].[Table1]
>FOR INSERT, UPDATE
>AS
>
>insert into Table2 (TT2D1) SELECT T1.TT1D1 From inserted I Inner Join Table1 T1 on T1.TT1ID = I.TT1ID
>
>
>
>Table1 continues to hang up with this trigger.
What SQL statement do you issue that it hangs on? What's purpouse of 'Inner Join' in the INSERT INTO command?
--sb--