difference b/w sqlserver 2000 and sql server 2005

[ali_raza]

i searched couple of site on net to find difference b/w sql server 2000 and sql server 2005 but i did not find good one

can any one have an idea what is difference b/w these two or let me know the web site which descibe teh differecne b/w these two

thanks

[mattyblah]

too many to list. 2005 is a big improvement over 2000 in a lot of areas, imho.

[ali_raza]

Which one is newer and better to use MS SQL server 2000 or SQL server 7.0?

[mattyblah]

Product version goes:

Sql Server 7.0
Sql Server 8.0 (2000)
Sql Server 9.0 (2005)