SQL Server Error - HRESULT E_FAIL was returned from a COM component call

Question

I have a huge 200 MB file. SQL When I try to open this in SQL Server 2008 Management Studio, I get the error message -Error HRESULT E_FAIL was returned from a COM component call.

What is the reason and how to fix it? Is this caused by large files? This does not happen when I open a 2-3 KB file.

Answer 1

use

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

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