Would you put together an example that reproduces the error? You may use tables from Pubs or Northwind if you'd like.
-Mike
>I deleted and recreated Table1 and Table2. I put the same trigger into Table1, but no trigger or calculated cell into Table2 (it's just a table). Each Table has an identity Key field, and two data fileds, each char(10).
>
>I put values into Table1 and hit return several times (i.e. several rows have been inserted, one at a time.) I get a '0' in the identity field in EVERY row in Table1. Table2 has the inserted rows as expected. If I 'run' Table1, the identity fields will correct themselves and be 1,2,3,...
>
>Doing an insert to another table from a trigger is a common event isn't it? I do not seem to be able to get it to work. We made sure we are updated on all of the SQL patches when we re-installed SQL several weeks ago.