>>I've never tried this myself....I'm simply posting a link that talks about this, with some solutions at the bottom. So I don't know if this will work, but I suppose it's worth a try.
>>
>>(Unless one else here has run into the same thing and has a different solution)
>>
>>
http://wishmesh.com/2013/02/executing-very-large-script-on-microsoft-sql-server-2008-r2-fails/>
>Thanks, that would certainly work.
>
>However, I think I will add support in my framework to script a table as bulk insert. I usually insert 2000 records at a time. So, basically, to insert 140000 records, it would take 70 executions. I will see how that works.
Just curious, why is the script so big? If it's all manual inserts, then yes, you might want to look at putting the data in some text/CSV file and try a bulk load