I am changing a database's compatibility mode from 90 (SQL Server 2005) to 110 (SQL 2012) and I am wondering at what point would I see errors from breaking changes if there are any.
I ran Upgrade Advisor 2012 which spotted several Stored Procedures that needed updating. An example was:
"In SQL Server 2005 or later, column aliases in the ORDER BY clause cannot be prefixed by the table alias."
However, when I run this stored procedure in SQL 2012 (without having made changes) it doesn't show any errors. Also, when I changed the database compatibility level from 90 to 110 there were also no errors. Nor when I restored the database.
If I am not seeing errors anywhere, I am hoping that Upgrade Advisor caught everything. Is there any other ways I should check for compatibility errors?
Also, how is it possible that this stored procedure ran successfully even though Upgrade Advisor told me it would fail? Thanks :)