Upgrade Advisor detected the use of outer join operators *= and =*. These operators are not supported in 90 or later compatibility ...

Upgrade Advisor detected the use of outer join operators *= and =*. These operators are not supported in 90 or later compatibility modes. When you upgrade to SQL Server 2008, user databases maintain their compatibility mode. In 80 compatibility mode, the *= and =* operators for outer joins are supported with a warning message. If you change the database compatibility mode to 90 or later, statements that use these operators will fail.

Upgrade Advisor detected that you do not have any queued updating subscriptions that use Microsoft Message Queuing (MSMQ). ... Upgrade Advisor detected that you have one or more merge publications on the Microsoft Desktop Engine (MSDE) instance you ... Upgrade Advisor detected that you might have one or more queued updating subscriptions that use Microsoft Message Queuing ... Upgrade Advisor detected that you no SQL Server Agent jobs related to replication on the MSDE instance you are upgrading. ... Upgrade Advisor detected the use of outer join operators *= and =*. These operators are not supported in 90 or later compatibility ... Upgrade Advisor detected the use of the FOR BROWSE clause in a view. The FOR BROWSE clause is allowed (and ignored) in views ... Upgrade Advisor detected the user name sys in a database. This name is reserved in SQL Server 2008. Rename the user before ... Upgrade Advisor detected two conflicting registrations for the same instance. Multiple registrations occur when the instance ... Upgrade Advisor detected UPDATETEXT statements that read and write to the same binary large objects (BLOB) by using the same ...