I began researching what could go wrong with a MSSQL2000 to MSSQL2008 migration today. I think it is mostly going to be weird fringe stuff. This posting suggests that you may prefix any column alias in MSSQL2000 without error which is a bug that was not "supported" in the later MSSQL versions.
SELECT name as gulla
FROM sysobjects
ORDER BY kulla.gulla
I wonder what other pain points we will hit...
No comments:
Post a Comment