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 |
|
yaman
Posting Yak Master
213 Posts |
 Posted - 2009-09-22 : 12:47:17
|
| Sir , I have one Stored Procedure which is used to fetch data from source using link server .Now its takes time to fetch data .This stored procedure call from VB.net Code .When ever procedure call .We get error "connection time out"sir , is there any way to resolve this problem from database side .ThanksYaman |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2009-09-22 : 13:29:31
|
| proabably - but first a couple questions:if you're calling the procedure from an application then why not connect directly to the server that has the procedure rather than using a "linked" server?if you call the procedure locally from a query window, how long does it take to complete? How many columns and rows are turned? Are any of the columns very large (ie: more than 8K of data)Be One with the OptimizerTG |
 |
|
|
yaman
Posting Yak Master
213 Posts |
Posted - 2009-09-22 : 13:58:04
|
quote:
Originally posted by TG
proabably - but first a couple questions:if you're calling the procedure from an application then why not connect directly to the server that has the procedure rather than using a "linked" server?if you call the procedure locally from a query window, how long does it take to complete? How many columns and rows are turned? Are any of the columns very large (ie: more than 8K of data)Be One with the OptimizerTG
1.) Because i m fetching data from remote server . 2.) Procedure take 4 to 5 miniute Procedure returns Number of columns 13 and Number of rows 15000Yaman |
|
|
|
|
|
|
Connecion Time out Problem