Upgrade Advisor detected a view that uses the WITH CHECK OPTION and a TOP clause in the SELECT statement of the view or in ...

Upgrade Advisor detected a view that uses the WITH CHECK OPTION and a TOP clause in the SELECT statement of the view or in a referenced view. Views defined this way incorrectly allow data to be modified through the view and may produce inaccurate results when the database compatibility mode is set to 80 and earlier. Data cannot be inserted or updated through a view that uses WITH CHECK OPTION when the view or a referenced view uses the TOP clause and the database compatibility mode is set to 90 or later.

Upgrade Advisor could not detect SQL Server components on the server. Please check if current user has the privilege to access ... Upgrade Advisor detected a database with the database ID 32767. In SQL Server 2005 or later, this database ID is reserved. ... Upgrade Advisor detected a filegroup that is either set to read-only or is not in a writeable state. All filegroups must ... Upgrade Advisor detected a trigger that uses the SET XACT_ABORT OFF statement. In 80 compatibility mode, SET XACT_ABORT OFF ... Upgrade Advisor detected a view that uses the WITH CHECK OPTION and a TOP clause in the SELECT statement of the view or in ... Upgrade Advisor detected an AFTER trigger nested inside an INSTEAD OF trigger that is defined on one or more tables. Nested ... Upgrade Advisor detected an instance of SQL Server running under a Network Service or Local Service account on a Microsoft ... Upgrade Advisor detected data or log files that are not set to autogrow. In SQL Server 2005 and later, new and enhanced features ... Upgrade Advisor detected database files on a compressed drive. SQL Server 2008 cannot create or upgrade databases on compressed ...