We have recently upgraded from SQL 2000 to SQL 2008 and you would think with my 10+ years experience that I would have known that the compatibility mode of the DB did not automatically change to 2008 when I configured the server. Be that as it may, I figured it out and changed it to 100.
However, we apparently have queries and logic that is not compatible with 100. So, I had to change it back to 80.
Is there a tool or an extended stored procedure that will identify all the things I need to change? It really isn't feasable for me to go through every single thing in the DB and check it.
I'm really bummed about this cause now I can't use some of the new features of SQL 2008
And there isn't any way to set certain things in the DB to 80 and other things to 100 is there?