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