I have an MS SQL Server2008 database and have created 9 tables. One table has a primary key and I have used this key as a foreign keys in the rest 8 table. Now I have made 6 entries in these tables and I want to update this primary key and the foreign keys. What should I do? What query should I run? Please help me. Fred

Hi, Kindly post this on SQL forums its an exchange forum. I hope you will not mind. Regards. Shafaquat Ali.M.C.I.T.P Exchange 2007/2010, M.C.I.T.P Windows Server 2008, M.C.T.S OCS Server 2007 R2, Phone: +923008210320

Post your question in this forum instead, below is the link http://social.technet.microsoft.com/Forums/en-US/category/sqlserverJonas Andersson MCTS: Microsoft Exchange Server 2007/2010 | MCITP: EMA 2007/2010 | MCSE/MCSA Blog: http://www.testlabs.se/blog

Thanks guys