troubleshooting Question

SQL Compatibility Modes - From 80 to 100

Avatar of Roxanne25
Roxanne25 asked on
Microsoft SQL ServerMicrosoft SQL Server 2008
6 Comments2 Solutions807 ViewsLast Modified:
Hi there,

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.
IT super hero

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros