timeout exception
When the database increase let's say.. about 100MB, some queries give me this Exception of "Timeout Expired or server not available.."etc
I tried to find solution. I read about the SqlCommand and its "Timeout" property to set higher, but still the same error ocurrs.
I made some changes to queries, and for example they run in 30-40 sec. but,
if i get out with the tunning, then the database will grow more, and i will get again this error.The error ocurrs in .NET application, not when i run it in Sql analizer of MS SQL.
Could anybody tell me the real solution for this problem ? still, when i run any of this queries in Sql Analizer they run and give me the results.So i think it's some
problem maybe with .NET or the core of ADO.NET or some other settings, i don't know.Can i get some help please?
many thanks.
[942 byte] By [jasie24] at [2007-11-20 2:53:24] 