Pretty much what the topic says...we are preparig to upgrade our SQL Server 2000 to 2008 and was curious if there are any hurdles that I should be aware of?
-George
Microsoft SQL Server MVP My Blogs SQLCop twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
yes. Run the upgrade wizard. The old joins (=* *=) need to be re-written. Does your process use textcopy.exe? It doesn't exist in SS2008. Table hints change. Column aliases in Order By cannot be prefixed by the table alias.
There are lot of other issues when you upgrade to SS2008 from SS2000 - so run the upgrade wizard to see what you need to fix.
-SQLBill
The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875
Thanks guys...I ran the wizard and it fould Full-Text searches needed to be changed (but we don't use them so I think this is ok) and a few Keywords that have depreciated which will need changing. What a life-saver this app is. Thanks for the help! Oh and yes, we ran it in our Staging environment first (which is identical to our Production environment).
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.