I get the following message when running a complex query in SSMS
sql execution error
executed sql statement: SELECT list of table names…
error source: .Net SqlClient Data Provider
error message Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
I have increased the timeout period 600 secs on both the connection and query duration.
I am seeking some general assessments first.