SQL Server 错误 - HRESULT E_FAIL 已从对 COM 组件的调用返回 [英] SQL Server Error - HRESULT E_FAIL has been returned from a call to a COM component

问题描述

我有一个巨大的 200MB .SQL 文件.当我尝试在 SQL server management studio 2008 中打开它时，我收到错误 -Error HRESULT E_FAIL has been returned from a call to a COM component.

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.

可能是什么原因以及如何解决?这是由于大文件引起的吗?当我打开 2-3 KB 文件时不会发生这种情况.

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.

推荐答案

请使用

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

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

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

这篇关于SQL Server 错误 - HRESULT E_FAIL 已从对 COM 组件的调用返回的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！