Friday, January 31, 2014

Diff Between 2005 & 2008 Sql server.


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.

No comments:

Post a Comment