Server: Msg 7399, Level 16, State 1, 
Author Message
 Server: Msg 7399, Level 16, State 1,

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



Sun, 18 Sep 2005 20:26:05 GMT
 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



Mon, 19 Sep 2005 07:25:32 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Server: Msg 7399, Level 16, State 1, Line 1 error on .mdb as linked server

2. Server: Msg 7399, Level 16, State 1, Line 1 error on .mdb as linked server

3. Server: Msg 7399, Level 16, State 1, Line 1

4. Help.Error: Msg 7399, Level 16, State 1, Line 1

5. Server: Msg 7619, Level 16, State 1, Line 2

6. Server: Msg 2812, Level 16, State 62

7. Server Msg 5172, Level 16, State 15, Line1

8. Server: Msg 8115, Level 16, State 2, Procedure sp_monitor, Line 94

9. Server: Msg 7354, Level 16, State 1, Line 1

10. Error: Server: MSG 7392, Level 16, State 2

11. Server: Msg 1540, Level 16, State 1

12. Server: Msg 547, Level 16, State 1, Line 6


 
Powered by phpBB® Forum Software