I am a C# Asp.Net Developer with little knowledge in SQL. I myself had a question what is the difference between SQL server 2000 & SQL 2005. Not only me , more Developer have the same Question . So i analysed surffing in the net mostly from SQLServerCentral an Excellant site for SQL, i have provided a major differnces in tabular form.
First we can discuss the Adminsitrative Differences one by one
The Development differences are more in SQL 2005 which make the major differnces & advantages than SQL Server 2000.
Now we can easily answer the questions regarding the differences in SQL 2000 & SQL 2005