enrique_aeo
asked on
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
errorValue timeout. The timeout period elapsed prior to completion of the operation or the server is not responding. (. Net SqlClient Data Provider)
errEXPORTAR.jpg
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.
Are you trying to export data to file?
If so you can use BCP command.
If so you can use BCP command.
ASKER
Hi acperkins: I find this option Command Timeout property?
Hi VMontalvao: which is the code that I use transact
Hi VMontalvao: which is the code that I use transact
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>> 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.
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.