Quick question about sql server and client tools

[osaddict]

I happily use SQL 2005 Client tools to connect to a SQL 2000 server, my colleagues use SQL 2000 Client tools to connect to the SQL 2000 server...

However, we are moving to a new server with 2005 SQL Server installed - I have the 2005 client tools, so no worries there - but will they be able to connect to it with the 2000 client tools, and if so will there be any problems / pitfalls of doing so?

(I did google but not much cropped up - perhaps someone can shed some light?!)

Thanks!

[kryyst]

I don't know if there are any issues. But I'd suggest not messing around and upgrade your colleagues to the 2005 client tools.

[Thrax]

I would do the same. I don't know how MsSQL works when compared to MySQL, but it seems logical.

[sharkydart]

As far as I know, they will need to install the 2005 tools. And make sure they *get the service pack*, or else bad stuff happens... like failing imports from delimited files ;P

here ya go:SQLServer2005SP1-KB913090-x86-ENU.exe (http://www.microsoft.com/downloads/details.aspx?familyid=CB6C71EA-D649-47FF-9176-E7CAC58FD4BC&displaylang=en)

...and since it's been a month since the last post, hopefully you've done this already