Need ur opinions. I have a client (web provider) that runs its production backend on v7.0. I recommended to upgrade to SQL2K, b/c of the enhancements, developer UDF, XML, etc...
Although they will benefit a lot from SQL2K upgrade, they want to upgrade directly to SQL2K5.....eventually.
Is there any wisdom in going to SQL2K first? What are the pros and cons? What are the primary performance and code considerations when going from 7.0 --> 2000? I recommended that they take this path 70-2000, and then 2005 as its a completely different release. Any thoughts, advice, etc? TIA