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

Question

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.

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

Solution

please use

sqlcmd -S .\MYSQLSERVER2008 -U MyUsername -P MyPassword -i C:\Database\script.sql

http://technet.microsoft.com/en-us/library/ms180944.aspx

Comments

[pipedreambomb]

Thanks. For me, I got away with just sqlcmd -S localhost -i C:\Database\script.sql.