We have recently upgraded our DB from SQL 2000 to SQL 2008. I was not aware that the compatibility modes would remain as if it were a 2000 database. I tried to change it to 2008 (100) but stuff in our front end application started erroring out with deprecated code.
Is there a third party tool or some extended stored procedure that will automatically check the database to see what is not compatible with 2008? I'm sort of bummed out cause I cannot use any of the new SQL 2008 stuff unless I get this fixed. Its not really feasible for me to manually go in a check every single code object to make sure there are no deprecated syntaxes.
I wish there was a way to set certain stored procedures to run in SQL 2008 and then let the old stuff run in 2000.