Difference between Sql server 2005 and 2008

By Purushottam Rathore Jun 13, 2011
Difference between Sql server 2005 and 2008.
There are some differences between both.
Sr No SQL Server 2005 SQL Server 2008
1 XML datatype is introduced. XML datatype is used.
2 Can not encrypt the entire database. Can encrypt the entire database introduced in 2008.
3 Datetime is used for both date and time. Date and time are seperately used for date and time
4 No table datatype is included. Table datatype introduced.
5 SSIS is started using. SSIS avails in this version.
6 CMS is not available.

Central Management Server(CMS) is Introduced.

7 PBM is not available

Policy based management(PBM) server is Introduced.

Purushottam Rathore
Purushottam Rathore

I am working as a Software Developer and has 6 years of experience on Microsoft Technology and having a Master Degree in Computer Application. I really like to work in the .NET platform. and working with ASP.NET 2.0/3.5/... Read more