HI,
I am getting below error on link server. And the performance between
link server is really pathatic.

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 7312) OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
ICommandText::Execute returned 0x80040e31: Execution terminated by the
provider because a resource limit was reached.]. [SQLSTATE 01000]
(Error 7300).

Hi,

It looks like that's a generic error. Pretty hard to troubleshoot..

Please read the following for more info on this.. Also, if/when you've
got more details (using the trace) and you're still experiencing issues
please post the query you're executing and the volume of data being
transferred between the servers..

http://support.microsoft.com/default.aspx?scid=314530

Greg