Posted by Ed Murphy on 11/01/07 01:38

Roy Harvey (SQL Server MVP) wrote:

> 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.

Failing that, split it up into multiple files (by whatever means you
like) and execute them individually.

[Back to original message]