Search for T-SQL errors post Compatibility Level Change
I have a database that who's compatibility level was just changed from 70 to 100. Unfortunately, not much thought was given prior to the upgrade. So far most has gone smoothly, however there have been a few odd things pop up. Mostly T-SQL syntax errors which are easily fixed. Is there a tool I can run on SQL 2008 R2 to look for and find any views or stored procedures that need fixing? Thanks so much for your help.