SQL SERVER 2005:

1.Both are combined as SSMS(Sql Server management Studio).

2.XML datatype is introduced.

3.We can create 2(pow(20))-1 databases.

4.Exception Handling

5.Varchar(Max) data type

6.DDL Triggers

7.DataBase Mirroring

8.RowNumber function for paging

9.Table fragmentation

10.Full Text Search

11.Bulk Copy Update

12.Cant...

[font="Arial"]--Reference:

http://stackoverflow.com/questions/198478/advantages-of-ms-sql-server-2008-over-ms-sql-server-2005

SQL SERVER 2000:

1.Query Analyser and Enterprise manager are separate.

2.No XML datatype is used.

3.We can create maximum of 65,535 databases.

4.Nill

5.Nill

6.Nill

7.Nill

8.Nill

9.Nill

10.Nill

11.Nill

12.Nill

13.cant compress the tables and indexes.

14.Datetime datatype is used for...