no, i'm not asking which is better or anything like that. basically, i'm used to working with SQL Server 2000 in association to website design and storing information ... i don't know a deep level of understanding when it comes to database administration ... i don't know TSQL. there is a lot about SQL Server 2000 that i don't know and i'm guessing reading a book on SQL Server 2000 would help me.

my question is ... i know nothing about SQL Server 2005 ... does it have an Enterprise Manager the same as 2000? would learning about SQL Server 2005 help you know more about SQL Server 2000 or is it more like the other way around or neither?

in answer to my own question, Enterprise Manager is gone ... it's replaced with SQL Server Management Studio.

both are same, if you are a beginner,
but if you are an expert then difference comes in picture.

SQL Technical Consultant

In my opinion, for learning-purposes I would recommend first getting some exposure/experience with SQL Server 2000. Why do I say this? Because like most commercial software products, each new version is an enhancement to the older/pre-existing version. For example, in the replication sub-system, SQL Server 2005 includes several updates to the system over SQL Server 2000's, but you wont be able to appreciate those updates if you just learned 2005's first nor would their importance be emphasized to you. Just my 2 cents :)