What is difference between Sql server 2005 and 2008
What is difference between Sql server 2005 and Sql server 2008.
Answers (1)
0
| 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. |
http://www.c-sharpcorner.com/Blogs/5451/