Difference between SQL Server 2005 and 2008

Question

Hi  I want to know that what is the difference between SQL Server 2005 and 2008?

Jignesh Trivedi · Answer

hi SQL 2005 Cannot encrypt Can Compress tables and indexes.(Introduced in 2005 SP2) Datetime is used for both date and time. No table datatype is included. SSIS is started using. Central Management Server(CMS) is not available. Policy based management(PBM) is not available. sql 2008 Can encrypt the entire database introduced in 2008. Can compress tables and indexes Date and time are seperately used for date and time datatypegeospatial and timestamp with internal timezone is used. Table datatype introduced. SSIS avails in this version. Central Management Server(CMS) is Introduced. Policy based management(PBM) server is Introduced. hope this help.