SQL Server Upgrade Advisor Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

One of the client referred about the error during the execution of Upgrade Advisor: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Initial thoughts lead to checking the SQL Server timeout setting which has been left with default value 0, also further information of this message given the string : FTNONPERSISTEDCOMPCOL. So the books online and other web resource search lead to root cause could be upgrade and replication issues. So...(<a href="http://sqlserver-qa.net/blogs/tools/archive/2008/02/13/timeout-expired-the-timeout-period-elapsed-prior-to-completion-of-the-operation-or-the-server-is-not-responding-ftnonpersistedcompcol.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=3435" width="1" height="1">