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
No comments:
Post a Comment