SQL Server 2008 Upgrade Advisor
After installing the SQL Server 2008 Upgrade Advisor, Open the utlility by double clicking on it.
It will open the window as shown below,
On click of “Launch Upgrade Advisor Analysis Wizard”, it will open a window as shown below,
Click the next button it will open another window,
The server name will be loaded by default. If you want to trace another instance you can give the server name.
Tick the check box what components you are going to trace and click next button,
Give user name and password or select windows authentication.
Select the database you want to trace and click next
Click Run, it will start analyse your database.
Once analysis is complete then click launch report.
This is the result what you get once you click the Launch Report