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 2012. 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 may be unable to scan a package for reasons that include a corrupted file, insufficient permissions, or other ...
Upgrade Advisor was unable to analyze Integration Services packages. For more information, see the Upgrade Advisor log file ...