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.
ASKER CERTIFIED SOLUTION
x-men
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