November 20, 2014 at 2:10 am
Can anyone tell us if my changing the compatibility mode of a SQL Server 2005 database from 80 to 90 generate error log with list of all objects with error descriptiobn against each that are not compatible to 90? In case of error, will the SQL Server save the new compatibility mode or revert to 80?
November 20, 2014 at 2:16 am
It won't generate anything and there are no checks done when you change the compat level.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 20, 2014 at 5:03 am
Thansk for the response. Then what is the best way to get a list of objects that are not compatible with upgraded level and the issues associated with them?
November 20, 2014 at 5:07 am
By testing before you make the change.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 20, 2014 at 5:16 am
Please elaborate. I desparately need a solution for this ASAP and your response can help me!
November 20, 2014 at 5:34 am
You test your application against a test database that's already been upgraded, you identify any issues and you fix them. Once the tests run clean, then you update the compatibility level on production.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply