The Upgrade Advisor detected a script that contains a colon (:) following a reserved keyword. In earlier versions of SQL Server, this syntax is ignored and the statements execute successfully. In SQL Server 2005 and later, this syntax causes the statement to fail when the database compatibility mode is set to 90 or later. When you upgrade to SQL Server 2008, user databases maintain their compatibility mode. Using a colon after a reserved keyword is ignored when the database compatibility mode is set to 80 or earlier.
The update job for the database mirroring monitor already exists. To change the update period, use sys.sp_dbmmonitorchangemonitoring ...
The update operation failed because the data source view identifies the column (table '%{table/}', column '%{column/}') as ...
The Update Statistics task ensures the query optimizer has up-to-date information about the distribution of data values in ...
The Upgrade Advisor Analysis Wizard examines your instances of SQL Server 2000, SQL Server 2005 and SQL Server 2008 for issues ...
The Upgrade Advisor detected a script that contains a colon (:) following a reserved keyword. In earlier versions of SQL ...
The Upgrade Advisor detected duplicate login security identifiers (SID). Remove one of the logins and associated users before ...
The Upgrade Advisor detected nonstandard column-level permissions on system objects. These permission changes will not be ...
The Upgrade Advisor detected one or more user-defined login names that match the names of fixed server roles. Fixed server ...
The Upgrade Advisor detected user-defined functions that are owned by the undocumented user system_function_schema. In SQL ...