ISSUE:Server: Msg 7399, Level 16, State 1, Line 1OLE DB provider 'SQLOLEDB' reported an error. Execution terminated by the provider because a resource limit was reached.[OLE/DB provider returned message: Timeout expired]OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ICommandText::Execute returned 0x80040e31: Execution terminated by the provider because a resource limit was reached.].
*******************************
Server: Msg 7399, Level 16, State 1, Line 1OLE DB provider 'SQLOLEDB' reported an error. [OLE/DB provider returned message: Unspecified error][OLE/DB provider returned message: Timeout expired]OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDBSchemaRowset::GetRowset returned 0x80004005: ].
SOLUTION:
FIX: sp_configure 'remote query timeout', 0
go
reconfigure with override
go
Subscribe to:
Post Comments (Atom)

No comments:
Post a Comment