Size limitation of MS SQL script

Is there a size limitation on a script for MS SQL? I was sent a script to insert data into a table. When I try to run it all I get is Query Execution failed. There is no further explanation. The script has insert commands for over 10,000 records. If I chop the script up into 1,000 record chunks they all go in so I am thinking the initial script is just too big.
LVL 1
rwheeler23Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

John TsioumprisSoftware & Systems EngineerCommented:
How are you running the script...?
Recently i run a script for insert a 1GB worth of data...
rwheeler23Author Commented:
I simply took the entire script and copied it into SSMS. This is SQL 2014. This computer only has 8GB RAM so perhaps that is what is causing the limitation.
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Yes, you have and the default Batch size is 65,536 * Network Packet Size. Network Packet size is defaulted to 4K.
And hence you need to use GO statements appropriately to limit the Batch size.

https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rwheeler23Author Commented:
Thanks
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SQL

From novice to tech pro — start learning today.