Known issues of upgrading from SQL 2000 to SQL 2005

We are looking at upgrading from SQL 2000 ent to SQL 2005 ent and was wondering if there are any known issues, hotfixes, and compatibility with code that was done in VB6. If any one has any information on what known issues are out there that would be great.

Should work fine. If you'd like to see a list of known issues/workarounds/notes/etc. for SQL 2005, go to the support.microsoft.com site and search for SQL Server 2005 articles. There are some considerations to take into account when migrating from 2000 to 2005, but those are more on the server side of things, not the client.

Obviously, there is no guarantee, but this is definately supported and being done elsewhere, so implement a sound testing plan prior to rollout and you should be good to go.

HTH