My company is about to upgrade several fielded systems (3 tier architecture) from SQL 2000 to SQL 2005...well, after we test the conversion that is.
Has anyone out there tested this and found any information/issues they'd like to share?
I've shared one such issue and a workaround in my blog http://www.testingreflections.com/node/view/5833 but you could go directly to MS site describing the difference that may impact code written for MS SQL 2000 http://msdn2.microsoft.com/en-us/library/ms190387.aspx
?:the art of a constructive conflict perceived as a destructive diagnose.
I'd see if there were any data types that were not supported in sql2005 - that existed in sql2000, these may be used in your DB.
I'd also compare the data in both DB's to ensure there has been no unexpected changes.