Increase Sql timeout in .net

+1 A:

You could try setting the CommandTimeout property on your SqlCommand. I hope you are not doing this in an ASP.NET application.

Darin Dimitrov 2010-10-21 08:47:55

Thanks for replying, Darin. But for that I need to deploy the service again. Is there any way I can make changes in App.Config file so I don't need to deploy that service again?

Zerotoinfinite 2010-10-21 08:50:50

No, there is no way doing this in app.config.

Darin Dimitrov 2010-10-21 08:54:51

A:

The time out setting is up to database server.

In SQL Server Manager open the SQL Server Properties and pick the connection tab and set time out as big as You need.

Ps.

zero goes for no timeout.

Vash 2010-10-21 08:51:37

Thanks Vash. But I am getting .NET exception. If I am running the same stored procedure in SQL Server Managaement studio, it is allowing me to run that for the number of hours I want.

Zerotoinfinite 2010-10-21 08:55:51

+1 A:

You can set the timeout in your connection string with "connect Timeout = 100000000;" or whatever you want your timeout to be

Statler 2010-10-21 08:52:50

Can I put connection timeout in App.Config file?

Zerotoinfinite 2010-10-21 08:54:32

No, you can't. This will have absolutely no effect. Command Timeout in connection string is ignored.

Darin Dimitrov 2010-10-21 08:55:19

It works for me. You put it in your connection string, which is p in app.config or web.config if you set it up through a visual studio tool

Statler 2010-10-21 09:16:12

ansaurus

tags:

views:

answers:

Increase Sql timeout in .net

related questions