'SQLOLEDB' Reported an Error. Execution Terminated by the Provider Because a Resource Limit was Reached

---

When running a query from a remote server I am getting the next error:

'SQLOLEDB' Reported an Error. Execution Terminated by the Provider Because a Resource Limit was Reached

The problem is that the remote query timeout setting in Microsoft SQL Server is set too low for the query to complete.

In order to fix the problem we need to reset the time out value on the remote query settings.

To check the current value, execute the following command in Query Analyzer:

sp_configure 'remote query timeout'

To reset the remote query setting, execute the following commands in Query Analyzer:

sp_configure 'remote query timeout', n

go

reconfigure with override

go

Where n is the new timeout value.

Using '0' for n will set the timeout to infinite timeout.

This update should be performed by, or with the input of the database administrator to ensure the new setting is appropriate for your environment.

Source:

http://support.microsoft.com/kb/966725

---

---