Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
GavinS
Starting Member
14 Posts |
 Posted - 2005-08-12 : 03:14:33
|
| Hello,A work colleague is receiving the follow error while querying on linked servers. Can anyone enlighten me on this?Server: Msg 7399, Level 16, State 1, Line 15OLE 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.].Thanks,Gavin |
|
|
GavinS
Starting Member
14 Posts |
Posted - 2005-08-12 : 04:18:29
|
| And to add to that I have made sure the remote query timeout is set to zero (infinite) on all of the linked server properties.Gavin |
 |
|
|
cantoniak
Starting Member
1 Post |
Posted - 2005-08-30 : 12:04:31
|
| I'm having the same problem. I thought the problem had something to do with linked servers... I'm running a query on that copies data from a table on Server1 to a table on Server2. I'm getting the same exact error stated above. Have you found a solution for this yet?Chris Antoniak MCP |
|
|
|
|
|
|
Linked Server Error