>Hello all,
>
>I have a console application (C#.NET) running that performs batch type job executions to my SQL Server database. Occassionally, I have been getting a SQL timeout error when running some jobs.
>
>My question is what is the default timeout parameter for SQL Server in this situation? (I am guessing 30 seconds). Since this is a batch job, I want to increase the timeout parameter to at least 60 seconds or more. How do I do this? I would think it would be a parameter in the connection string in the config file but I haven't found anything yet in my searches on how do this.
>
>TIA for any help with this.
>
>Bob
Depending on where the timeout is happening, see..
http://stackoverflow.com/questions/3752545/sql-server-2008-update-query-timeoutor
http://technet.microsoft.com/en-us/library/ms177457.aspx (use sp_Configure to set it)
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________