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 AFTER trigger nested inside an INSTEAD OF trigger that is defined on one or more tables. Nested AFTER triggers that do not fire in SQL Server 2000 may fire in SQL Server 2005 or later, even when the nested triggers server configuration option is set to 0. Review your applications for nested triggers to determine whether the applications still comply with your business rules with regard to this new behavior when the nested triggers server configuration option is set to 0, and then make appropriate modifications.

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 ... Upgrade Advisor detected DISK INIT statements. The DISK INIT statement, used in earlier versions of SQL Server to create ...