What is the recommended approach regarding the client tools and
application connectivity in a mixed environment where we have SQL
Server 2000 and are starting to migrate to SQL Server 2005. We will
have a parallel environment of 2000 and 2005 and we have .NET
developers that will need to access and test both versions with their
applications. What is the preferred or recommended way to handle
this? Any issues, gotchas, etc?

Hi Spencer,

If you are asking about using the client application for connecting to SQL
Server then my recommendation would be to use SQL Server 2005 client tools.
They are downward compatible with SQL Server 2000 as well but SQL Server 2000
client components are not upward compatible with SQL Server 2005.

SQLTip: Find out if you should rebuild indexes or defrag them:
http://www.sqlcommunity.com/Default....id=14&tabid=56

Thank you,
Saleem Hakani
HTTP://WWW.SQLCOMMUNITY.COM (World Wide SQL Server Community)
SQLTips, Scripts, Discussions, Blogs, Articles, Radio and a lot of SQL
Server Fun.


"Spencer" wrote: