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)
Who is Participating?
Vitor MontalvãoConnect With a Mentor MSSQL Senior EngineerCommented:
BULK INSERT is the Transact SQL but I'm afraid you won't have all options available then.
More about BCP command:
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.
Vitor MontalvãoMSSQL Senior EngineerCommented:
Are you trying to export data to file?
If so you can use BCP command.
enrique_aeoAuthor Commented:
Hi acperkins: I find this option Command Timeout property?
Hi VMontalvao: which is the code that I use transact
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.