InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 09:42:41 GMT20http://www.sqlservercentral.com/Forums/Topic1369349-392-1.aspxThis reminds me, now I try to use:Insert into...Select * from another tableThis makes it run very fast.Mon, 08 Oct 2012 16:10:34 GMTsqlfriendshttp://www.sqlservercentral.com/Forums/Topic1369349-392-1.aspxI don't know what the data looks like in the file but why not just use BULK INSERT?Sat, 06 Oct 2012 13:43:52 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic1369349-392-1.aspxTry running the script using sqlcmd. I have had this same issue with a few rather large scripts. Wouldn't run in SSMS but ran fine when I ran it from the command line using sqlcmd.Fri, 05 Oct 2012 23:43:55 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic1369349-392-1.aspxYa i faced the same issue while creating a one time script . Since it was meant for another team , so I just had it executed in 5000 records batch.. it could be a workaround..Fri, 05 Oct 2012 22:25:17 GMTdemonfoxhttp://www.sqlservercentral.com/Forums/Topic1369349-392-1.aspxI have build database script, and one part of them is to insert data, so I have multiple insert statements 300000 records, it runs on and on, and later gives an error:HResult 0xE9, Level 16, State 1Shared Memory Provider: No process is on the other end of the pipe.Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : Communication link failure.Is there a limitation of records? what does this message mean?If I run it directly in SSMS, just a few records, it is OK, but if all of them,it gives an error insufficient memory to continue the execution of the program sql server 2008Is there another option to insert these records, I know SSIS, but for this, because it is using a build script, so SSIS will not work.ThanksThanksFri, 05 Oct 2012 17:34:55 GMTsqlfriends