Check out @@IDENTITY in the BOL. Just don't have an insert trigger that inserts into another table that also has an IDENTITY column.

-Mike