I'm looking for success stories and tips for anyone who has moved from MS SQL Server 65 compatibility level to 80 at a developer level. My company is currently trying to migrate to 80 but the stored procedure maintenance is overwhelming to say the least. Some of our procedures aren't even ansi-92 standardized. Any insight on how to tackle this ordeal successfully would be of much help.
