Click here to Skip to main content
15,896,544 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi Expert,

Sql Server Database table contains more than 1 millions entries.

And default sql server transaction timeout is 30 seconds.


I am using winform for front end(C#).

And some of the long running queries show


SQL
Unable to modify table.
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.



is there any disadvantage to increase default sql server transaction timeout?

Please help me.

sorry for poor english.

Thanks in adv.
Posted
Updated 3-May-13 22:06pm
v3

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900