Posted by Roy Harvey (SQL Server MVP) on 11/01/07 01:24

On Wed, 31 Oct 2007 17:02:36 -0700, "mitchman10@gmail.com"
<mitchman10@gmail.com> wrote:

>I have a query file, test.sql, in the root of my C drive. It is
>400,000 lines worth of insert into statements and is so big i cannot
>load in into management studio. How can I run this?

Add a line with nothing but a GO every, oh say after every 100 INSERT
commands. Then you could TRY to execute the file using the command
line utilities OSQL or SQLCMD. I'm not sure if they will choke on a
file that size as I've never had reason to test them in that way.

Roy Harvey
Beacon Falls, CT

[Back to original message]