• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 540
  • Last Modified:

generate data scripts in SQL server 2008

hi experts, I'm trying to generate data scripts in SQL server 2008 and I have this
 errorValue timeout. The timeout period elapsed prior to completion of the operation or the server is not responding. (. Net SqlClient Data Provider)
errEXPORTAR.jpg
0
enrique_aeo
Asked:
enrique_aeo
  • 2
  • 2
1 Solution
 
Anthony PerkinsCommented:
That means that the query is taking longer than the default Command Timeout of 30 seconds or whatever value you set it.  If you feel that the script is as optimized as it can be, than you will have to resort to increasing the value for the Command Timeout property.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Are you trying to export data to file?
If so you can use BCP command.
0
 
enrique_aeoAuthor Commented:
Hi acperkins: I find this option Command Timeout property?
Hi VMontalvao: which is the code that I use transact
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
BULK INSERT is the Transact SQL but I'm afraid you won't have all options available then.
More about BCP command: http://msdn.microsoft.com/en-us/library/ms162802.aspx
0
 
Anthony PerkinsCommented:
>> I find this option Command Timeout property?<<
I am sorry, I thought your error  (". Net SqlClient Data Provider") came from an application you wrote.  Now I see you are running this from SSMS.
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now