Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Installing "SQL Server 2000 Client" and "SQL Server 2000 service pack 4".

I am new to SQL server and want to know if both are different and the exact steps that i need to follow for installation. Please advice.

share|improve this question

closed as too localized by Jack Douglas Sep 6 '12 at 9:46

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

Yes, they are both different. One is the client tools, the other is an update to the server. Why on earth would you want to install software that is already 12 years old? – datagod Jan 18 '12 at 8:30
Considering the age of the software you are trying to install, I'm closing this as TL as it is unlikely to be of interest to a very wide audience – Jack Douglas Sep 6 '12 at 9:46

The SQL Server 2000 Client is the driver, admin and query tools. The service pack is an update for the tools and the server.

I'd recommend looking at a newer version. Your options are SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and the soon to be released SQL Server 2012.

share|improve this answer
Chances are the OP is getting maintenance of a legacy system shoved on them. – ConcernedOfTunbridgeWells Jan 18 '12 at 9:23

Not the answer you're looking for? Browse other questions tagged or ask your own question.