InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 08:55:13 GMT20http://www.sqlservercentral.com/Forums/Topic643010-32-1.aspxnice basic question :-)Mon, 28 Jan 2013 05:18:03 GMTkapil_kkhttp://www.sqlservercentral.com/Forums/Topic643010-32-1.aspx[quote][b]Adi Cohn (1/26/2009)[/b][hr]I think that the answer “You cannot set IDENTITY_INSERT on for more than one table in a database” should be changed to You cannot set IDENTITY_INSERT on for more than one table at the same time in a SESSION.Adi[/quote]true. very misleadingWed, 18 Mar 2009 10:38:08 GMTsi_downeshttp://www.sqlservercentral.com/Forums/Topic643010-32-1.aspxCorrecting the question now. good points about the session.Tue, 27 Jan 2009 09:06:35 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic643010-32-1.aspxhmmm, over-think question we are. IDENTITY_INSERT is the heart of the question, not design of the tables.Mon, 26 Jan 2009 21:29:17 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic643010-32-1.aspxDoes anybody else but me think that Order_details is designed wrongly? OrderID should be a foreign key to Orders.OrderID. The natural key of Order_Details is OrderID and LineItemID which does not require an IDENTITY column at all.;)Mon, 26 Jan 2009 20:02:36 GMTRichard Barberhttp://www.sqlservercentral.com/Forums/Topic643010-32-1.aspx[quote]You want to correct a problem with two of your tables with keys created by identity values. [/quote]Personally I think this implies that there is erroneous data to be removed before an insert. Inserting without deleting will simply add data without rectifying the problem. (generalisation)Mon, 26 Jan 2009 15:16:57 GMTjmcleishhttp://www.sqlservercentral.com/Forums/Topic643010-32-1.aspx[quote][b]Adi Cohn (1/26/2009)[/b][hr]I think that the answer “You cannot set IDENTITY_INSERT on for more than one table in a database” should be changed to You cannot set IDENTITY_INSERT on for more than one table at the same time in a SESSION.Adi[/quote]To clarify further I would think You cannot set IDENTITY_INSERT on for more than one table AT A TIME in a SESSION.:)Mon, 26 Jan 2009 08:19:13 GMTSuperDBA-207096http://www.sqlservercentral.com/Forums/Topic643010-32-1.aspxI think that the answer “You cannot set IDENTITY_INSERT on for more than one table in a database” should be changed to You cannot set IDENTITY_INSERT on for more than one table at the same time in a SESSION.AdiMon, 26 Jan 2009 01:40:19 GMTAdi Cohn-120898http://www.sqlservercentral.com/Forums/Topic643010-32-1.aspxComments posted to this topic are about the item [B]<A HREF="/questions/T-SQL/65488/">IDENTITY_INSERT</A>[/B]Sat, 24 Jan 2009 11:16:36 GMTSteve Jones - SSC Editor