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

When loading large files – over 100MB with  Sql Server Management Studio 2008 you might get the following error:
Error HRESULT E_FAIL has been returned from a call to a COM component.

The Solution is run CMD (Run As Administrator) then type the script below :

 sqlcmd -S [server] -U [username] -P [password] -i [path file of sql script]  

Example :

 sqlcmd -S .\MYSQLSERVER -U sa -P pass -i C:\Database\newscript.sql  

Anda sedang membaca artikel tentang Error HRESULT E_FAIL has been returned from a call to a COM component (SQL Server) dan anda bisa menemukan artikel Error HRESULT E_FAIL has been returned from a call to a COM component (SQL Server) ini dengan url http://wellysundawa.blogspot.com/2014/06/error-hresult-efail-has-been-returned.html

Anda boleh menyebarluaskan atau mengcopy-paste jika artikel Error HRESULT E_FAIL has been returned from a call to a COM component (SQL Server) ini sangat bermanfaat bagi teman-teman anda, namun jangan lupa untuk meletakkan link Error HRESULT E_FAIL has been returned from a call to a COM component (SQL Server) sebagai sumbernya.

-- Welly Sundawa Well Blog --

Posted in: Tutorial