I had read that running a SQL2005 database at lower than its Native 90 Compatibility Mode reduces performance. If that is true then I think it significant enough tog et the vendor to do something about it!
I think there is also a mistaken belief that maintaining 90 to remain compatible with SQL 2000 means that it isn't necessary to re-test the app. That is just nuts! SQL 2005 contains lots of new code, any bit of which MIGHT have a bug, or a different way of working. And given that, IMHO, it is essential to retest an application for a new version of SQL server then you/your vendor might as well try the latest Compatibility Mode and retest using that!
Thanks, i was testing the new convesion on SQL 2005 put in 90 mode logged into the ERP system and viola gives me cannot run in 80 mode i was you are kidding me.....Sent email to vendor and said get me the correct software
I get details of the findings especially the performance part and send them .