| S. 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.
|