"The timeout period elapsed prior to completion of the operation or the server is not responding"

SQL SERVER: 2005
when running a view or query with very long execution time, you may see the
following error message from Management Studio.

---------------------------
Microsoft SQL Server Management Studio
---------------------------
SQL Execution Error.
--
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.
---------------------------
OK Help
---------------------------


From Query Analyzer:

Msg -2, Level 11, State 0, Line 0
Timeout expired. The timeout period elapsed prior to completion of the operation
or the server is not responding.

Resolution:
====================
1. Please check the Execution time-out Settings first. Make sure those are 0.
a. Open SSMS (SQL SERVER Management Studio). Tools->Options->Query Execution->SQL
SERVER->General: Execution time-out. Set to 0.
b. Open a new Query window from SSMS. Query->Query Options->Execution->General:
Execution time-out. Set to 0.
c. On SSMS, File->new->Database Engine Query->Options->[Connection
Properties]->Execution time-out. Set to 0.

d. Please reopen SSMS.
e. If issue persists - go to step 2:

2. Please open sqlcmd connection and try to execute the same query. Based on the
error message you receive there you may continue troubleshooting further. It may
involve collecting PSSDIAG / trace / dumps as per the requirement.