I am upgrading SQL server 2008 to SQL server 2008 R2. I ran the Microsoft SQL Server 2008 R2 Upgrade Advisor tool and got the following after running it serveral times:
Each time the process returned errors that indicated the scan did not finish successfully. The process continued to fail around 48% and the only message i get is Deprecated SP. Timeout Expired. The timeout period elapsed prior to completeion of the oepration or the server is not responding.
SQL Server 2008 Standard Edition installed on WIndows Server 2008 SP2. Any ideas?
Ended up talking to Microsoft on this one. The Deprecated SP error just means that their are features that will not be available in SQL 2008 R2. Microsoft support gave the go ahead to do the upgrade:
http://msdn.microsoft.com/en-us/library/ms143729(v=sql.100).aspx