cannot excute script

[Jet]

i exported data in a table from an apache derby dbase to a sql script so i could run on MS SQL(Studio Express) to get the data in my table but then there is this script for this table anytime i try running the script i get the following error msg. before this the script would not even open the Studio when i try opening it and an err msg of "out of memmory would pop up" please help me as to how i can solve this errror. . TITLE: Microsoft SQL Server Management Studio Express ------------------------------ Cannot execute script. ------------------------------ ADDITIONAL INFORMATION: Exception of type 'System.OutOfMemoryException' was thrown. (mscorlib) ------------------------------

[Lost User]

How big is that script? Have you considered loading and executing it piece by piece? You can execute scripts from the commandline, without open the Management Studio. That's described here; http://msdn.microsoft.com/en-us/library/ms165702.aspx

I are Troll :suss:

[Jet]

thanks for attending to my question. the size is 65.2MB.. i am going to loading in pieces.. and post my response back...

[Mycroft Holmes]

I envisaged a low powered machine or something. I never imagined a 65mb script X| what a monster. I don't think I have ever seen such a beast.

Never underestimate the power of human stupidity RAH

[Jet]

it can't be low powered machine(4GB RAM, 2.8GHz Duo Core) i finally exported it to csv and ported it excel. i had all data in there so just wrote some sql statemet to import the data..into my tables. the whole dbase is in apache derby and i need all of them in a platform i am comfortable with. thanks