Open file (from Generate Script) - Not enough storage error

• david_wier

  SSC Enthusiast

  Points: 110

  More actions

  March 11, 2011 at 9:53 pm

  #233234

  I generated a script from a database, to use on another server. The .sql script alone is 585 MB.

  When I try to open it in my other server, I get an error:

  "The operation could not be completed. Not enough storage is available to process this command."

  Anything I can do to get around this?

• Jo Pattyn

  SSC-Dedicated

  Points: 32348

  More actions

  March 14, 2011 at 6:53 am

  #1298291

  Interesting question

  Have a look at http://www.devcurry.com/2010/08/free-text-editors-to-open-large-text.html.

  Notepad++ chokes on big files (+100 mb)

• steveb.

  SSC-Forever

  Points: 46733

  More actions

  March 14, 2011 at 7:02 am

  #1298293

  Instead of opening it on the other server, you could run the script from the command line using SQLCMD

• david_wier

  SSC Enthusiast

  Points: 110

  More actions

  March 14, 2011 at 5:48 pm

  #1298628

  Working on it now - had never done sqlcmd before - - very interesting.

  thanks