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