I 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 1
Shared 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 2008
Is 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.