Hi guys -
I have a big sql file (~6gig) that I'm trying to execute via sqlcmd. It's just a bunch of inserts that were generated using the 'generate scripts' sql tool.
So I connect just fine
> sqlcmd -S .\SQL2008 -d MyDatabase -i "C:\sqlscript.sql"
This happens regardless if i do the -e or not.
So it goes through stuff for a while and then in execution i get:
HResult 0xE9, Level 16, State 1
Shared Memory Provider: No process is on the other end of the pipe.
Sqlcmd: Error: Microsoft SQL Native Client : Communication link failure
Stuff does happen though since some records do get inserted.
Server timeout is set to 0. Named pipes and TCPIP are turned on
Any clue how to get the rest of the file to load in? I'm running SQL Server 2008 on Windows 7 64bit