Upgrade Advisor has detected that the AUTO_UPDATE_STATISTICS database SET option is OFF. As a result, database statistics ...

Upgrade Advisor has detected that the AUTO_UPDATE_STATISTICS database SET option is OFF. As a result, database statistics are not being updated as part of the upgrade to SQL Server 2008. Relying on statistics from a previous version of SQL Server may result in query plans that are suboptimal. By setting AUTO_UPDATE_STATISTICS to ON, all statistics are updated when they are first referenced. Updating statistics increases the likelihood that more optimal query plans are selected when executing queries.

Upgrade Advisor either could not find the instance and application databases, or the databases are corrupt. Make sure the ... Upgrade Advisor found that you are using SQL Server Authentication for one or more local connections for agents. On upgrade ... Upgrade Advisor has detected an index on a view with the IGNORE_DUP_KEY option set to ON. In SQL Server 2005 or later, this ... Upgrade Advisor has detected duplicate table or view index names. Rename the indexes to remove duplicates before upgrading ... Upgrade Advisor has detected that the AUTO_UPDATE_STATISTICS database SET option is OFF. As a result, database statistics ... Upgrade Advisor has detected that you are using log shipping. SQL Server 2000 log shipping is incompatible with log shipping ... Upgrade Advisor has detected the 0xFFFF character in an object identifier. In SQL Server 2005 and later, objects such as ... Upgrade Advisor is unable to scan packages with invalid characters (/ \ : . =) in the package name. Rename DTS packages that ... Upgrade Advisor is unable to scan packages with password protection. To scan encrypted DTS packages, use the SSIS Package ...