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).
