SQL timeout issue
I'm using SQL express and during my application startup, i do a basic query to the database.
(e.g select column1 from table1)
This table only has 30 records but the rest of the tables has many. Because my app runs the query to this table first, i get the error. My database size is 2.0 GB (i know it's huge)
My timeout limit i set is 60 seconds. IS there any other solution for this rather than increasing the timeout value?
This timeout issue only happens on and off... but not always. I'm using C# with .Net 2.0.
Thanks
Back after a long hibernation.