Server: Msg 7399, Level 16, State 1,
I think that Q314530 at
http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B314530 applies
to your case.
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
Quote:
> I am getting following errors while using two separate
> SQLserver 2000 using links.
> I did changed "remote query timeout" to '0' as well
> still I am getting this error.
> Server: Msg 7399, Level 16, State 1, Line 11
> OLE DB provider 'SQLOLEDB' reported an error.
> Execution terminated by the provider because a resource
> limit was reached.
> [OLE/DB provider returned message: Timeout expired]
> OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
> ICommandText::
> Execute returned 0x80040e31:
> Execution terminated by the provider because a resource
> limit was reached.].
> Please help.
> Thanks in advance
