Post reply

Potential Issues Modifying Compatability Level?

  • April 2, 2014 at 9:32 am

    #305904

    I would like to change the compatability level of some of my databases from 80 to 100. Do you know of any potential issues doing this? Anything I should look out for?

  • April 2, 2014 at 10:33 am

    #1702550

    The big issues are keyword clashes. Something allowed in SQL Server 2000 (v8) might be disallowed in 2008. I think the outer joins, with non ANSI syntax might be an issue. Hard to remember everything that has changed.

    Often people run the Upgrade Advisor against the database to check things. I'd do this.

  • April 2, 2014 at 10:45 am

    #1702557

    Nothing popped up when I ran that. Does that mean I shouldn't upgrade compatability?

  • April 2, 2014 at 10:56 am

    #1702558

    If nothing popped up then it didn't detect anything. You can change it and if there are issues, then you can change it back. It's not a physical change.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply