SQL Server Error - HRESULT E_FAIL has been returned from a call to a COM component

• blasto_max

  SSCertifiable

  Points: 5025

  More actions

  October 29, 2013 at 6:55 pm

  #279329

  I have a huge 200MB .SQL file. When I try to open this in SQL server management studio 2008, I get the error -Error HRESULT E_FAIL has been returned from a call to a COM component. I am not sure if there is an error in my queries. But, I suspect that the reason could be that the file is too big.

  What could the reason be and how to fix it ? It does not happen when I open a 2-3 KB file.

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  October 31, 2013 at 4:24 am

  #1662976

  A 200 MB .sql file? I guess it contains data, does it?

  Run it using sqlcmd.

  If you need to edit, try with a different text editor.

  -- Gianluca Sartori