You don't need to set the IDENTITY_INSERT on the second table, only the first one because this table contains the primary key. But if you are also going to insert into the second table and setting the primary key, here's what you need to do:
1. SET IDENTITY_INSERT <Table1> ON
2. INSERT INTO <Table1>
3. SET IDENTITY_INSERT <Table2> ON
4. INSERT INTO <Table2>
SQL Server Helper
How well do you know SQL? Find out with the free test assessment from SQL Server Helper!!!
Got a SQL Server Question? Ask us here: http://www.sql-server-helper.com/forums/default.asp