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 |
|
PavanKK
Starting Member
32 Posts |
 Posted - 2010-09-13 : 02:56:26
|
Hi Forum,We have setup a linked server pointing to our Production server.We have created a view ( select * from linkedserver.database.dbo.table where customerid = 2 ) which will retrieve 25 lacs records from linked server ( 4 part naming convention ). At the time of execution the view is getting timedout error because of the bulk records. Is there any way that I can get all the records from linked server without timeout issue.Thanks in advanceKK  |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
|
|
|
Linked server Query Timedout