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 encrypt

13.Can Compress tables and indexes.(Introduced in 2005 SP2)

14.Datetime is used for both date and time.

15.Varchar(max) and varbinary(max) is used.

16.No table datatype is included.

17.SSIS is started using.

18.CMS is not available.

19.PBM is not available.

20.PIVOT and UNPIVOT functions are used.

SQL SERVER 2008:

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

2.XML datatype is used.

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.Can encrypt the entire database introduced in 2008.

--check it(http://technet.microsoft.com/en-us/library/cc278098(SQL.100).aspx)

(http://www.sqlservercentral.com/articles/Administration/implementing_efs/870/)

(http://www.kodyaz.com/articles/sql-server-2005-database-encryption-step-by-step.aspx)

(http://www.sql-server-performance.com/articles/dev/encryption_2005_1_p1.aspx)

(http://geekswithblogs.net/chrisfalter/archive/2008/05/08/encrypt-documents-with-sql-server.aspx)

13.Can compress tables and indexes.

-http://www.mssqltips.com/tip.asp?tip=1582

14.Date and time are seperately used for date and time datatype,geospatial and timestamp with internal timezone

is used.

15.Varchar(max) and varbinary(max) is used.

16.Table datatype introduced.

17.SSIS avails in this version.

18.Central Management Server(CMS) is Introduced.

-http://msdn.microsoft.com/en-us/library/bb934126.aspx

-http://www.sqlskills.com/BLOGS/KIMBERLY/post/SQL-Server-2008-Central-Management-Servers-have-you-seen-these.aspx

19.Policy based management(PBM) server is Introduced.

-http://www.mssqltips.com/tip.asp?tip=1492

-http://msdn.microsoft.com/en-us/library/bb510667.aspx

20.PIVOT and UNPIVOT functions are used.

-http://blog.sqlauthority.com/2008/06/07/sql-server-pivot-and-unpivot-table-examples/