Sql Server 2005 vs 2008


.Difference between Sql Server 2005 and Sql Server 2008
S.NoSql Server 2005Sql Server 2008
1
XML datatype is introduced.
XML datatype is used.
2
Cannot 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.

Comments