Error on link Servers

Hi,
I am getting below error on link server and the performance between the link
server looks pathetic. Kindly suggest.
Executed as user: NT AUTHORITY\SYSTEM. OLE DB provider 'SQLOLEDB' reported
an error. Execution terminated by the provider because a resource limit was
reached. [SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error 731
2) OLE
DB error trace [OLE/DB Provider 'SQLOLEDB' ICommandText::Execute returne
d
0x80040e31: Execution terminated by the provider because a resource limit
was reached.]. [SQLSTATE 01000] (Error 7300).Hi
"Execution terminated by the provider because a resource limit was reached"
is a good indication. Check the destination server has enough connections an
d
resources. Check the SQL event logs on both servers.
Regards
Mike
"smiley" wrote:

> Hi,
> I am getting below error on link server and the performance between the li
nk
> server looks pathetic. Kindly suggest.
> Executed as user: NT AUTHORITY\SYSTEM. OLE DB provider 'SQLOLEDB' reported
> an error. Execution terminated by the provider because a resource limit wa
s
> reached. [SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error 7
312) OLE
> DB error trace [OLE/DB Provider 'SQLOLEDB' ICommandText::Execute retur
ned
> 0x80040e31: Execution terminated by the provider because a resource limit
> was reached.]. [SQLSTATE 01000] (Error 7300).
>