>>When running the site with SQL Server, I have found that the access to certain tables will take longer at first because the tables haven't been accessed yet. So, at first, it may take a little bit longer to process the hit. So, on big tables, I might end up with a Timeout expired message. I need to increase that in the database. Where can I go to adjust that?
>
>Use ConnectTimeout or Connection Timeout keywords in the connection string. Something like this:
>
>string myConnectionString = "Data Source=(local);Initial Catalog=AdventureWorks;Integrated Security=SSPI;Connection Timeout=30";
>
I think the connection timeout only relates to the time taken to obtain the connection......