SQL Server Performance Forum – Threads Archive
2005 Upgrade advisor reportHi! After executing the upgrade advisor tool on SQL Server 2000 we got the information messages as below, can some one please help me explaining about these messages.
you are a great help for me.
–> Remove references to undocumented system tables –> Other Database Engine upgrade issues –> Large backup or restore history tables make upgrade appear to hang –> Changes to behavior in syslockinfo and sp_lock –> Database maintenance plans superseded –> Outer join operators *= and =* are not supported in 90 compatibility mode –> Non-integer constants are not allowed in the ORDER BY clause in 90 compatibility mode –> Column aliases in ORDER BY clause cannot be prefixed by table alias –> Specify your SQL Server service account user name and password Thanks & Regards,
SQL Server DBA Mahi
I suggest to go to Microsoft Web to find out all the answers.
Those are incompatibilities with previus versions of 2005. Luis Martin
SQL-Server-Performance.com All in Love is Fair
All postings are provided â€œAS ISâ€ with no warranties for accuracy.
Check also under books online for SQL 2005 in this case, as they are mostly documented the process.
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing.