November 22, 2005 at 5:33 am
I am trying to use BCP to extract the results of stored procedures.
The server is accessible over the LAN but is slow to respond therefore I have problems with BCP returning a timeout message.
Is there anyway to increase the length of time that BCP will allow before giving the timeout message?
November 25, 2005 at 9:30 am
Mostly likely the remote query timeout is still set to 600 seconds and your bcp is running longer than that. Lookup 'remote query timeout option' in BOL for details of how to change it.
Regards
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
November 28, 2005 at 11:42 am
A good 'rule of thumb' is to execute the BCP on the database server to a local file then utilize XCOPY or some other utility to get the results where you need them.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply