Restore 2000 backup to 2008

[djj55]

Hello,
thread962-1387749 among others say the database will be upgraded to 2008, what about the "Compatibility Level"? Should I change it to 100?

Thank you,

djj
The Lord is My Shepard (Psalm 23) - I need someone to lead me!

 

[gmmastros]

Sometimes you NEED to have a lower compatibility level for your code to work properly. The only way to know for sure is to test it.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[djj55]

Thank you. As I just had to tell my manager today that I forgot to test some of the procedures, I have been testing away. Luckily I had not missed many.

Biggest problems are xp_sendmail (easy to fix) and sp_makewebtask (I got the .NET developers involved). Have to watch the implicit conversions. Also still have a few xp_cmdshell's out there but the .NET people are taking care of that when they can.

djj
The Lord is My Shepard (Psalm 23) - I need someone to lead me!