Hello,
I have tables which have relation. I want to know how can I set the PK value of table A which is the FK of table B while I can’t have “SET IDENTITY_INSERT BATTERY ON” for two table at one time?
Thank you,

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!!!
http://www.sql-server-helper.com/free-test/default.aspx

Got a SQL Server Question? Ask us here: http://www.sql-server-helper.com/forums/default.asp