Are you able to select rows from the table in SQL Server Management Studio?
There can be two types of timeouts - connection timeout and command timeout. Connection timeout happens if the connection to the server cannot be established within a certain amount of time (15 sec default). Command timeout happens when the query takes longer than a certain amount of time (30 sec default).
Depending on what type of timeout it is, investigate the cause, and perhaps increase the timeout if there is a rationale for doing so. You can set the timeouts in most client frameworks (In .Net code Connection and Command objects have those properties)
I viewed the codes in View by choosing right click on the View and choose "Design". I copy the codes from the View and modified it it in a different query window. Then I copied and pasted the modified codes back to codes section in the "Design" window of the View, then click on the red exlamatory button to run the codes. I was told by my boss that I can't run the query in "Design" window of the View. I didn't know that I can't do that. I end up checking the syntax of the modified codes and save the View with the modified codes. I was able to query from the View.
Error Message: Timeout expired on View
Posted - 03/12/2013 : 11:23:20
