25 September 2014

Difference betweeb SQL Server 2005 and 2008


S. NoSQL Server 2005SQL Server 2008
1XML datatype is introduced.XML datatype is used.
2Can not encrypt the entire database.Can encrypt the entire database introduced in 2008.
3Datetime is used for both date and time.Date and time are seperately used for date and time
4No table datatype is included.Table datatype introduced.
5SSIS is started using.SSIS avails in this version.
6CMS is not available.
Central Management Server(CMS) is Introduced.
7PBM is not available
Policy based management(PBM) server is Introduced.