<p>I have a database table on a development server that is now fully populated after I set it running with an import routine for a CSV file containing 1.4 million rows.</p>

<p>I ran the Database Publishing Wizard on the table, and now I have a 286MB SQL script on my local machine.  The problem is, I can't figure out how to run it.  If I load it into SQL Server Management Studio Express I get an alert window that says "The operation could not be completed".</p>

<p>Any ideas on how I can get this SQL script to run?</p>

use the
sqlcmd
tool to execute the file..
```
```
sqlcmd -S myServer\instanceName -i C:\myScript.sql
```
```
In case your have an unexplained "script error" for large sql files (> 100MB) which includes several INSERT, just replace "INSERT INTO" by "GO INSERT INTO" in your file, which will reduce size of transaction.